Update Query....

Nerine

Member
Joined
Nov 24, 2005
Messages
13
Location
Nede..Expel...???
Programming Experience
1-3
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

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 :confused: anyone know ??

P/S : Please delete this post pls..i post on wrong place
 
Last edited:
Back
Top