title: Adding a SQL alias statement to an SQL SELECT * FROM command in VB.net
body: <p>I am currently pulling an SQL table into a data grid view in VB.net. People will be reading this table and the column names have no spaces and are short handed for coding purposes. I was wondering if/how I can include a list of SQL Alias commands to change these column names into something more legible and ergonomic instead of what I used in the code.</p>
  
  <pre><code>Using conn1 As New SqlConnection(connstring)
      Using comm1 As SqlCommand = New SqlCommand("Select * FROM TPM.dbo.tblFCTPM; Select Name as Associate from TPM.dbo.tblFCTPM", conn1)
          Dim da As New SqlDataAdapter
          da.SelectCommand = comm1
          da.Fill(dt)
          'select customerName as customer, contactname as contact person
          'from cusomters;
      End Using
  
      conn1.Close()
  End Using
  
  DGVPM.DataSource = dt
  </code></pre>