cheekcn
Mar 8th, 2010, 10:10 AM
What's wrong? I have looked over this bit of code for days. Everything looks right, but my data grid still doesn't get formatted.
Dim conn As SqlConnection = New SqlConnection("Data Source=ADVTIS-DB;Initial Catalog=RainMaker;User ID=sa;")
Dim dataAdapter As SqlDataAdapter = New SqlDataAdapter("Select ID, Description, MfgNum, ProductSize from AT_Product", conn)
Dim dt As DataTable = New DataTable()
dataAdapter.Fill(dt)
DataGrid1.DataSource = dt
Dim tableStyle As New DataGridTableStyle()
tableStyle.MappingName = "AT_Product"
'MfgNum
Dim column As New DataGridTextBoxColumn()
column.MappingName = "MfgNum"
column.HeaderText = "Mfg #"
column.Width = 70
tableStyle.GridColumnStyles.Add(column)
'Item Description
column = New DataGridTextBoxColumn()
column.MappingName = "Description"
column.HeaderText = "Description"
column.Width = 140
tableStyle.GridColumnStyles.Add(column)
'Size
column = New DataGridTextBoxColumn()
column.MappingName = "ProductSize"
column.HeaderText = "Size"
column.Width = 70
tableStyle.GridColumnStyles.Add(column)
Me.DataGrid1.TableStyles.Add(tableStyle)
Dim conn As SqlConnection = New SqlConnection("Data Source=ADVTIS-DB;Initial Catalog=RainMaker;User ID=sa;")
Dim dataAdapter As SqlDataAdapter = New SqlDataAdapter("Select ID, Description, MfgNum, ProductSize from AT_Product", conn)
Dim dt As DataTable = New DataTable()
dataAdapter.Fill(dt)
DataGrid1.DataSource = dt
Dim tableStyle As New DataGridTableStyle()
tableStyle.MappingName = "AT_Product"
'MfgNum
Dim column As New DataGridTextBoxColumn()
column.MappingName = "MfgNum"
column.HeaderText = "Mfg #"
column.Width = 70
tableStyle.GridColumnStyles.Add(column)
'Item Description
column = New DataGridTextBoxColumn()
column.MappingName = "Description"
column.HeaderText = "Description"
column.Width = 140
tableStyle.GridColumnStyles.Add(column)
'Size
column = New DataGridTextBoxColumn()
column.MappingName = "ProductSize"
column.HeaderText = "Size"
column.Width = 70
tableStyle.GridColumnStyles.Add(column)
Me.DataGrid1.TableStyles.Add(tableStyle)