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相关内容感兴趣的读者可查看本站专题：《asp.net操作json技巧总结》、《asp.net字符串操作技巧汇总》、《asp.net操作xml技巧总结》、《asp.net文件操作技巧汇总》、《asp.net ajax技巧总结专题》及《asp.net缓存操作技巧总结》。

希望本文所述对大家asp.net程序设计有所帮助。