title: SQL data in DataGridView
body: <p>Hey guys, I have an application that I want to display some data from a sql db in a DataGridView... I have the data displayed in the DataGridView now but here are my questions... How can I use custom header titles because I don't want the SQL column titles to be used for the DataGridView column titles. Also, I want it so that when a user double-clicks on a row, it will open the filePath value from that row... I would also like to be able to specify the width of the columns.  Here is how the tables are layed out.</p>
  
  <p>SQL Table:
  Row_ID (I don't want displayed in grid), PartNumber, CMMNumber, CreatedOn, FilePath, RacfId, currTime</p>
  
  <p>Data grid view desired format:
  Part Number, CMM Number, Created On, Path, User ID, Viewed On</p>
  
  <p>Current code -- This gets the data (all, including Row_ID) and uses the sql column names as the names for the data grid view columns, it also just uses default column widths.</p>
  
  <pre><code>private void NewAlert_Load(object sender, EventArgs e)
          {
              string connString = "Server=FRXSQLDEV;Database=MyDB;User Id=ID;Password=Password;";
  
              string query = "SELECT * FROM CMMReports WHERE RacfId IS NULL;";
  
              SqlDataAdapter dAdapter = new SqlDataAdapter(query, connString);
  
              SqlCommandBuilder cBuilder = new SqlCommandBuilder(dAdapter);
  
              DataTable dTable = new DataTable();
  
              dAdapter.Fill(dTable);
  
  
  
              //BindingSource to sync DataTable and DataGridView
              BindingSource bSource = new BindingSource();
  
              //set the BindingSource DataSource
              bSource.DataSource = dTable;
  
              //set the DataGridView DataSource
              dgView.DataSource = bSource;
  
              dAdapter.Update(dTable);
  
  
  
          }
  </code></pre>