I am working on a simple web application that will allow users to add, update or delete information about customers. I would normally use VB6 and ado to do this becuase it would allow me to move around a recordset using buttons for previous, next, add new, delete and save to handle all of the basic editing functions.
Because this new project that i am working on needs to be web based i am using visual studio.net. I am looking for any input or examples of code that i can use to move through a dataset in the same manner that i am familiar with in VB6/ADO.
I am using the following to connected to my database (Access Database) and to fill the dataset.
Dim strSQL As String
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Application("Data_Path") & ";Jet OLEDB:Database Password=exhibit_info@05"
strSQL = "SELECT * FROM tblExhibitor_Info ORDER BY tblExhibitor_Info.Last_Name, tblExhibitor_Info.First_Name;"
Dim cn As New OleDb.OleDbConnection(strConn)
Dim da As New OleDb.OleDbDataAdapter(strSQL, strConn)
Dim ds As New DataSet
If Not IsPostBack Then
I would greatly appreciate some expert help!