title: How to Bind DataGridView with SqlDataReader
body: <p>Can anyone help me in this Code Please. I am trying to bind data with datagridview. Query is returning values in sql server. But it's not binding any value in DataGridView....</p>
  
  <pre><code>     private void CheckMembers()
       {
          try
          {
              string query = "Select id, id-no, status From Members Where Head=@Head";
  
              sqlCommand = new SqlCommand(query, sqlConnection);
              sqlConnection.Open();
              sqlCommand.Parameters.AddWithValue("@Head", "2288885858");
              sqlDataReader = sqlCommand.ExecuteReader();
  
              if (sqlDataReader.HasRows)
              {
                  fmGview.Visible = true;
                  DataTable dt = new DataTable();
                  dt.Load(sqlDataReader);
                  MessageBox.Show(dt.ToString());
                  fmGview.DataSource = dt;
              }
          }
          catch (Exception exp)
          {
              MessageBox.Show(exp.ToString(), "Exception in CheckMembers");
          }
          finally
          {
              CheckConnectionStatus();
          }
     }
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/dYgo5.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dYgo5.jpg" alt="enter image description here"></a></p>