problem with cellFormat in vb.net

See more:

DataGridView

formatting

hello everybody,

i have problem with DefaultCellStyle in datagridview,

i have 3 column in my bank(Access) and i want when those records come to my datagridview change their format ,

for example their format is 12000 but i want to change their format in datagridview like 12,000. this is my code "

da.SelectCommand = New OleDbCommand()

        With da.SelectCommand
            .Connection = my_con
            .CommandType = CommandType.Text
            .CommandText = "Select p_name,p_fname,p_mablagh from table1"

            If .Connection.State <> ConnectionState.Open Then
                .Connection.Open()
            End If
        End With

        Dim ds As New Database2DataSet
        da.Fill(ds.Table1)
        Me.DataGridView1.DataSource = ds.Table1
        my_con.Close()
        Me.DataGridView1.Columns(2).DefaultCellStyle.Format = "##,0"

first :

[URL=http://img4up.com/][IMG]http://img4up.com/up2/47117885029305385819.jpg[/IMG][/URL]


want this "

[URL=http://img4up.com/][IMG]http://img4up.com/up2/81408470236125767939.jpg[/IMG][/URL]


my english is not very well please help me.

thanks a lot