Fill a datagrid with a datareader ?

**dbelley_office** · May 11th, 2006, 08:32 AM

Hi,

In VB.NET 2003.

Is it possible to fill a datagrid with a datareader?

Code:

'This line works ..  data are correctly read.
sqlDataReader = sqlCommand.ExecuteReader

'This line crashes .. 
grdGrid.DataSource = sqlDataReader

I get the error:
Error : Complex DataBinding accepts as a data source either an IList or an IListSource

**jmcilhinney** · May 11th, 2006, 09:03 AM

That works with the WebForms DataGrid but not the WinForms version. You need to populate a DataTable and bind that.

**dbelley_office** · May 11th, 2006, 09:09 AM

Ok thanks.

That is what I did.

Thread: Fill a datagrid with a datareader ?