protected void get_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("server=lzq;database=pubs;uid=sa;pwd="); SqlDataAdapter da = new SqlDataAdapter("select * from lzq", conn); DataSet ds = new DataSet(); da.Fill(ds, "t1"); datagrid1.DataSource = ds.Tables["t1"].DefaultView; datagrid1.DataBind(); }