Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sending Changes From A Dataset To The DB
Message
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Miscellaneous
Thread ID:
01306720
Message ID:
01306866
Views:
3
>>>I have a method that receives a changed record as XML:
>>>
>>>
>>>public void UpdateUser(string sUserXML)
>>>{
>>>
>>>    StringReader oReader = new System.IO.StringReader(sUserXML);
>>>    DataSet oDataSet = new DataSet();
>>>    oDataSet.ReadXml(oReader);
>>>
>>>}
>>>
>>>
>>>How do I get the changes back to the database?
>>
>>The best answer depends on a few things.
>>Is the database MSSQL?
>>How did you obtain/create the original dataset?
>>Regards,
>>Viv
>
>
>1) The DB is MSSQL
>2) I am using the scenerio I described in past threads - a Client side class making a call through a WS
>which returns the data as XML. The XML is the reconverted back to a DS, changed, and passed back through
>the WS to the server AS XML, reconverted back to a DS as above.

I see that Bonnie has (as usual) given a comprehensive answer. The only thing I would add is that, since you have no existing infrastrucuture, you might want to look at using Linq with DataContexts as an alternative. It may lack a little flexibility but is far, far simpler to implement.

Regards,
Viv
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform