Datareader.NextResult in stored Procedure

Question

0.00/5 (No votes)

See more:

Hi
Is it possible to get the result of the 2nd Query of a stored procedure
When running the Stored on MySql it give 2 result but when applying it on my App
this is my VB.NET Code for ASP.NET

VB

Using DataRead As MySqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)
    If DataRead.HasRows() Then
        dt.Load(DataRead)
        If DataRead.HasRows Then
            If DataRead.Read Then
                Dim result As String = DataRead.GetString(0)
                Dim name As String = DataRead.GetString(1)
                DataRead.Close
            End If
        End If
    End If
End Using

Do I need to Close the DataReader if I only Load it to a datatable

VB

Using DataRead As MySqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)
    If DataRead.HasRows() Then
        dt.Load(DataRead)
    End If
End Using

Does the Connection automatically closed using the cmd.ExecuteReader(CommandBehavior.CloseConnection) ?

Posted 2-Oct-13 17:46pm

iMaker.ph

Updated 2-Oct-13 17:57pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Madhu Nair · Accepted Answer · 2013-10-02T18:05:00

Solution 1

Connection will be closed automatically using "Using".

If you want to store multiple result then the preferred way will be populating dataset instead of datareader. You can access the result using the index of the datatable starting from zero. For eg:

dsFill.Tables[0].Rows.Count;

Posted 2-Oct-13 18:05pm

Madhu Nair

Comments

iMaker.ph 4-Oct-13 5:54am

How about using Datareader how can I get the same result. From what I understand Datareader is much faster due to its read only..

Btw thanks I get your point.. :) just wanna try using DataReader..

Madhu Nair 4-Oct-13 6:00am

:)... Please let me know also if you find any solution using Datareader