12-19 - MARS

kazuma · February 12th, 2008, 11:51 AM

Since I'm using the code behind model there is no <script runat="server>

My problem is that the second event: gvOrders_RowDataBound does not recognize the DBCon that was made in the previous Page_Load event.

I guess this code is supposed to let the transfer happen:

Code:

        Command.CommandType = CommandType.Text;
        Command.Connection = DBCon;

        // Opening the connection and executing the SQL query. 
        DBCon.Open();
        OrdersReader = Command.ExecuteReader();

        // Binding the Data Reader to the GridView control
        gvOrders.DataSource = OrdersReader;
        gvOrders.DataBind();

dparsons · February 12th, 2008, 11:56 AM

I do not have the book in front of me, but if you declare DBCon in your page load, that variable will only be accessible to the Page Load event. Example:

Protected Sub Page_Load(sender as object, e as eventargs)
   Dim DBCon as New SqlConnection() 'This makes DBCon accessible only to the Page_Load method
   '...code
End Sub

Protected Sub gvOrders_RowDataBound(sender as object, e as GridViewRowEventArgs)
        Command.CommandType = CommandType.Text;
        Command.Connection = DBCon; 'Error

        // Opening the connection and executing the SQL query.
        DBCon.Open(); 'Error
        OrdersReader = Command.ExecuteReader();

        // Binding the Data Reader to the GridView control
        gvOrders.DataSource = OrdersReader;
        gvOrders.DataBind();
End Sub

The resolution would be to add
Dim DBCon as New SqlConnection()

to your DataBound event or to declare DBCon as a class level member, which I would advise against.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

kazuma · February 12th, 2008, 12:12 PM

Thanks, I thought about creating the object again in the next method.

However, and I might be wrong, I thought the whole point of Multiple Active Result Sets is that we use the same connection. This would mean that I wouldn't need to create a new connection object for the next method.

Here's what the book has:

Code:

protected void Page_Load(object sender, EventArgs e)
{
...
        SqlConnection DBCon;

        DBCon = new SqlConnection();
...
        Command.Connection = DBCon;

        // Opening the connection and executing the SQL query. 
        DBCon.Open();
        OrdersReader = Command.ExecuteReader();

        // Binding the Data Reader to the GridView control
        gvOrders.DataSource = OrdersReader;
        gvOrders.DataBind();

        // Closing connection after we are done processing all order records
        DBCon.Close();
}

protected void gvOrders_RowDataBound(object sender, GridViewRowEventArgs e)
{
...
        // Reusing the same connection object that was used in retrieving 
        // allorder records from the Orders table
        Command.Connection = DBCon;

        // Executing SQL query without passing CommandBehavior.CloseConnection 
        // as parameter to ExecuteReader. We don't want the connection
        // to automatically close because we want to reuse it for more operations
        OrderDetailReader = Command.ExecuteReader();
...
}

Supposedly, the gvOrders_RowDataBound method should receive the data source before the connection is closed in the first method.

dparsons · February 12th, 2008, 12:29 PM

MARS is not my area of expertise but, it is my understanding, that MARS simply allows you to execute multiple batches per connection what you are doing is trying to access an object that is out of scope in the DataBound method which is a violation of VB and has nothing to do with MARS.

Nevertheless, the RowDataBound event is firing as the GridView is being bound to the datasource from within your Page_Load.

Someone more familiar with the book should weigh in on what the intent of the code in the DataBound method.

Not sure if this has helped you any.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

kazuma · February 12th, 2008, 12:47 PM

Hmmm, I'm not sure what the book was getting at then :)

I figured that

Code:

gvOrders.DataSource = OrdersReader;

somehow transported the connection object to the gvOrders. Maybe an object wasn't supposed to be transported. What you're saying makes sense, the object doesn't get transported. I suppose some underlying connection gets copied? Not sure.