Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 206
  • Last Modified:

ADO Recordset read/write?

Using vb.net 2008, and SQL Server 2005.
How can I open a recordset that is both readable and writeable?
0
Jess31
Asked:
Jess31
  • 3
  • 2
1 Solution
 
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
 
timexistCommented:
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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now