Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot write to the physical database
Message
From
26/03/2008 14:20:41
 
 
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:
01305843
Views:
7
>>>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.

Hi,
Several options. You could use a DataAdapter. e.g. http://support.microsoft.com/kb/301248 but if you're using VS2008 try the Linq.DataContext - much simpler to use.
HTH,
Viv
Previous
Reply
Map
View

Click here to load this message in the networking platform