Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot write to the physical database
Message
From
27/03/2008 00:32:32
 
 
To
26/03/2008 14:04:54
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
VB 9.0
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01305661
Message ID:
01306064
Views:
6
David,

In addition to Viv's suggestions, I should also mention that you don't want to do the NewRow.AcceptChanges(). Once you do that, the DataSet or DataTable won't know that there are any changes to be updated to the back-end database.

~~Bonnie



>>>I'm not sure it's this code, since it works on the surface, so much as it is the connection between the DataSet and the SQL database itself. Especially since there are no SQL commands in the data adaptors. But when I tried putting commands there, the system threw a fit...
>>
>>You're right. There's no "connection" between the Dataset and the Database. You must code the updates yourself.
>
>Well, that at least confirms my hunch, but I'm at a loss as to how to code the updates to the database. I'm used to VFP, where things are already connected.
>
>David
Bonnie Berent DeWitt
NET/C# MVP since 2003

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

Click here to load this message in the networking platform