I fill a lot of grids (fpSpread) in my program.
I fill all of these grids with every field in the table so that it is Select * from table
Now I am trying to fill a grid, using the same code, but my select statement does not include all the fields in the table.
There is a record in my table, and it shows there is a record when I check dataset tables, but the grid won't fill.
Please tell me what I am doing wrong and provide an example.
Function FillSpread() As DataTable
Dim ds As New DataSet
If DatabaseToUse() = BizObjs.DBType.Access Then
Dim dc As New OleDb.OleDbConnection(ConnectionString)
Dim da As New OleDb.OleDbDataAdapter(SelectStatement, dc)
Catch ex As Exception
'Returns as datasource to the grid