Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • 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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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