[2005] Loading data on datagridview

[aldrean]

Dim dbReader As OleDbDataReader = dbCommand.ExecuteReader
             ComboBox1.Items.Clear()
 
            While (dbReader.Read)
             ComboBox1.Items.Add(dbReader("PatientID"))
 
             End While

I am using this code to load the combobox with all PatientID on a certain table of my access database.It was doing fine and now want to load the data in a datagridview.how can I possibly do this?One more thing, what if I also want to load the Name("PatientName") in the grid along with its ID?thanks in advance....

[jmcilhinney]

If you want to dispay data in a grid then I suggest that you don't use a data reader. I'd suggest using a data adapter to Fill a DataTable and then simply assign the DataTable to the grid's DataSource property.

[aldrean]

i had tried using the wizard for the grid's datasource, using the dataset as my source, I just find it too slow to load the grid(about 8seconds) for a merely 20K records.Did it really had to be that long?That is the reason why I wanted for another option, or somebody can please let me know how can I possibly minimize the loading time?

[mizee]

If you want to dispay data in a grid then I suggest that you don't use a data reader. I'd suggest using a data adapter to Fill a DataTable and then simply assign the DataTable to the grid's DataSource property.

instead of assigning the datasource to DataTable .. is it ok to assign the datasource to DataSet?

[jmcilhinney]

instead of assigning the datasource to DataTable .. is it ok to assign the datasource to DataSet?

Do you actually understand what a DataSet is? A DataSet is not a substitute for a DataTable. A DataSet cannot be of any use unless it contains one or more DataTables because it's the DataTables that contain the data. You ALWAYS have to bind your controls to a DataTable one way or another. If your DataTable is in a DataSet then you can bind it directly:

myControl.DataSource = myDataSet.Tables("table name here")

or indirectly:

myControl.DataMember = "table name here"
myControl.DataSource = myDataSet

[mizee]

Do you actually understand what a DataSet is? A DataSet is not a substitute for a DataTable. A DataSet cannot be of any use unless it contains one or more DataTables because it's the DataTables that contain the data. You ALWAYS have to bind your controls to a DataTable one way or another. If your DataTable is in a DataSet then you can bind it directly:

myControl.DataSource = myDataSet.Tables("table name here")

or indirectly:

myControl.DataMember = "table name here"
myControl.DataSource = myDataSet

ok got it. Thanx.