Add Headings to DataGridView
-
Hello I am pulling a table from access but the column headings in the database are not what I want to use on the user form. How to I change the Headings after the grid is populated??? Here is what I have so far... The column it pulls from the DB is myID and myCustomer I would like to change to ID and Customer without editing the DB.. Thanks
Private Sub LoadCustomers() Dim objConnection As New OleDbConnection(strConn) objConnection.Open() If objConnection.State = ConnectionState.Closed Then Exit Sub Dim OleDbAdapter As New OleDbDataAdapter("SELECT * FROM CustomersTB", objConnection) Dim myDataSet As New DataSet Try OleDbAdapter.Fill(myDataSet, "CustomersTB") Dim dv As DataView = myDataSet.Tables("CustomersTB").DefaultView DGCustomers.DataSource = dv Catch ex As SqlClient.SqlException MessageBox.Show("There was a Connection Error.") Catch InEXOpp As InvalidOperationException MessageBox.Show("An Invalid Operation occured.") End Try End Sub
When people make you see red, be thankful your not colour blind.