Home Forums SQL Server 2005 SQL Server Newbies Problem excecuting store thats return multiple result sets RE: Problem excecuting store thats return multiple result sets

  • December 10, 2013 at 1:37 pm

    #1672431

    basically, you assign the results to a DataSet; since a DataSet contains a collection of DataTable,s you can then iterate through each datatable, or assign, say a grid's datasource to DataSet.Tables[0], for example.

    Dim ds As New DataSet

    ds = SqlHelper.ExecuteDataset(Me.ConnectionString, CommandType.Text, sql)

    For Each dt As DataTable In ds.Tables

    'do something with the results, like export?

    Next

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!