Binding RadGrid to a SqlDataReader with multiple result sets

[LACDA-IT]

I have a stored procedure which returns multiple result sets. The code calls the procedure with ExecuteReader(CommandBehavior.CloseConnection), and then proceeds to fill several grids, as follows:

thisgrid.DataSource = dr
thisgrid.DataBind()
dr.NextResult()
thatgrid.DataSource = dr
thatgrid.DataBind()
dr.NextResult()
theothergrid.DataSource = dr
theothergrid.DataBind()
dr.NextResult()

Up until now, we've been using Infragistics grids. But now we're converting to Telerik, and I'm running into a problem. After the first grid is bound, the DataReader closes, and the call to NextResult() results in a "reader is closed" error.

So, my first question is, how do I tell the DataBind method, "Hey, don't close that connection - there are more result sets coming"?

I know that if I remove CommandBehavior.CloseConnection from the ExecuteReader command, the DataReader stays open, but then I'm left with an open connection. So my second question is, how do insure that the connection gets closed? Is it automatically closed when the DataReader closes?

[Konstantin Dikov]

Hello Grinnell,

Since RadGrid will work with the data that is provided to it, you can not specify how that data will be proceeded. When binding a grid by setting the DataSource property, the only condition is to set the DataSource property to an instance of the following types:

• DataSet, DataTable, or DataView;
• Array of DataRow;
• Any object collection that implements the IListSource, IList, IEnumerable, or ICustomTypeDescriptor interface.

With the above clarification and due to the fact that RadGrid can not force the connection to stay open, the only thing that I can suggest is that you close your connection within the Page's PreRender event for example or in any other event that will fire after all grids are data bound. 

Hope this helps.



Regards,
Konstantin Dikov
Telerik