Exception thrown: 'System.InvalidOperationException' in System.Data.dll
Try Dim rows_affected As Integer Using Conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\UserInfo.mdb") Using cmd As New OleDbCommand("UPDATE table1 SET TotalCorrect = @TotCorr , TotalAnswered = @TotAnswered , TotalAcc = @TotAcc WHERE username = @userName", Conn) cmd.Parameters.Add("@TotCorr", SqlDbType.Int).Value = USerInfoDataArray(0, 0) cmd.Parameters.Add("@TotAnswered", SqlDbType.Int).Value = USerInfoDataArray(0, 1) cmd.Parameters.Add("@TotAcc", SqlDbType.Int).Value = USerInfoDataArray(0, 2) cmd.Parameters.Add("@username", SqlDbType.Text).Value = LoginForm.txtUsername.Text Conn.Open() rows_affected = cmd.ExecuteNonQuery() MessageBox.Show(rows_affected) End Using End Using Catch ex As OleDbException MessageBox.Show(ex.ToString()) End Try
USerInfoDataArray
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)