\r\n\r\n
Database / XML / Reporting Topics include: ADO.NET, SQL, XML structures and schemas, Crystal Reports, and other reporting tools

Go Back  Xtreme .NET Talk > .NET > Database / XML / Reporting > Quick Question


\r\n \r\n \r\n \r\n
 
 
Thread Tools Display Modes
\r\n \r\n
\r\n
\r\n \r\n I have developed an Application in VB 6.0 that updates records in an Access Database from an excel spreadsheet. I am developing a similiar application in VB.NET. In 6.0 the code was like the following:
\r\n
\r\nrst.fields("somefield") = excel.cells(1,1)
\r\n
\r\nMy question is since VB.NET no longer uses a recordset instead it uses a data set what would be the correct syntax to get to update the records.
\r\n
\r\nAny help with this question would be greatly appreciated.\r\n
\r\n
\r\n \r\n
\r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n
\r\n \r\n \r\n \r\n \r\n Reply With Quote\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n \r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n\r\n'; pd[195546] = '\r\n\r\n \r\n\r\n
\r\n
\r\n
\r\n\r\n
\r\n \r\n\r\n\r\n\r\n\r\n\r\n \r\n\r\n\r\n\r\n \r\n
\r\n
\r\n  \r\n #2  \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n
\r\n \r\n Old\r\n \r\n 09-05-2002, 08:19 PM\r\n \r\n \r\n \r\n
\r\n
\r\n \r\n \r\n \r\n \r\n \r\n
Robby\'s Avatar\r\n\r\n
\r\n \r\n Robby\r\n Robby is offline\r\n\r\n\r\n
Prev Previous Post   Next Post Next
  #1  
Old 09-05-2002, 05:14 PM
lothos12345 lothos12345 is offline
Junior Contributor
 
Join Date: May 2002
Location: Texas
Posts: 294
lothos12345 is on a distinguished road
Smile Quick Question

I have developed an Application in VB 6.0 that updates records in an Access Database from an excel spreadsheet. I am developing a similiar application in VB.NET. In 6.0 the code was like the following:

rst.fields("somefield") = excel.cells(1,1)

My question is since VB.NET no longer uses a recordset instead it uses a data set what would be the correct syntax to get to update the records.

Any help with this question would be greatly appreciated.
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Quick question, quick answer, about a string function... robplatt General 8 10-08-2006 08:11 PM
Quick parsing question Xee Windows Forms 1 07-29-2005 09:40 AM
Quick Question? mike55 ASP.NET 1 12-11-2004 05:00 AM
MSDE quick question bri189a Database / XML / Reporting 2 03-22-2004 06:45 AM
quick pictureBox question msellery Graphics and Multimedia 8 04-01-2003 04:07 AM

Advertisement:

Powered by liquidweb