修改用户信息（modify_user_info）

修改用户信息（modify_user_info）

加载页面：

private void Page_Load(object sender, System.EventArgs e)

         {

              // 在此处放置用户代码以初始化页面

              if( ! Page.IsPostBack)

              {

                   //新建连接

                   SqlConnection conn = new SqlConnection();

                   conn.ConnectionString=ConfigurationSettings.AppSettings["ConnectionString"];

                   SqlCommand cmd= new SqlCommand();

                  

                  

                   cmd.CommandText = " Select user_name,user_birthday,user_question,user_sex,user_answer,user_email from user_info WHERE user_id= '"+Request.QueryString["id"]+"'";

                   cmd.Connection = conn;

                  

                 

                   //打开连接,执行操作,返回阅读器

 

                   conn.Open();

                   SqlDataReader reader = cmd.ExecuteReader();

               

 

                   if(reader.Read())

                   {

                      

                       this.lblusername.Text=Convert.ToString(reader["user_name"]);

                     this.ddlnian.SelectedValue=Convert.ToDateTime(reader["user_birthday"]).ToString("yyyy");

                       this.ddlyue.SelectedValue=Convert.ToDateTime(reader["user_birthday"]).ToString("MM");

                       this.ddlri.SelectedValue=Convert.ToDateTime(reader["user_birthday"]).ToString("dd");

                       this.ddlquestion.SelectedValue=Convert.ToString(reader["user_question"]);

                       this.txtanswer.Text=Convert.ToString(reader["user_answer"]);

                       this.txtemail.Text=Convert.ToString(reader["user_email"]);

                       this.rblsex.SelectedValue=Convert.ToString(reader["user_sex"]);

                   }

 

                  

                

                   //关闭数据库,释放连接

                   reader.Close();

                   conn.Close();

             

             

              }// 在此处放置用户代码以初始化页面

 

         }

 

         #region Web 窗体设计器生成的代码

         override protected void OnInit(EventArgs e)

         {

              //

              // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。

              //

              InitializeComponent();

              base.OnInit(e);

         }

        

         /// <summary>

         /// 设计器支持所需的方法 - 不要使用代码编辑器修改

         /// 此方法的内容。

         /// </summary>

         private void InitializeComponent()

         {   

              this.btnsubmit.Click += new System.EventHandler(this.btnsubmit_Click);

              this.btnreset.Click += new System.EventHandler(this.btnreset_Click);

              this.Load += new System.EventHandler(this.Page_Load);

 

         }

         #endregion

 

修改信息：

         private void btnsubmit_Click(object sender, System.EventArgs e)

         {

              if(Page.IsValid)

              {

                           

                  

                   string usersex=rblsex.SelectedItem.Value;

                   string birthday=ddlnian.SelectedItem.Text.ToString()+"-"+ddlyue.SelectedItem.Text.ToString()+"-"+ddlri.SelectedItem.Text.ToString();

                   string question=this.ddlquestion.SelectedItem.Value;

                   string answer=this.txtanswer.Text.ToString();

                   string email=txtemail.Text;

                   string update ="update user_info set  user_sex='"+usersex+"',user_birthday='"+birthday+"',user_question='"+question+"',user_answer='"+answer+"',user_email='"+email+"' where user_id= '"+Request.QueryString["id"]+"'";

 

 

             SqlConnection conn = new SqlConnection();

              conn.ConnectionString=ConfigurationSettings.AppSettings["ConnectionString"];

              SqlCommand cmd= new SqlCommand();

              cmd.CommandText=update;

              cmd.Connection = conn;

 

              conn.Open();

              cmd.ExecuteNonQuery();

 

              conn.Close();

              Response.Write("<script Language = 'javascript'>alert('修改成功！');;window.location.replace('login_userinfo_add.aspx');</script>");

         }

                  

                  

              }

重置页面：

         private void btnreset_Click(object sender, System.EventArgs e)

         {

              this.txtanswer.Text="";

              this.txtemail.Text="";

              this.ddlquestion.SelectedValue="0";

              this.ddlyue.SelectedValue="01";

              this.ddlri.SelectedValue="01";

              this.ddlnian.SelectedValue="1970";

              this.rblsex.SelectedValue="0";

        

         }