ogimy

[CODE] Private Sub cmdUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdUpdate.Click Dim conn As New OleDbConnection("<connection string>") Dim hasErrors As Boolean = False Try If txtUserName.Text <> "" Then Dim SQL As String = "UPDATE addresses SET PinCode= '" & txtPinCode.Text & "' , " & _ "Occupation= …

i have make this program to update database.but it have something error. pop up show this message "An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: ExecuteNonQuery requires an open and available Connection. The connection's current state is Closed. " [code] Private Sub cmdUpdate_Click(ByVal sender As System.Object, ByVal …

[CODE]My situation is to update the balance in database.In database i have 3 column which is user name, pin code, and the balance.i have three customer, each customer have user name, pin code, and balance.The question is how to update balance of customer first, how to update customer second, and …

i have make the simple code log in program with connect database.The below code have something problem.Can someone pro solve the problem.:( [code] Private Sub btnSignIn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSignIn.Click Dim conn As New OleDb.OleDbConnection Dim ds As New DataSet Dim da As New OleDb.OleDbDataAdapter …