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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
¤ 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)
 
Back
Top