Populate 2 or more datagrids from one OleDBCommand

[Simon Harris]

Hi All,

I wish to populate more than one datagrid from the same OleDBCommand. The
code I have is:

Dim objCmd As New OleDbCommand(st rSql, objConn)

Then...

Me.dgTariffHoli dayHomesBand1.D ataSource = objCmd.ExecuteR eader()
Me.dgTariffHoli dayHomesBand1.V isible = True
Me.dgTariffHoli dayHomesBand2.D ataSource = objCmd.ExecuteR eader()
Me.dgTariffHoli dayHomesBand2.V isible = True

I get this error when the second call to objCmd.ExecuteR eader() is called:
System.InvalidO perationExcepti on: ExecuteReader requires an open and
available Connection.

The reason for populating multiple grids from the same data, is that I am
calling ALL columns in the SQL, and then using (for example) columns A and
B
in DG1, C and D in DG2...and so on.

Surely I don't need a new recordset for each datagrid???

Simon.

[DalePres]

There are a couple problems with your approach.

First, the ExecuteReader method requires that you close and re-open the
connection, just as the code implies but you can't use a DataReader as the
DataSource for a DataGrid. You need something that implements IList or
IListSource. You can research both of those interfaces in the MSDN Library
to see what classes implement them.

Another problem is that you're making two queries to the database and
populating the DataGrids sequentially. What happens if the data changes
between calls? You can't be sure the data in the DataGrids will match.
What you need to do is get the data once, using a DataSet or even a
DataTable and set both DataGrids to use the same DataSource.

Hope this helps,

DalePres
MCAD, MCSE, MCDBA
"Simon Harris" <to***********@ makes-you-fat.com> wrote in message
news:OD******** ******@TK2MSFTN GP11.phx.gbl...

Hi All,

I wish to populate more than one datagrid from the same OleDBCommand. The
code I have is:

Dim objCmd As New OleDbCommand(st rSql, objConn)

Then...

Me.dgTariffHoli dayHomesBand1.D ataSource = objCmd.ExecuteR eader()
Me.dgTariffHoli dayHomesBand1.V isible = True
Me.dgTariffHoli dayHomesBand2.D ataSource = objCmd.ExecuteR eader()
Me.dgTariffHoli dayHomesBand2.V isible = True

I get this error when the second call to objCmd.ExecuteR eader() is called:
System.InvalidO perationExcepti on: ExecuteReader requires an open and
available Connection.

The reason for populating multiple grids from the same data, is that I am
calling ALL columns in the SQL, and then using (for example) columns A and
B
in DG1, C and D in DG2...and so on.

Surely I don't need a new recordset for each datagrid???

Simon.