private void Form1_Load(object sender, EventArgs e)
{
string conStr = "SERVER=(local);DATABASE=Northwind;INTEGRATED SECURITY=True;";
SqlConnection con = new SqlConnection(conStr);
try
{
con.Open();
string cmdText = @"Select * From Customers";
SqlCommand cmd = new SqlCommand(cmdText, con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
this.dataGridView1.DataSource = ds.Tables [0];
} catch (Exception)
{ throw;
}
finally
{
con.Close();
}
}

protected void Page_Load(object sender, EventArgs e)
{
string conStr = "SERVER=(local);DATABASE=Northwind;INTEGRATED SECURITY=True;";
SqlConnection con = new SqlConnection(conStr);
try
{
con.Open();
string cmdText = @"Select * From Customers";
SqlCommand cmd = new SqlCommand( cmdText,con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
string cmdText1 = @"Select * From Employees";
SqlCommand cmd1 = new SqlCommand(cmdText1, con);
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
da1.Fill(ds);
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
}
catch (Exception)
{ throw;
}
finally
{
con.Close();
}
}