SqlConnection MyConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
string sqlstring = "SELECT * FROM jq_class1";
SqlDataAdapter MyCommand = new SqlDataAdapter(sqlstring, MyConnection); MyCommand.Fill(ds, "jq_class1");
dv = ds.Tables["jq_class1"].DefaultView;
if (!IsPostBack)
Session["RecordPosition"] = 0;
Page.DataBind();
尤其是这一段:
MyCommand.Fill(ds, "jq_class1");
dv = ds.Tables["jq_class1"].DefaultView;
if (!IsPostBack)
Session["RecordPosition"] = 0;
string sqlstring = "SELECT * FROM jq_class1";
SqlDataAdapter MyCommand = new SqlDataAdapter(sqlstring, MyConnection); MyCommand.Fill(ds, "jq_class1");
dv = ds.Tables["jq_class1"].DefaultView;
if (!IsPostBack)
Session["RecordPosition"] = 0;
Page.DataBind();
尤其是这一段:
MyCommand.Fill(ds, "jq_class1");
dv = ds.Tables["jq_class1"].DefaultView;
if (!IsPostBack)
Session["RecordPosition"] = 0;
dv = ds.Tables["jq_class1"].DefaultView;
if (!IsPostBack) 页面如果是第一次加载
Session["RecordPosition"] = 0; 初始页为0,应该是DataGrid的分页用的,记录当前页
SqlConnection MyConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
string sqlstring = "SELECT * FROM jq_class1";
-------绑定数据----
SqlDataAdapter MyCommand = new SqlDataAdapter(sqlstring, MyConnection); MyCommand.Fill(ds, "jq_class1");
dv = ds.Tables["jq_class1"].DefaultView;
----初始页面绑定----
if (!IsPostBack)
Session["RecordPosition"] = 0;
Page.DataBind();
尤其是这一段:
MyCommand.Fill(ds, "jq_class1");
dv = ds.Tables["jq_class1"].DefaultView;
if (!IsPostBack)
Session["RecordPosition"] = 0;
dv = ds.Tables["jq_class1"].DefaultView;中的jq_class1又是什么意思?
dv = ds.Tables["jq_class1"].DefaultView;//将dataset ds里名字为jq_class1的表的数据以默认视图的格式赋值给dataview dv
if (!IsPostBack)//如果不是第一次访问该页,是回传就执行下面
Session["RecordPosition"] = 0;//给session变量赋值为0