Main Page | Report this Page
.NET DotNet Forum Index  »  VB.NET Forum (Visual Basic .NET)  »  Vb.net 2008: DataAdapter/Dataset updating database...
Page 1 of 1    

Vb.net 2008: DataAdapter/Dataset updating database...

Author Message
Rob W...
Posted: Wed Nov 04, 2009 6:04 pm
Guest
Greetings,

I have a dataAdapter which populates a dataset -> single datatable from
MULTIPLE SQLserver database tables to provide the user with a business view
of data to populate a datagridview.

As the datasource of the datagridview is the datatable which is really
derived from multiple database tables, will I be able to use a dataAdapter
and dataset to update the database (I only want to INSERT/UPDATE data in ONE
SQLserver database table, though the dataset contains data from more tables)
?

Previously I've used the SQLCommands directly but wondering if
dataAdapter/dataset work only if its a 1:1 relationship.
Hope that makes sense.

Thanks
Rob
 
 
Page 1 of 1    
All times are GMT - 5 Hours
The time now is Tue Dec 01, 2009 4:39 pm