Execute multiple queries with SqlDataReader 1

[iaswnidou]

Hello

I have a method that returns a datareader as this:

Protected Function SelectReader(ByVal SQL As String) As SqlDataReader
        objCmd.CommandText = SQL
        Dim rdr As SqlDataReader

        Try
            OpenConnection()
            rdr = objCmd.ExecuteReader(CommandBehavior.CloseConnection)
        Catch exSQL As SqlException
            errorMsg = exSQL.Message
            NotifyAdmin("SelectReader", SQL, errorMsg)
        Catch ex As Exception
            errorMsg = ex.Message
            Throw ex
        Finally
            objCmd.Dispose()
        End Try

        Return rdr
    End Function

Can i feed it with a SQL string as this?

"Select a from b;select c from d;"

When i execute this, only "a" is returned. Is it possible to execute multiple queries? (in asp.net 1.1)

 

[Veep]

Google this: SqlDataReader.NextResult()


Vince

 

[iaswnidou]

Thanks Vince, problem solved.

 

[ralphtrent]

iaswnidou, Can you provide a sample of how you used SqlDataReader.NextResult. I would be interested in seeing that.

Thanks

 

[ca8msm]

Here's a simple article on it's usage:

http://www.code101.com/Code101/DisplayArticle.aspx?cid=15

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.