Asp.NET开发笔记--文本框的数据绑定与操作

  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);

    cmd.Fill(ds, "EmpTable");
 
    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"]; 

   String buf = dt.Rows[nRowPos][fieldName].ToString(); 
   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();
   }

   return;
  }

  //向后移动

  public void Back(Object sender, EventArgs e)
  {
   
   int nRowPos = (int) Session["CurrentRecord"]; 
   if (nRowPos >0)
   {
    nRowPos--;
    Session["CurrentRecord"] = nR