Posted on: 8/23/2014 12:30:41 PM | Views : 549

I've set up a datatable in the Data Access Layer using the Northwind database, I know how to populate a gridview with Table Adapter queries, it's simple like this:

Dim customersAdapter As New CustomersTableAdapter GridView1.DataSource = customersAdapter.GetCustomerByCustomerID(5) GridView1.DataBind()
But how do you populate single field controls like a label or a textbox so it would show one field value per control?
I imagined it being something like this:
TxtCustomerID.Text = customersAdapter.GetCustomerByCustomerID.CustomerIDColumn.Value TxtCustomerName.Text = customersAdapter.GetCustomerByCustomerID.CustomerNameColumn.Value

Go to the complete details ...