Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transactions
Message
From
29/07/2002 13:05:20
 
General information
Forum:
ASP.NET
Category:
ADO.NET
Title:
Miscellaneous
Thread ID:
00683519
Message ID:
00683602
Views:
46
No, it's all done in code. Something like this (this is in C#, sorry about that <g>):
MyDataSet ds = new MyDataSet();

// -- Already have a connection object, oConnection
SqlCommand sc = new SqlCommand("csp_GetMyData", this.oConnection);
sc.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(sc);

int iRows = da.Fill(ds)
That's it ... pretty straight-forward.

~~Bonnie


>Lets take a step backwards... how do you go about creating a dataadapter? Do you use the visual tools?
>
>>Well, one of us must be missing something here ... I'm not sure what kind of column mapping needs to be done when Filling a DataSet. I'm not doing any column mapping and AFAIK none is necessary. Could you elaborate please?
>>
>>~~Bonnie
>>
>>
>>>>Hmmm ... ok, that makes sense ... but lemme ask you ... what's the *point* of doing this? What's wrong with just using the DataAdapter.Fill() method?
>>>>
>>>
>>>Because you have to go through the task of column mapping? Or, have you found an easy way to handle mapping?
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform