while (myDataReader.Read()) { // print one row at a time Console.WriteLine("{0}", myDataReader[0]); }To bind data to a DataGridView we need a DataTable.
... ... string sqlCnStr = @"Data Source=.\mySQLserver;Initial Catalog=Northwind;Integrated Security=True"; using (SqlConnection northWindSqlCn = new SqlConnection(sqlCnStr)) { try { string nwSqlStr = "select productID, ProductName, UnitPrice from Products order by UnitPrice"; SqlCommand nwSqlCmd = new SqlCommand(nwSqlStr, northWindSqlCn); SqlDataAdapter nwDataAdptr = new SqlDataAdapter(nwSqlCmd); DataSet nwDataSet = new DataSet(); nwDataAdptr.Fill(nwDataSet, "myTable"); dataGridView1.DataSource = nwDataSet.Tables["myTable"]; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { if (northWindSqlCn != null) northWindSqlCn.Close(); } } ... ...To bing data to your DataGridView see the following page in MSDN: