Thread: DataTable binding....

Here is the method I created. I am trying to read a table from a database and put that information within a DataTable which i have no issues doing. Then I want to bind that DataTable to a DataGridView object I have on my form. I have no problem doing that but its the formatting I am having issues with. Ive tried using the Wizard for binding a database and pulling the columns but it screws things up with I try to remove or update the database using the bounded DataGridView.

What I want is to get all the columns in the DataTable, bind that to the DataGridView (So I can access the ID -first- column easy) but only show 3 out of the 5 columns in the table on my datagridview object. I have already created the datagridview, set the three columns widths, and changed the HeaderText so it looks nice instead of the column titles the database gives.

Basically what I get is the thee very nice looking colums which the data like I want, then the whole DataTable gets added to the right of those three columns. So How do I Bind the DataTable and hide those other columns from appearing????

If i comes down to changn my query string to just get those three columns and the ID column(first column) then I will but I would still want to hide the ID column so the user can not see it.

Code:

      private void UpdatePlayerRounds()
      {
         DataTable playerRoundsTable = new DataTable();
         DataRow roundRow;

         // Set the query command string.
         cmdString = "Select * From roundOfGolfTable " +
                     "WHERE [playerName] = '" + 
                     golferNameComboBox.Text + "'";

         dbCommand.CommandText = cmdString;
         dbCommand.Connection = dbConn;

         // Execute the Command string.
         dbReader = dbCommand.ExecuteReader();

         // Read each column name and add to the DataTable.
         for (int tmp = 0; tmp < dbReader.FieldCount; tmp++)
         {
            playerRoundsTable.Columns.Add(dbReader.GetName(tmp));
         }

         // Read each row from the query and add each row to the DataTable.
         while (dbReader.Read())
         {
            roundRow = playerRoundsTable.NewRow();

            for (int tmp2 = 0; tmp2 < dbReader.FieldCount; tmp2++)
            {
               roundRow[dbReader.GetName(tmp2)] = dbReader.GetValue(tmp2);
            }
            playerRoundsTable.Rows.Add(roundRow);
         }

         dbReader.Close();

         // Associate the datagridview "golfRoundDG" with the DataTable.        
         golfRoundDG.DataSource = playerRoundsTable;
         scoreCol.DataPropertyName = "roundScore";
         courseCol.DataPropertyName = "courseName";
         dateCol.DataPropertyName = "roundDate";
      }

Perfect! Thank you very much!