string connstr = @"Data Source=./sqlexpress;Initial Catalog=MySchool;Integrated Security=True"; //定义连接字符串
protected void Page_Load(object sender, EventArgs e)
{
GridView1.DataSource = getDs();
GridView1.DataBind();
}
//获取数据,返回dataset
private DataSet getDs()
{
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from Admin", conn);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
return ds;
}