datagrid

[EyeTalion]

I need a DataGridTableStyle to format some of the columns in my grid. I'm using the code below, but it's not working...not sure where the code goes for it to function...can someone shed some light....

Dim objTableStyle As DataGridTableStyle
        Dim objColumn As DataGridTextBoxColumn
 
        objTableStyle = New DataGridTableStyle()
 
        objColumn = New DataGridTextBoxColumn()
        objColumn.MappingName = "Col1"
        objColumn.HeaderText = "First"
        objTableStyle.GridColumnStyles.Add(objColumn)
        intLastColumnWidth -= objColumn.Width
 
        objColumn = New DataGridTextBoxColumn()
        objColumn.MappingName = "Col2"
        objColumn.HeaderText = "Second"
        objTableStyle.GridColumnStyles.Add(objColumn)
        intLastColumnWidth -= objColumn.Width

[Lunatic3]

Did you define the datagird datasource?

[EyeTalion]

I got it working...thanks Lun

one of the fields in my grid is a date, but it's coming over with the time...you know how I can format this?

[Lunatic3]

Not tested but may be this helps:

Me.DataGridTextBoxColumn1.Format = "d" ' d stands for short date format

Or you may use other custom format strings.

[EyeTalion]

sweet...it worked!

Dim grdColStyle2 As New DataGridTextBoxColumn()
        With grdColStyle2
            .HeaderText = "Purchase Date"
            .MappingName = "purchase_date"
            .Alignment = HorizontalAlignment.Center
            .ReadOnly = True
            .Format = "d"
        End With