Yep, it works for me. I kept running into problems before. IAC, what if you have multiple tables in the dataset? How do you handle that as well as updates right now???
>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?