multiple resultsets via DataAdapter ?

  • Thread starter Thread starter Ashish
  • Start date Start date
A

Ashish

Hi all,
i have discussed this topic on the news group before, and found it very
helpful, now that iam implementing something, i see some problems,
iam trying execute a stored proc on SQL Server, and trying to get
multiple resultsets,
Iam using the oledbdataadapter class's fill method, the data tables are
all created correctly but none of them are having any results in them,
except the first one ,although i know other tables are having rows in them,
i have seen examples in Bill Vaugh's paper, using DataReader, can i do
the same using DataAdapter ?

any help ,pointer would be appreciated
thanks
-ashish
 
If you use multiple select statements and then adjust the tableamappings, I
think it should get you what you want.
 
William said:
If you use multiple select statements and then adjust the tableamappings, I
think it should get you what you want.
Click to expand...
thanks Bill,
i think thats the problem, but when i create table mappings, would the
first table be "Table" or "Table1" assuming i use .Fill (ds, "table "),
also is datatablemapping case sensitive ?


-ashish
 
William said:
Check out this link..it addresses everythign you
want...http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndi
ve/html/data03142002.asp

Not sure about the Case sensitivity, but I'm guessing that it probably is
since it's a string literal. I'm kind of busy right now, but when I get a
few minutes at lunch, I'll play with it and see what I can come up with.

Cheers,

Bill


tableamappings, I
Click to expand...
thanks bill,
i dont think it is case sensitive cuz iam able to get the records, iam
not sure if its creating the datarelations, but i think i need to do
more homework on that !
thanks again
-ashish
 
Back
Top