Here is what I have as my SQL statement within my UpdateQuery function:
UPDATE members
SET id = @id, first_name = @first_name, last_name = @last_name, phone_number = @phone_number, date_joined = @date_joined
WHERE (first_name LIKE @first_name and last_name LIKE @last_name)
Here is how I am calling the function:
Me.DsAllMembersBindingSource.EndEdit()
Me.DsAllMembersTableAdapter.UpdateQuery(Me.IdTextBox.Text.Trim(),
Me.First_nameTextBox.Text.Trim(), Me.Last_nameTextBox.Text.Trim(),
Me.Phone_numberTextBox.Text.Trim(), Me.Date_joinedTextBox.Text.Trim())
Me.Close()
Can someone please help