Updating data in database <p>I have a problem trying to update this data but giving error messages all the time...</p> <pre><code>private void btnEnterReturn_Click(object sender, EventArgs e) { OleDbConnection connect = new OleDbConnection(); connect.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=MovieLibrary.accdb"; connect.Open(); addnew = "UPDATE tblLoan set MovieID='" + this.txtMovieID + "', DateIssued='" + this.txtDateIssued.Text + "', DateReturned='" + this.txtDateReturned.Text + "' WHERE MemberID='" + this.txtMemberID.Text + "';"; com = new OleDbCommand(addnew, connect); com.ExecuteNonQuery(); connect.Close(); MessageBox.Show("Successfully returned.."); //clear screen txtMemberID.Text = " "; txtMovieID.Text = " "; txtDateIssued.Text = " "; txtDateReturned.Text = " "; } </code></pre>