Post reply

Problem excecuting store thats return multiple result sets

  • October 22, 2013 at 9:05 am

    #279054

    hello

    i have a store procedure that return multiple datasets i want to manipulate one of theses datasets to input in a datatable is this posible and how

    plese help me

  • December 10, 2013 at 1:20 pm

    #1672428

    are you asking about the .net development side of it?

    if yes, you can take a look at this one:

    http://www.codeproject.com/Articles/675933/Returning-Multiple-Result-Sets-from-an-Entity-Fram

    this is using a stored proc in an EF model.

    [font="Courier New"]Aram Koukia: http://www.koukia.ca[/font]

  • 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!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply