asp.net简单页面控件赋值实现的方法

网址简介:未填写

更新时间:10个月前

访问次数:91

详细介绍

Asp.Net开发技术中,我们可以通过存储过程进行分页,但在编写存储过程中其实更困难,爱站技术频道小编搜集了asp.net简单页面控件赋值实现的方法,感兴趣的朋友一起来看看吧!

分享给大家供大家参考,具体如下:

  /// <summary>  /// 赋值 表名,控件名,要查询的唯一数据  /// </summary>  protected void SetEvaluate(string TableName, string UpName, string Id)  {      ContentPlaceHolder cph = (ContentPlaceHolder)Page.Master.FindControl("cph_context");      UpdatePanel up = (UpdatePanel)cph.FindControl(UpName);      DataTable dt = LOaPersonLogic.GetPersonTemp("select * from " + TableName + " where ID='" + Id + "'");      for (int i = 0; i < dt.Columns.Count; i++)      {        //集合表头名称 dt.Columns[i]        //集合值dt.Rows[0][i].ToString()        foreach (Control ctl in up.Controls[0].Controls)        {          if ((ctl is TextBox) && ctl.ID.Trim() == dt.Columns[i].ToString().Trim())          {            ((TextBox)ctl).Text = dt.Rows[0][i].ToString();          }          if ((ctl is DropDownList) && ctl.ID.Trim() == dt.Columns[i].ToString().Trim())          {            ((DropDownList)ctl).Items.FindByValue(dt.Rows[0][i].ToString().Trim()).Selected = true;          }        }      }  }  /// <summary>  /// 生成sql 修改sql  /// </summary>  /// <param name="TableName">表名称</param>  /// <param name="WyId">唯一id主键</param>  /// <param name="UpName"></param>  /// <param name="Id">修改id</param>  protected string CreateSql(string TableName, string WyId, string UpName, string Id)  {      string SQL = "update " + TableName + " set ";      ContentPlaceHolder cph = (ContentPlaceHolder)Page.Master.FindControl("cph_context");      UpdatePanel up = (UpdatePanel)cph.FindControl(UpName);      foreach (Control ctl in up.Controls[0].Controls)      {        if (ctl is TextBox)        {          SQL = SQL + ctl.ID + "='" + ((TextBox)ctl).Text + "',";        }        if (ctl is DropDownList)        {          SQL = SQL + ctl.ID + "='" + ((DropDownList)ctl).SelectedItem.Value.Trim() + "',";        }      }      if (SQL.IndexOf(',') > -1)      {        SQL = SQL.Substring(0, SQL.Length - 1) + " where " + WyId + "='" + Id + "'";      }      return SQL;  }  

上文是爱站技术频道小编介绍的asp.net简单页面控件赋值实现的方法,相信大家已经得到了准确的答案,程序员正在夜以继日的学习,未来的世界是属于我们的。

请发表您的评论