Saving data back to dataset from textboxes - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Saving data back to dataset from textboxes

ZOR2ZOR2 Posts: 1Member
Hi, I have texboxes with databindings. How do I save the data from a textbox when the textbox data is amended. Thanks


'MessageBox.Show("ID1 = " & dr("ID1").ToString & ", Barcode = " & dr("Barcode"))

Dim dr As DataRow = TXMastersDataset1.Tables("TXMasters").Rows(ListBox2.SelectedIndex)

Dim sql2 As MySqlCommand = New MySqlCommand("SELECT * FROM TXMasters WHERE TXMasters.ID1 = " & dr("ID1") & ";", con)

TXMastersDataset2 = New DataSet()
TXMastersDataAdaptor2 = New MySqlDataAdapter()
TXMastersDataAdaptor2.SelectCommand = sql2
TXMastersDataAdaptor2.Fill(TXMastersDataset2, "TXMasters")

TextBox3.DataBindings.Add(New Binding("Text", TXMastersDataset2, "TXMasters.Barcode"))
TextBox4.DataBindings.Add(New Binding("Text", TXMastersDataset2, "TXMasters.SportorSports"))
Sign In or Register to comment.