最近在开发一个银行的项目时,要求用文本框绑定数据并实现一般的操作,包括分页,添加,删除,更新记录的功能,如图所示:
现贴上源码,供CSDN网友参考与更正.
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (!IsPostBack)
{
DataSet ds = new DataSet();
String sConn = "server=localhost;UID=sa;PWD=sa;Initial Catalog=temp;";
String sText = "SELECT * FROM WJPZ";
SqlDataAdapter cmd = new SqlDataAdapter(sText, sConn);
String sText = "SELECT * FROM WJPZ";
SqlDataAdapter cmd = new SqlDataAdapter(sText, sConn);
cmd.Fill(ds, "EmpTable");
Session["MyData"] = ds;
Session["CurrentRecord"] = 0;
Session["RecordCount"] = ds.Tables["EmpTable"].Rows.Count-1;
Refresh();
DisEnable();
}
}
Session["MyData"] = ds;
Session["CurrentRecord"] = 0;
Session["RecordCount"] = ds.Tables["EmpTable"].Rows.Count-1;
Refresh();
DisEnable();
}
}
//绑定文本框的方法
public String GetBoundData(String fieldName)
{
DataSet ds = (DataSet) Session["MyData"];
DataTable dt = ds.Tables["EmpTable"];
int nRowPos = (int) Session["CurrentRecord"];
public String GetBoundData(String fieldName)
{
DataSet ds = (DataSet) Session["MyData"];
DataTable dt = ds.Tables["EmpTable"];
int nRowPos = (int) Session["CurrentRecord"];
String buf = dt.Rows[nRowPos][fieldName].ToString();
return buf;
}
return buf;
}
//利用了Session来向前移动
public void Forward(Object sender, EventArgs e)
{
int nRowPos = (int) Session["CurrentRecord"];
int nCount = (int) Session["RecordCount"];
if (nRowPos < nCount)
{
nRowPos++;
Session["CurrentRecord"] = nRowPos;
Refresh();
}
{
int nRowPos = (int) Session["CurrentRecord"];
int nCount = (int) Session["RecordCount"];
if (nRowPos < nCount)
{
nRowPos++;
Session["CurrentRecord"] = nRowPos;
Refresh();
}
return;
}
}
//向后移动
public v