public void getdata()
{
SqlConnection conn = new SqlConnection("server=PC-200902201241;database=test;integrated security=true");
SqlCommand comm = new SqlCommand("select * from user1",conn);
SqlDataAdapter da = new SqlDataAdapter(comm);
DataSet ds = new DataSet();
da.Fill(ds,"user1");
this.GridView1.DataSource = ds.Tables[0];
this.GridView1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e)
{
getdata();
}
ps:
数据库test里面有
表user1
{
SqlConnection conn = new SqlConnection("server=PC-200902201241;database=test;integrated security=true");
SqlCommand comm = new SqlCommand("select * from user1",conn);
SqlDataAdapter da = new SqlDataAdapter(comm);
DataSet ds = new DataSet();
da.Fill(ds,"user1");
this.GridView1.DataSource = ds.Tables[0];
this.GridView1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e)
{
getdata();
}
ps:
数据库test里面有
表user1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货