Ok, here is the code I am using to load my grids. I have two datagrids.
code to load the first grid
--------------------------------------
'clear dataset
objMasterListDataSet.Clear()
objMasterListDA.FillSchema(objMasterListDataSet, SchemaType.Source,
"MasterList")
'fill dataset with info from dataAdapter
objMasterListDA.Fill(objMasterListDataSet, "MasterList")
'removed when deleted true dbgrid
'tdbgMasterItems.DataSource = objMasterListDataSet
'tdbgMasterItems.DataMember = "MasterList"
grdMasterItems.DataSource = objMasterListDataSet
grdMasterItems.DataMember = "MasterList"
' Create new Table Style.
Dim ts As New DataGridTableStyle
ts.MappingName = "MasterList"
grdMasterItems.TableStyles.Clear()
grdMasterItems.TableStyles.Add(ts)
' Assign New Width to DataGrid column.
grdMasterItems.TableStyles("MasterList").GridColum nStyles("Isle").Width = 50
grdMasterItems.TableStyles("MasterList").GridColum nStyles("Item").Width =
160
grdMasterItems.TableStyles("MasterList").GridColum nStyles("Isle").NullText =
"00"
grdMasterItems.TableStyles("MasterList").GridColum nStyles("Item").NullText =
" "
'set master list grid label to total number of records
updateMasterLabel()
code to load the second grid
-------------------------------------------
'clear dataset
objShoppingListDataSet.Clear()
objShoppingListDA.FillSchema(objShoppingListDataSe t, SchemaType.Source,
"ShoppingList")
'fill dataset with info from dataAdapter
objShoppingListDA.Fill(objShoppingListDataSet, "ShoppingList")
grdShoppingList.DataSource = objShoppingListDataSet
grdShoppingList.DataMember = "ShoppingList"
' Create new Table Style.
Dim ts As New DataGridTableStyle
ts.MappingName = "ShoppingList"
grdShoppingList.TableStyles.Clear()
grdShoppingList.TableStyles.Add(ts)
' Assign New Width to DataGrid column.
grdShoppingList.TableStyles("ShoppingList").GridCo lumnStyles("Isle").Width =
50
grdShoppingList.TableStyles("ShoppingList").GridCo lumnStyles("Item").Width =
160
grdShoppingList.TableStyles("ShoppingList").GridCo lumnStyles("Isle").NullTex
t = "00"
grdShoppingList.TableStyles("ShoppingList").GridCo lumnStyles("Item").NullTex
t = " "
grdShoppingList.TableStyles("ShoppingList").AllowS orting = False
'set shopping list grid label to total number of records
updateShoppingLabel()
I appreciate any help
--
Tony
"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:br************@ID-208219.news.uni-berlin.de...
* "TM" <no********@nothing.com> scripsit: I have a small application that displays records from an access mdb into
two datagrids and am looking to see if it is possible to speedup the
loadtime somehow.
In my formload I am filling my dataset and binding it to the datagrids.
Is there a better place to get my grids loaded and speed up the program
loadtime ?
Post some code...
--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>