ADO Recordset read/write?

Using vb.net 2008, and SQL Server 2005.
How can I open a recordset that is both readable and writeable?
LVL 1
Jess31Asked:
Who is Participating?
 
timexistConnect With a Mentor Commented:
Data Access SamplesThe Data Access samples show how to use the classes in the System.Data and related namespaces. In addition, how to use the new features of SQL Server 2005. Samples include:

Asynchronous Queries
Attaching a database with your application
Creating and using User Defined Types with SQL Server 2005
DataReader vs. DataSet comparision
DataSet and DataTable Enhancements
Performing Batch Updates and Data Paging
Performing Bulk Updates
 Reading and Writing Images from a Database
Using Factory Classes
Using Managed Stored Procedures and User Defined Functions with SQL Server 2005
Using Multiple Active Result Sets with SQL Server 2005
Using Notifications with SQL Server 2005
Using the XML data type with SQL Server 2005
XPath and XSLT Transformations Enhancements
 
Download the Visual Basic version of the Data Access samples.
http://download.microsoft.com/download/f/7/8/f780fb58-77dc-4d5d-adcd-55818c9f23da/VB101SamplesData.msi
0
 
planoczCommented:
In VB.net  you use the adapter to bring in your dataset then adjust the dataset thru the adapter and then back to the sqlserver.
0
 
timexistCommented:

101 Samples for Visual Basic 2005
http://msdn.microsoft.com/en-us/vbasic/ms789075.aspx
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Jess31Author Commented:
yes, but is there no way that I can use a recordset that I can read and write to directly?
I have to loop through a recordset, updating another table, basically Inserting each record from RS1 to RS2, and then writing the ID created for the new RS2.record to RS1.
0
 
timexistCommented:
0
 
Jess31Author Commented:
timexist:

which one of these samples relate to my question?
0
All Courses

From novice to tech pro — start learning today.