Filling a DataGrid with a DataSet

[WayneM]

I have compact framework app that I was trying to test out on a windows form,
but I cannot get past the very first step of simply filling a DataGrid from a
DataSet. My code is

Dim sqlStmt As String = "Select VendorName, StartWeek from InventorySchedu le
Where FinishDate is Null and StartWeek<'" & Now & "'"
Dim cmdDB As New SqlCommand(sqlS tmt, connDB)
Dim dgridTarget As New DataGrid
Dim adapter As New SqlDataAdapter( )
Dim ds As New DataSet
' create the table style in the grid
Dim dgtsStyle As DataGridTableSt yle
Dim dgtsColumn As DataGridTextBox Column
dgtsStyle = New DataGridTableSt yle

' set the tablestyle mapping to the table name
With dgtsStyle
.MappingName = "VendorsToCount "
End With

dgtsColumn = New DataGridTextBox Column
dgtsColumn.Mapp ingName = "VendorName "
dgtsColumn.Head erText = "VName"
dgtsColumn.Widt h = 100
dgtsStyle.GridC olumnStyles.Add (dgtsColumn)

dgtsColumn = New DataGridTextBox Column
dgtsColumn.Mapp ingName = "StartWeek"
dgtsColumn.Head erText = "Start"
dgtsColumn.Widt h = 100
dgtsStyle.GridC olumnStyles.Add (dgtsColumn)

' add the style to the datagrid
dgridTarget.Tab leStyles.Add(dg tsStyle)

' open the connection
connDB.Open()

adapter.SelectC ommand = New SqlCommand(sqlS tmt, connDB)
adapter.Fill(ds )

dgridTarget.Vis ible = True
dgridTarget.Set DataBinding(ds, "VendorsToCount ")

I need to use the Datagrid, because it is supported on the CF, where this
app will be deployed.

I am simply creating a dataset and binding it to the Datagrid. What am I
missing here?

Thanks for any help,

WayneM

[Spam Catcher]

=?Utf-8?B?V2F5bmVN?= <Wa****@discuss ions.microsoft. comwrote in
news:DD******** *************** ***********@mic rosoft.com:

Dim sqlStmt As String = "Select VendorName, StartWeek from
InventorySchedu le Where FinishDate is Null and StartWeek<'" & Now &
"'"

Slightly OT, but you should use SQLParameters to prevent a SQL injection
attack.