title: C# Error: "Fill: SelectCommand.Connection property has not been initialized."
body: <p>I'm using <a href="http://www.youtube.com/watch?v=Sm5mxkytfWk" rel="noreferrer">this video</a> to try and populate results from a <code>DataGridView</code>, and am receiving the above error.  The below code pertains to this error - I pass values into a stored procedure, then the final <code>SELECT</code> returns the values in the table in the <code>DataGridView</code>.</p>
  
  <pre><code>        SqlConnection con = new SqlConnection();
          con.ConnectionString = "integrated security=SSPI;data source=SERV;" + "persist security info=False;initial catalog=DB";
  
          con.Open();
          SqlCommand select = new SqlCommand("SELECT * FROM Table");
          SqlCommand enter = new SqlCommand("sp_Proc", con);
  
          // Stored Procedure
          enter.CommandType = CommandType.StoredProcedure;
          enter.Parameters.Add(new SqlParameter("@vvalue", SqlDbType.VarChar)).Value = Convert.ToString(txt1.Text);
          enter.Parameters.Add(new SqlParameter("@dvalue", SqlDbType.Decimal)).Value = Convert.ToDecimal(txt2.Text);
          enter.ExecuteNonQuery();
  
          // DataGrid returns the SELECT
  
          SqlDataAdapter sadapt = new SqlDataAdapter(select);
          sadapt.SelectCommand = select;
          DataTable dtab = new DataTable();
          sadapt.Fill(dtab); // generates the error
          BindingSource b = new BindingSource();
          b.DataSource = dtab;
          dGrid.DataSource = b;
          sadapt.Update(dtab);
  
          con.Close();
  </code></pre>