SqlConnection sqlConnection = new SqlConnection ( "connectionString" );
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter ( "Select * From TableName", sqlConnection );
DataSet dataSet = new DataSet ();
GridView1.DataSource = dataSet;
GridView1.DataBind ();