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 ...