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:
01307631
Views:
11
>>I'm a bit confused on something.
>>
>>
>>public void UpdateMyData(DataSet ds)
>>{
>>	// The same applies for the Update. It's not necessary to Open/Close the connection.
>>	SqlDataAdapter da = new SqlDataAdapter("select * from Appusers", this.oConnection);
>>	SqlCommandBuilder sb = new SqlCommandBuilder(da);
>>
>>	da.Update(ds);
>>}
>>
>>
>>If I'm passing a DS to this, then I have already done a query and have updated the data in the DS, so why run
>>another query?
>>
>>Inquiring minds wanna know.
>
>You're not running a query. Just passing the SelectCommand value to the DataAdapter for use by the CommandBuilder.
>Regards,
>Viv

Thanks Viv!
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Previous
Reply
Map
View

Click here to load this message in the networking platform