title: CommandText Property has not been initialized
body: <p>The following code attempts to delete a selected row from a datagridview and update the database.</p>
  
  <p>But it's not updating the database...it's just issuing the error, "CommandText Property has not been initialized." ...any ideas? I assume it's because it's not being bound in the beginning, but at this point I'm clueless and my head is sore.</p>
  
  <pre><code>private void deleteRow()
  {
      DialogResult dr = MessageBox.Show("Are you sure you want to delete this row?", "Confirmation", 
      MessageBoxButtons.YesNo, MessageBoxIcon.Question);
  
      if (dr == DialogResult.Yes)
      {
          while (dataGridView1.SelectedRows.Count &gt; 0)
          dataGridView1.Rows.Remove(dataGridView1.SelectedRows[0]);                
  
          try
          {
              this.Validate();
              this.tradesBindingSource.EndEdit();
              this.tradesTableAdapter.Update(this.tradesDataSet.Trades);
          }
          catch (Exception ex)
          {
              MessageBox.Show("An error occurred during the update process: " + ex);
              // Add code to handle error here.
          }
  
          this.tradesTableAdapter.Fill(this.tradesDataSet.Trades); // refresh table
      }
  }
  </code></pre>