datagrid format

[EyeTalion]

I'm need to add a $ to one of my fields in the datagrid...heres the code I'm using to format the cell and get the data....anyone tell me how to add a $ to this field?

Dim grdColStyle4 As New DataGridTextBoxColumn()
        With grdColStyle4
            .HeaderText = "Receipt Amt"
            .MappingName = "transaction_amt"
            .Width = 100
            .Alignment = HorizontalAlignment.Center
            .ReadOnly = True
        End With

[Lunatic3]

If the field is numeric this should do.

Dim grdColStyle4 As New DataGridTextBoxColumn()
        With grdColStyle4
            .HeaderText = "Receipt Amt"
            .MappingName = "transaction_amt"
             [b].Format="#$"[/b]
            .Width = 100
            .Alignment = HorizontalAlignment.Center
            .ReadOnly = True
        End With

[EyeTalion]

thank you.


the way you had it puts the $ sign behind the amount
.Format="$#"

[Lunatic3]

Originally posted by EyeTalion
thank you.


the way you had it puts the $ sign behind the amount
.Format="$#"

?? My code puts after, (.Format="#$")

[EyeTalion]

the amount came out like this is the datagrid....


10.21$

I changed the format property and it came out right.

[EyeTalion]

is there a way to use .Format = "$#", if the field can be null....I don't want a $ sign in the cell if theres no data?

[Lunatic3]

Originally posted by EyeTalion
is there a way to use .Format = "$#", if the field can be null....I don't want a $ sign in the cell if theres no data?

I am not aware of any way. Why dont you format the field while selecting from the database? There you can put the $ if its not null.

[RichardAtherton]

use null.text = "" and the field will be blank, or null.text = "$0.00" and that will appear

[EyeTalion]

doesn't seem to be working...is this right?

With grdColStyle5
            .HeaderText = "Sales Tax"
            .MappingName = "sales_tax_amt"
            .NullText = ""
            .Format = "$#"
            .Width = 75
            .Alignment = HorizontalAlignment.Center
            .ReadOnly = True

[RichardAtherton]

Here is a full working example, showing what I mean, different coding style to yours but the same elements
Dim t1 As New DataGridTableStyle
t1.MappingName = "BankRecs"
' Add Date
Dim r3 As New DataGridTextBoxColumn
r3.MappingName = "Date"
r3.HeaderText = "Date"
r3.TextBox.TextAlign = HorizontalAlignment.Center
r3.Format() = "dd/MM/yyyy"
r3.Width = 80
r3.NullText = ""
t1.GridColumnStyles.Add(r3)

' Add Reference
Dim r4 As New DataGridTextBoxColumn
r4.MappingName = "Reference"
r4.HeaderText = " Reference"
r4.Width = 90
r4.NullText = ""
t1.GridColumnStyles.Add(r4)
' Add Debit Amount
Dim r5 As New DataGridTextBoxColumn
r5.MappingName = "DebitAmount"
r5.HeaderText = " Debit"
r5.TextBox.TextAlign = HorizontalAlignment.Right
r5.Format() = "##,##0.00"
r5.Width = 90
r5.NullText = ""
t1.GridColumnStyles.Add(r5)
' Add Credit Amount
Dim r6 As New DataGridTextBoxColumn
r6.MappingName = "CreditAmount"
r6.HeaderText = " Credit"
r6.TextBox.TextAlign = HorizontalAlignment.Right
r6.Format() = "##,##0.00"
r6.Width = 90
r6.NullText = ""
t1.GridColumnStyles.Add(r6)

' Add account
Dim r1 As New DataGridTextBoxColumn
r1.MappingName = "Account"
r1.Width = 0
r1.NullText = ""
t1.GridColumnStyles.Add(r1)
' Add Timestamp
Dim r2 As New DataGridTextBoxColumn
r2.MappingName = "TimeStamp"
r2.Width = 0
r2.NullText = ""
t1.GridColumnStyles.Add(r2)
' Add TranType
Dim r7 As New DataGridTextBoxColumn
r7.MappingName = "TranType"
r7.Width = 0
r7.NullText = ""
t1.GridColumnStyles.Add(r7)
DataGrid1.TableStyles.Add(t1)