I have the following DataGridView in my form:
| Assignment | Name | ID Number | Location |
I have a database query that will select the "Name" and "ID Number" from a table.
"Assignment" and "Location" will be entered manually.
Later I will have a button to export the data from the DataGridView to another database table.
My question is, how do I tell vb to fill only the "Name" and "ID Number" columns from my query?
I'm using VB 08.
dgViewText = "SELECT Name, ID_Number FROM tbl_emp"
data = New DataTable
adapter = New MySqlDataAdapter(dgViewText, conn)
CommandBuild = New MySqlCommandBuilder(adapter)
dgView.DataSource = data