📄 zilxg.aspx.cs
字号:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Web.Security;
namespace chunsky.manage
{
/// <summary>
/// zilxg 的摘要说明。
/// </summary>
public class zilxg : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label showuid;
protected System.Web.UI.WebControls.TextBox email;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_email01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_email02;
protected System.Web.UI.WebControls.DropDownList sex;
protected System.Web.UI.WebControls.TextBox age;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_age01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_age02;
protected System.Web.UI.WebControls.TextBox orgz;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_orgz01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_orgz02;
protected System.Web.UI.WebControls.TextBox orge;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_orge01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_orge02;
protected System.Web.UI.WebControls.TextBox usernamez;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_usernamez01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_usernamez02;
protected System.Web.UI.WebControls.TextBox usernamee;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_usernamee01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_usernamee02;
protected System.Web.UI.WebControls.TextBox govz;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_govz01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_govz02;
protected System.Web.UI.WebControls.TextBox gove;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_gove01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_gov02;
protected System.Web.UI.WebControls.TextBox shengz;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_shengz01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_shengz02;
protected System.Web.UI.WebControls.TextBox shenge;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_shenge01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_shenge02;
protected System.Web.UI.WebControls.TextBox cityz;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_cityz01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_cityz02;
protected System.Web.UI.WebControls.TextBox citye;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_citye01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_citye02;
protected System.Web.UI.WebControls.TextBox addressz;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_addressz01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_addressz02;
protected System.Web.UI.WebControls.TextBox addresse;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_addresse01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_addresse02;
protected System.Web.UI.WebControls.TextBox postnumber;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_postnumber01;
protected System.Web.UI.WebControls.RegularExpressionValidator chk_postnumber02;
protected System.Web.UI.WebControls.TextBox tel;
protected System.Web.UI.WebControls.RequiredFieldValidator chk_tel01;
protected System.Web.UI.WebControls.TextBox oicq;
protected System.Web.UI.WebControls.TextBox fax;
protected System.Web.UI.WebControls.Button btnSubmit;
protected System.Web.UI.WebControls.ValidationSummary chkall;
config obj = new config();
OleDbCommand mycommand;
OleDbDataReader rs;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(Session["myuid"]==null)
Response.Redirect("login.aspx");
else
{
if(!IsPostBack)
{
obj.open();
mycommand=new OleDbCommand("select * from [csuser] where uid='"+ Session["myuid"].ToString() +"'",obj.myconn);
rs=mycommand.ExecuteReader();
if(rs.Read())
{
showuid.Text=rs["uid"].ToString();
email.Text=rs["email"].ToString();
age.Text=rs["age"].ToString();
orgz.Text=rs["orgz"].ToString();
orge.Text=rs["orge"].ToString();
usernamez.Text=rs["namez"].ToString();
usernamee.Text=rs["namee"].ToString();
govz.Text=rs["govz"].ToString();
gove.Text=rs["gove"].ToString();
shengz.Text=rs["shengz"].ToString();
shenge.Text=rs["shenge"].ToString();
cityz.Text=rs["cityz"].ToString();
citye.Text=rs["citye"].ToString();
addressz.Text=rs["dizhiz"].ToString();
addresse.Text=rs["dizhie"].ToString();
postnumber.Text=rs["postnumber"].ToString();
tel.Text=rs["tel"].ToString();
oicq.Text=rs["oicq"].ToString();
fax.Text=rs["fax"].ToString();
obj.myconn.Close();
}
else
{
obj.myconn.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.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void btnSubmit_Click(object sender, System.EventArgs e)
{
if(Page.IsValid)
{
//修改用户资料
obj.open();
string sql="update [csuser] set email='"+email.Text+"',sex='"+sex.SelectedItem.Text+"',age='"+age.Text+"',orgz='"+orgz.Text+"',orge='"+orge.Text+"',namez='"+usernamez.Text+"',namee='"+usernamee.Text+"',govz='"+govz.Text+"',gove='"+gove.Text+"',shengz='"+shengz.Text+"',shenge='"+shenge.Text+"',cityz='"+cityz.Text+"',citye='"+citye.Text+"',dizhiz='"+addressz.Text+"',dizhie='"+addresse.Text+"',postnumber='"+postnumber.Text+"',tel='"+tel.Text+"',oicq='"+oicq.Text+"',fax='"+fax.Text+"' where uid='"+Session["myuid"].ToString()+"'";
mycommand=new OleDbCommand(sql,obj.myconn);
mycommand.ExecuteNonQuery();
obj.myconn.Close();
//obj.mdbconn.Close();
//注册成功,出现提示页面。
Response.Redirect("xg_cg.aspx");
}
mycommand.Dispose();
obj.myconn.Close();
obj.myconn.Dispose();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -