multiple resultsets via DataAdapter ?

[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

 

[William Ryan]

If you use multiple select statements and then adjust the tableamappings, I
think it should get you what you want.

 

[Ashish]

If you use multiple select statements and then adjust the tableamappings, I
think it should get you what you want.

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 Ryan]

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

 

[Ashish]

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

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