Using DataTable (or DataSet if multiple tables are needed to select) and bind the datatable to the Grid
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connectionstring"].ToString());
SqlCommand cmd = new SqlCommand("select * from product_order", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
cmd.Connection = con;
con.Open();
sda.Fill(dt, "product_order");
GridView1.DataSource = dt;
GridView1.DataBind();
con.Close();
Hope this will help you :)