Dim MyConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source= C:\Davenben.mdb;" & "User Id=admin;Password=;"
Dim Query As String = "SELECT * FROM login"
Dim MyConnection As New OleDbConnection(MyConn)
Dim StrInsertCommand As String = "INSERT INTO login(Username,Password)" & "VALUES(@Username, @Password)"
Dim daLog As New OleDbDataAdapter
Dim dsLog As New DataSet
Dim MyCommand As OleDbCommand = New OleDbCommand(Query, MyConnection)
Dim InsertCommand As OleDbCommand = New OleDbCommand(StrInsertCommand, MyConnection)
daLog.SelectCommand = MyCommand
daLog.InsertCommand = MyCommand
MyConnection.Open()
daLog.Fill(DataSet11)
InsertCommand.Parameters.Add(New OleDbParameter("@Username", OleDbType.VarChar, 10)).Value = "Lacey"
InsertCommand.Parameters.Add(New OleDbParameter("@Password", OleDbType.VarChar, 10)).Value = "geric"
InsertCommand.ExecuteNonQuery()
MyConnection.Close()
This is my code to insert in my tables however when I run it, there was an error:
"An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll
can someone help me, I am so clueless... I would really appreciate it..
Dim Query As String = "SELECT * FROM login"
Dim MyConnection As New OleDbConnection(MyConn)
Dim StrInsertCommand As String = "INSERT INTO login(Username,Password)" & "VALUES(@Username, @Password)"
Dim daLog As New OleDbDataAdapter
Dim dsLog As New DataSet
Dim MyCommand As OleDbCommand = New OleDbCommand(Query, MyConnection)
Dim InsertCommand As OleDbCommand = New OleDbCommand(StrInsertCommand, MyConnection)
daLog.SelectCommand = MyCommand
daLog.InsertCommand = MyCommand
MyConnection.Open()
daLog.Fill(DataSet11)
InsertCommand.Parameters.Add(New OleDbParameter("@Username", OleDbType.VarChar, 10)).Value = "Lacey"
InsertCommand.Parameters.Add(New OleDbParameter("@Password", OleDbType.VarChar, 10)).Value = "geric"
InsertCommand.ExecuteNonQuery()
MyConnection.Close()
This is my code to insert in my tables however when I run it, there was an error:
"An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll
can someone help me, I am so clueless... I would really appreciate it..