Dataset receiving multiple tables from a stored procedure.

Reply

DOBius Posted: 11-06-2007 7:05 PM

rated by 0 users

Can anyone help me this my problem?

stored proc:

---------------------------------- 

select * from table1

select * from table2

select * from table3

-----------------------------------

recieving code ............

            Dim DataAdapter As SqlDataAdapter = New SqlDataAdapter()
            DataAdapter.SelectCommand = Command

            Dim ds As DataSet = New DataSet
            Con.Open()
            DataAdapter.Fill(ds, "Table")

my problem is that ds(dataset) only recieve one table result... i believe that datasets could contain multiple tables.. 

thanks in advance 

Reply

keithrull replied on 11-06-2007 7:41 PM

rated by 0 users

DOBius:

Can anyone help me this my problem?

stored proc:

---------------------------------- 

select * from table1

select * from table2

select * from table3

-----------------------------------

recieving code ............

            Dim DataAdapter As SqlDataAdapter = New SqlDataAdapter()
            DataAdapter.SelectCommand = Command

            Dim ds As DataSet = New DataSet
            Con.Open()
            DataAdapter.Fill(ds, "Table")

 

my problem is that ds(dataset) only recieve one table result... i believe that datasets could contain multiple tables.. 

 

thanks in advance 

The problem is this line : DataAdapter.Fill(ds, "Table")

remove the "Table" part and it should work. basically what happens is that since you are assigning a name to the Datatable on the Dataset it creates only 1 table with the name Table.

HTH