System/Sys_National_Edit.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class System_Sys_Natinal_Add : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Get_data();
        }
    }

    #region 更新数据
    protected void Button1_Click(object sender, EventArgs e)
    {

        string sql2 = "update X_National set X_National_Name='" + txt_name.Text + "',X_National_Sex='" + DropDownList_Sex.SelectedValue + "',X_National_Nation='" + txt_national.Text + "',X_National_Birth='" + txt_birth.Text + "',X_National_IsHOH='" + DropDownList_IsHOH.SelectedValue + "',X_National_Number='" + txt_num.Text + "',X_National_Building='" + txt_building.Text + "',X_National_Stree_Num='" + txt_stree_num.Text + "',X_National_HOHs='" + txt_hohs.Text + "',X_National_Graduation='" + txt_graduation.Text + "',X_National_Politics='" + txt_politics.Text + "',X_National_Work_Date='" + txt_work_date.Text + "',X_National_Native_Place='" + txt_native_place.Text + "',X_National_Unit='" + txt_unit.Text + "',X_National_Join_Date='" + txt_tohere.Text + "',X_National_Addr='" + txt_hoh_addr.Text + "',X_National_Unit_Tel='" + txt_unit_tel.Text + "',X_National_Home_Tel='" + txt_home_tel.Text + "',X_National_Pho='" + txt_pho.Text + "',X_National_Content='" + txt_content.Text + "' where X_National_ID="+Request.QueryString["NId"];
        try
        {
            SqlConnection cn = DB.OpenConnection();
            SqlCommand cmd = new SqlCommand(sql2, cn);
            cmd.ExecuteNonQuery();
            cn.Close();
            cn.Dispose();
            Common.ShowMessage(this.Page, "更新成功！", "");

        }
        catch (Exception ex)
        {
           // Response.Write(ex);
            Common.ShowMessage(this.Page, "服务器繁忙，更新失败！", "");
        }
      
    }
    #endregion

    void Get_data()
    {
        SqlConnection cn = DB.OpenConnection();
        SqlDataReader dr = DB.getDataReader("select * from X_National where X_National_ID="+Request.QueryString["NId"],cn);
        if (dr.Read())
        {
            txt_birth.Text = dr["X_National_Birth"].ToString();
            txt_building.Text = dr["X_National_Building"].ToString();
            txt_code.Text = dr["X_National_Code"].ToString();
            txt_content.Text = dr["X_National_Content"].ToString();
            txt_graduation.Text = dr["X_National_Graduation"].ToString();
            txt_hoh_addr.Text = dr["X_National_Addr"].ToString();
            txt_hoh_code.Text = dr["X_National_HOH_Code"].ToString();
            txt_hohs.Text = dr["X_National_HOHs"].ToString();
            txt_home_tel.Text = dr["X_National_Home_Tel"].ToString();