Updating records

minn

Active member
Joined
Apr 10, 2006
Messages
37
Programming Experience
Beginner
Hello,

I have a simple webform that allows users to navigate through the items in a database. The item is displayed via a single textbox and the user clicks on next, previous, first and last buttons to navigate.

I also have an update record button that should allow the user to navigate to a record, change the record displayed in the textbox, click on the update button and have the changes saved to the database.

I have tried this but what is happening is that when i change the text of the record, it changes ok and i see the confirmaion message I have set.

However, when i navigate away and then back again i see the changed record which is fine, and also the original record that should have been overwritten by changes is also there.

When i look at my backend access database i also notice that the updated record has taken the place of another record in the table.

So to sum up, i am changing the record, clicking update, and then navigating up and down again only to notice that my updated record appears as a new record that has overwritten anothe unrelated record but has left the original there.

Here is my code for the update button:

VB.NET:
[SIZE=2][COLOR=#0000ff]Private[/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]Sub[/COLOR][/SIZE][SIZE=2] btnUpdate_Click([/SIZE][SIZE=2][COLOR=#0000ff]ByVal[/COLOR][/SIZE][SIZE=2] sender [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] System.Object, [/SIZE][SIZE=2][COLOR=#0000ff]ByVal[/COLOR][/SIZE][SIZE=2] e [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2] System.EventArgs) [/SIZE][SIZE=2][COLOR=#0000ff]Handles[/COLOR][/SIZE][SIZE=2] btnUpdate.Click[/SIZE]
[SIZE=2]
[/SIZE][SIZE=2][COLOR=#0000ff]Dim[/COLOR][/SIZE][SIZE=2] cb [/SIZE][SIZE=2][COLOR=#0000ff]As[/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]New[/COLOR][/SIZE][SIZE=2] OleDb.OleDbCommandBuilder(davendors)[/SIZE]
[SIZE=2]
dsvendors.Tables("Vendors").Rows(inc).Item(1) = txtVendor.Text
davendors.Update(dsvendors, "Vendors")
 
lblmessage.Text = "The Record has been updated to " & txtVendor.Text
 
[/SIZE][SIZE=2][COLOR=#0000ff]End[/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]Sub[/COLOR][/SIZE]

Anyone have any ideas or alternatives ways i could use??
 
Back
Top