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

编辑作者:www.789mux.com    在线用户:47    标签: sp    程序    SQL   

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简单页面控件赋值实现的方法,相信大家已经得到了准确的答案,程序员正在夜以继日的学习,未来的世界是属于我们的。

请发表您的评论