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程序設計有所幫助。