Hi Everyone,
as you can see below i have sent data from a Access database to text boxes. I have used DataBinding to do this the problem i have is that databinding is readonly and i want to write to it many times does anyone know of anythink else i can use instead
Dim connStr As String = "Provider = Microsoft.Jet.OLEDB.4.0;" & _
"Data Source = G2G.mdb"
Dim squlStr As String = "SELECT * From Staff WHERE ((Staff_No=" & StaffnoTxt.Text & "))"
Dim oleDbStaffAdapter As New OleDb.OleDbDataAdapter(squlStr, connStr)
Dim oDataTable As New DataTable
oleDbStaffAdapter.Fill(oDataTable)
FnameTxt.DataBindings.Add(New Binding("Text", oDataTable, "First_Name"))
LastnameTxt.DataBindings.Add(New Binding("Text", oDataTable, "Surname"))
NoTxt.DataBindings.Add(New Binding("Text", oDataTable, "Tel_No"))
PcodeTxt.DataBindings.Add(New Binding("Text", oDataTable, "Post_Code"))
DoornoTxt.DataBindings.Add(New Binding("Text", oDataTable, "House"))