Nerine
Member
i want to ask about update...
i want to update but my database data not change at all.. !!
my problem is i have win form that have function to search the database and the edit the data.
on the save button i use
it just won't update the database anyone know ??
P/S : Please delete this post pls..i post on wrong place
i want to update but my database data not change at all.. !!
my problem is i have win form that have function to search the database and the edit the data.
on the save button i use
VB.NET:
Private Sub BtnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnSave.Click
OleDbDataAdapter1.UpdateCommand.Parameters("NameF").Value = TxtNameF.Text
OleDbDataAdapter1.UpdateCommand.Parameters("NameL").Value = TxtNameL.Text
OleDbDataAdapter1.UpdateCommand.Parameters("Gender").Value = CBGender.Text
OleDbDataAdapter1.UpdateCommand.Parameters.Add("Address", TxtAddress.Text)
OleDbDataAdapter1.UpdateCommand.Parameters("ContactNumber").Value = TxtContact.Text
OleDbDataAdapter1.UpdateCommand.Parameters("Birthdate").Value = DTPBirth.Text
OleDbDataAdapter1.UpdateCommand.Parameters("Email").Value = TxtEmail.Text
OleDbDataAdapter1.UpdateCommand.Parameters("MemberType").Value = CBMemType.Text
OleDbDataAdapter1.UpdateCommand.Parameters("NRIC").Value = TxtICNO.Text
OleDbDataAdapter1.UpdateCommand.Parameters("Race").Value = CBRace.Text
OleDbDataAdapter1.Update(DataSet11)
DataSet11.AcceptChanges()
end sub
it just won't update the database anyone know ??
P/S : Please delete this post pls..i post on wrong place
Last edited: