Pseudo code for updating Access db using VB and ASP.NET

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

glenn - 04 Apr 2006 20:39 GMT

Hi folks,

I have been hunting for a code snippet to update an Access db using VB and
ASP.NET. So far, nothing that helps me. I am using OleDb libraries.

Can anyone provide me with the general steps or calls involved. Here is
where I am at so far. Any guidance would be great...

Sub UpdateRows()

' 1) OPEN A CONNECTION
' 2) GET EXISTING COLUMN DATA
' 3) PROVIDE AN UPDATE SQL STATEMENT
'( NOT SURE WHAT THE SYNTAX SHOULD BE ON THIS)
' 4) USE OleDbParameter TO PASS IN THE UPDATES
'( NOT SURE WHAT THE SYNTAX SHOULD BE ON THIS)
' 5) CLOSE THE CONNECTION

End Sub

Reply to this Message

Paul Clement - 06 Apr 2006 15:04 GMT

¤ Hi folks,
¤
¤ I have been hunting for a code snippet to update an Access db using VB and
¤ ASP.NET. So far, nothing that helps me. I am using OleDb libraries.
¤
¤ Can anyone provide me with the general steps or calls involved. Here is
¤ where I am at so far. Any guidance would be great...
¤
¤ Sub UpdateRows()
¤
¤ ' 1) OPEN A CONNECTION
¤ ' 2) GET EXISTING COLUMN DATA
¤ ' 3) PROVIDE AN UPDATE SQL STATEMENT
¤ '( NOT SURE WHAT THE SYNTAX SHOULD BE ON THIS)
¤ ' 4) USE OleDbParameter TO PASS IN THE UPDATES
¤ '( NOT SURE WHAT THE SYNTAX SHOULD BE ON THIS)
¤ ' 5) CLOSE THE CONNECTION
¤
¤ End Sub

The following should help you get started:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/
office12062001.asp
http://support.microsoft.com/kb/821765/EN-US/

Paul
~~~~
Microsoft MVP (Visual Basic)

Reply to this Message

Pseudo code for updating Access db using VB and ASP.NET

Free Magazines