Gridview技巧1

using System.Data.SqlClient;

public partial class Default6 : System.Web.UI.Page{    protected void Page_Load(object sender, EventArgs e)    {        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["pubsConnectionString"].ConnectionString);        SqlDataAdapter adp = new SqlDataAdapter();        adp.SelectCommand = new SqlCommand("select au_fname,zip,state,city from authors",conn);

        DataSet ds = new DataSet();

        adp.Fill(ds,"t1");

        adp.SelectCommand = new SqlCommand("select state,city from authors",conn);        adp.Fill(ds,"t2");

        GridView1.DataSource=ds.Tables["t1"];        GridView1.DataBind();

        GridView2.DataSource= ds.Tables["t2"];        GridView2.DataBind();    }}