for binding the grid you can use Datasource and Databind() method.
you can use following things to bind your query in Grid.
string s = "select fileds from table name";
SqlDataAdapter ad = new SqlDataAdapter(s,connection object);
DataSet ds = new DataSet();
ad.Fill(ds);
if (ds.Tables[0].Rows.Count != 0)
{
gridview1.datasource=ds;
gridview1.databind();
}
hope this will help you, if not please Post it.