|
蓝森林 http://www.lslnet.com 2006年8月25日 8:28
.net高手请进
以下代码有问题吗
在我机器上测试 很卡
-----------------------------
protected System.Web.UI.WebControls.TextBox TextBox7;
protected System.Web.UI.WebControls.TextBox TextBox23;
protected System.Web.UI.WebControls.DropDownList DropDownList1;
protected System.Web.UI.WebControls.DropDownList DropDownList2;
protected System.Web.UI.WebControls.DropDownList DropDownList3;
protected System.Web.UI.WebControls.DropDownList DropDownList10;
protected System.Web.UI.WebControls.DropDownList DropDownList11;
protected System.Web.UI.HtmlControls.HtmlForm Form1;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.Button Button2;
protected System.Web.UI.WebControls.Button Button3;
protected System.Web.UI.WebControls.Panel Panel1;
protected System.Web.UI.WebControls.Panel Panel2;
protected System.Web.UI.WebControls.Button Button4;
protected System.Web.UI.WebControls.Button Button5;
protected System.Web.UI.WebControls.Panel Panel3;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.DropDownList nian;
protected System.Web.UI.WebControls.DropDownList yue;
protected System.Web.UI.WebControls.DropDownList ri;
protected System.Web.UI.WebControls.DropDownList nian1;
protected System.Web.UI.WebControls.DropDownList yue1;
protected System.Web.UI.WebControls.RadioButtonList RadioButtonList1;
protected System.Web.UI.WebControls.RadioButtonList RadioButtonList2;
protected System.Web.UI.WebControls.RadioButtonList RadioButtonList5;
protected System.Web.UI.WebControls.RadioButtonList RadioButtonList7;
protected System.Web.UI.WebControls.RadioButtonList RadioButtonList8;
protected System.Web.UI.WebControls.RadioButtonList RadioButtonList9;
protected System.Web.UI.WebControls.RadioButtonList RadioButtonList3;
protected System.Web.UI.WebControls.RadioButtonList RadioButtonList4;
protected System.Web.UI.WebControls.RadioButtonList RadioButtonList10;
protected System.Web.UI.WebControls.RadioButtonList RadioButtonList11;
protected System.Web.UI.WebControls.TextBox TextBox25;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator6;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator7;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator9;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator11;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator8;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator10;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator14;
protected System.Web.UI.WebControls.DropDownList DropDownList4;
protected System.Web.UI.WebControls.DropDownList DropDownList5;
protected System.Web.UI.WebControls.DropDownList DropDownList6;
protected System.Web.UI.WebControls.DropDownList DropDownList7;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator16;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator15;
protected System.Web.UI.WebControls.TextBox TextBox1;
public j dropjob;
protected System.Web.UI.WebControls.TextBox TextBox3;
protected System.Web.UI.WebControls.ImageButton ImageButton1;
public DBconn DB= new DBconn();
private void Page_Load(object sender, System.EventArgs e)
{
if (Session["per_uname"]==null)
{
Response.Write("<SCRIPT language=JavaScript>alert('非法登陆 返回登陆');");
Response.Write("this.location.href='../login.aspx';</SCRIPT>" );
}
else
{
if(!IsPostBack)
{
ArrayList area=new ArrayList();
area.Add("辽宁省");
area.Add("北京市");
area.Add("上海市");
area.Add("天津市");
area.Add("重庆市");
area.Add("吉林省");
area.Add("黑龙江省");
area.Add("安徽省");
area.Add("福建省");
area.Add("甘肃省");
area.Add("广东省");
area.Add("广西省");
area.Add("贵州省");
area.Add("河北省");
area.Add("河南省");
area.Add("湖北省");
area.Add("湖南省");
area.Add("江苏省");
area.Add("江西省");
area.Add("内蒙古");
area.Add("山东省");
area.Add("山西省");
area.Add("陕西省");
area.Add("四川省");
area.Add("云南省");
area.Add("浙江省");
area.Add("四川省");
area.Add("海南省");
area.Add("新疆");
area.Add("宁夏");
area.Add("西藏");
area.Add("香港");
area.Add("台湾");
area.Add("澳门");
DropDownList1.DataSource=area;
DropDownList1.DataBind();
DropDownList2.DataSource=area;
DropDownList2.DataBind();
DropDownList10.DataSource=area;
DropDownList10.DataBind();
DropDownList11.DataSource=area;
DropDownList11.DataBind();
DropDownList3.Items.Add( new ListItem( "--请选择--","") );
DropDownList3.Items.Add( new ListItem( "博士","博士") );
DropDownList3.Items.Add( new ListItem( "硕士","硕士") );
DropDownList3.Items.Add( new ListItem( "大学本科","大学本科") );
DropDownList3.Items.Add( new ListItem( "大学专科","大学专科") );
DropDownList3.Items.Add( new ListItem( "职高及中专","职高及中专") );
DropDownList3.Items.Add( new ListItem( "高中以下","高中以下") );
ArrayList nyear=new ArrayList();
for(int i=1945;i<2010;i++)
nyear.Add(i);
nian.DataSource=nyear;
nian.DataBind();
nian1.DataSource=nyear;
nian1.DataBind();
ArrayList nyue=new ArrayList();
for(int i=1;i<=12;i++)
nyue.Add(i);
yue.DataSource=nyue;
yue.DataBind();
yue1.DataSource=nyue;
yue1.DataBind();
ArrayList nri=new ArrayList();
for(int i=1;i<=31;i++)
nri.Add(i);
ri.DataSource=nri;
ri.DataBind();
dropjob= new j();
dropjob.Addjoblist(DropDownList4);
dropjob.Addjoblist(DropDownList5);
dropjob.Addzyelist(DropDownList6);
dropjob.Addzyelist(DropDownList7);
Panel1.Visible=true;
Panel2.Visible=false;
Panel3.Visible=false;
string uname0=Session["per_uname"].ToString();
string strSel= "select * from person where uname='"+uname0+"'and iname<>'null'";
SqlCommand myCommand= new SqlCommand(strSel,DB.MyConnection);
DB.Dbopen();
SqlDataReader dr = myCommand.ExecuteReader();
if (dr.Read()==true)
{
TextBox1.Text=dr["iname"].ToString();
TextBox2.Text=dr["code"].ToString();
nian.SelectedItem.Value="";
TextBox4.Text=dr["nianling"].ToString();
TextBox23.Text=dr["guoji"].ToString();
TextBox7.Text=dr["mzhu"].ToString();
TextBox5.Text=dr["shengao"].ToString();
TextBox6.Text=dr["tizhong"].ToString();
DropDownList1.SelectedItem.Value=dr["hka"].ToString();
DropDownList2.SelectedItem.Value=dr["hkb"].ToString();
DropDownList3.SelectedItem.Value=dr["edu"].ToString();
DropDownList4.SelectedItem.Value=dr["jobs"].ToString();
DropDownList4.SelectedItem.Text=dr["jobs"].ToString();
DropDownList5.SelectedItem.Value=dr["job1"].ToString();
DropDownList5.SelectedItem.Text=dr["job1"].ToString();
DropDownList6.SelectedItem.Value=dr["zye"].ToString();
DropDownList7.SelectedItem.Value=dr["zyes"].ToString();
TextBox8.Text=dr["school"].ToString();
TextBox25.Text=dr["language"].ToString();
TextBox12.Text=dr["gznum"].ToString();
TextBox13.Text=dr["yuex"].ToString();
TextBox14.Text=dr["cname"].ToString();
TextBox15.Text=dr["address"].ToString();
TextBox16.Text=dr["posts"].ToString();
TextBox17.Text=dr["phone"].ToString();
TextBox18.Text=dr["shouji"].ToString();
TextBox19.Text=dr["oicq"].ToString();
TextBox21.Text=dr["emails"].ToString();
TextBox22.Text=dr["http"].ToString();
TextBox9.Text=dr["edus"].ToString();
TextBox10.Text=dr["gzjl"].ToString();
TextBox11.Text=dr["otheryq"].ToString();
ImageButton1.ImageUrl=dr["pic"].ToString();
TextBox3.Text=dr["pic"].ToString();
Button5.Text="更新入库";
DB.Dbclose();
}
DB.Dbclose();
}
}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Button2.Click += new System.EventHandler(this.Button2_Click);
this.Button3.Click += new System.EventHandler(this.Button3_Click);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Button4.Click += new System.EventHandler(this.Button4_Click);
this.Button5.Click += new System.EventHandler(this.Button5_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void Button2_Click(object sender, System.EventArgs e)
{
Panel1.Visible=false;
Panel2.Visible=true;
Panel3.Visible=false;
RadioButtonList9.Visible=true;
}
private void Button3_Click(object sender, System.EventArgs e)
{
Panel1.Visible=true;
Panel2.Visible=false;
Panel3.Visible=false;
}
private void Button4_Click(object sender, System.EventArgs e)
{
Panel1.Visible=false;
Panel2.Visible=true;
Panel3.Visible=false;
}
private void Button1_Click(object sender, System.EventArgs e)
{
Panel1.Visible=false;
Panel2.Visible=false;
Panel3.Visible=true;
Label1.Visible=true;
Label1.Text="<font size='+2'><b>您的基本信息如下:</b></font>"+"<p>";
Label1.Text+="姓名:"+"<b>"+TextBox1.Text.ToString()+"</b>"+"<br>";
Label1.Text+="身份证号码:"+"<b>"+TextBox2.Text.ToString()+"</b>"+"<br>";
Label1.Text+="出生日期:"+"<b>"+nian.SelectedItem.Text.ToString()+"年"+yue.SelectedItem.Text.ToString()+"月"+ri.SelectedItem.Text.ToString()+"日"+"</b>"+"<br>";
Label1.Text+="年龄:"+"<b>"+TextBox4.Text.ToString()+"</b>"+"<br>";
Label1.Text+="性别:"+"<b>"+RadioButtonList1.SelectedValue.ToString()+"</b>"+"<br>";
Label1.Text+="国籍:"+"<b>"+TextBox23.Text.ToString()+"</b>"+"<br>";
Label1.Text+="民族:"+"<b>"+TextBox7.Text.ToString()+"</b>"+"<br>";
Label1.Text+="身高:"+"<b>"+TextBox5.Text.ToString()+"</b>"+"<br>";
Label1.Text+="体重:"+"<b>"+TextBox6.Text.ToString()+"</b>"+"<br>";
Label1.Text+="婚姻状况:"+"<b>"+RadioButtonList2.SelectedValue.ToString()+"</b>"+"<br>";
Label1.Text+="户口所在地:"+"<b>"+DropDownList1.SelectedItem.Text.ToString()+"</b>"+"<br>";
Label1.Text+="目前所在地:"+"<b>"+DropDownList2.SelectedItem.Text.ToString()+"</b>"+"<br>";
Label1.Text+="最高教育程度:"+"<b>"+DropDownList3.SelectedItem.Value.ToString()+"</b>"+"<br>";
Label1.Text+="专业1:"+"<b>"+DropDownList6.SelectedItem.Value.ToString()+"</b>"+"<br>";
Label1.Text+="专业1:"+"<b>"+DropDownList7.SelectedItem.Value.ToString()+"</b>"+"<br>";
Label1.Text+="毕业院校:"+"<b>"+TextBox8.Text.ToString()+"</b>"+"<br>";
Label1.Text+="毕业日期:"+"<b>"+nian1.SelectedItem.Text.ToString()+"年"+yue1.SelectedItem.Text.ToString()+"月"+"</b>"+"<br>";
Label1.Text+="政治面貌:"+"<b>"+RadioButtonList3.SelectedValue.ToString()+"</b>"+"<br>";
Label1.Text+="现有职称:"+"<b>"+RadioButtonList4.SelectedValue.ToString()+"</b>"+"<br>";
Label1.Text+="人才类型:"+"<b>"+RadioButtonList5.SelectedValue.ToString()+"</b>"+"<br>";
Label1.Text+="外语语种:"+"<b>"+TextBox25.Text.ToString()+"</b>"+"<br>";
Label1.Text+="外语水平:"+"<b>"+RadioButtonList11.SelectedValue.ToString()+"</b>"+"<br>";
Label1.Text+="普通话程度:"+"<b>"+RadioButtonList8.SelectedValue.ToString()+"</b>"+"<br>";
Label1.Text+="计算机能力:"+"<b>"+RadioButtonList7.SelectedValue.ToString()+"</b>"+"<br>";
Label1.Text+="相关工作经验::"+"<b>"+TextBox12.Text.ToString()+"</b>"+"年"+"<br>";
Label1.Text+=""+"----------------------------------------------------"+"<br>";
Label1.Text+="求职类型:"+"<b>"+RadioButtonList9.SelectedValue.ToString()+"</b>"+"<br>";
Label1.Text+="应聘职位名称1:"+"<b>"+DropDownList4.SelectedItem.Value.ToString()+"</b>"+"<br>";
Label1.Text+="应聘职位名称2:"+"<b>"+DropDownList5.SelectedItem.Value.ToString()+"</b>"+"<br>";
Label1.Text+="希望工作地点1:"+"<b>"+DropDownList10.SelectedItem.Value.ToString()+"</b>"+"<br>";
Label1.Text+="希望工作地点2:"+"<b>"+DropDownList11.SelectedItem.Value.ToString()+"</b>"+"<br>";
Label1.Text+="月薪要求:"+"<b>"+TextBox13.Text.ToString()+"</b>"+"<br>";
Label1.Text+=""+"----------------------------------------------------"+"<br>";
Label1.Text+="联系人:"+"<b>"+TextBox14.Text.ToString()+"</b>"+"<br>";
Label1.Text+="通讯地址:"+"<b>"+TextBox15.Text.ToString()+"</b>"+"<br>";
Label1.Text+="邮政编码:"+"<b>"+TextBox16.Text.ToString()+"</b>"+"<br>";
Label1.Text+="联系电话:"+"<b>"+TextBox17.Text.ToString()+"</b>"+"<br>";
Label1.Text+="手机:"+"<b>"+TextBox18.Text.ToString()+"</b>"+"<br>";
Label1.Text+="OICQ:"+"<b>"+TextBox19.Text.ToString()+"</b>"+"<br>";
Label1.Text+="电子信箱:"+"<b>"+TextBox20.Text.ToString()+"</b>"+"<br>";
Label1.Text+="备用信箱:"+"<b>"+TextBox21.Text.ToString()+"</b>"+"<br>";
Label1.Text+="个人主页:"+"<b>"+TextBox22.Text.ToString()+"</b>"+"<br>";
Label1.Text+="可到职日期:"+"<b>"+RadioButtonList10.SelectedValue.ToString()+"</b>"+"<br>";
Label1.Text+="<img height=149 src='"+TextBox3.Text.ToString().Trim()+"'width=128 border=0>";
}
private void Button5_Click(object sender, System.EventArgs e)
{
string shengri=nian.SelectedItem.Text.ToString()+"年"+yue.SelectedItem.Text.ToString()+"月"+ri.SelectedItem.Text.ToString()+"日";///出生日期
string biyeriqi=nian1.SelectedItem.Text.ToString()+"年"+yue1.SelectedItem.Text.ToString()+"月";///毕业日期
SqlCommand myCommand = new SqlCommand("proc_per_reg" ,DB.MyConnection);
myCommand.CommandType=CommandType.StoredProcedure;
SqlParameter uid=new SqlParameter("@uid",SqlDbType.VarChar,10);
uid.Value=Session["per_uname"].ToString();
myCommand.Parameters.Add(uid);
SqlParameter guoji=new SqlParameter("@guoji",SqlDbType.VarChar,10);
guoji.Value=TextBox23.Text.ToString();
myCommand.Parameters.Add(guoji);
SqlParameter shengao=new SqlParameter("@shengao",SqlDbType.VarChar,10);
shengao.Value=TextBox5.Text.ToString();
myCommand.Parameters.Add(shengao);
SqlParameter tizhong=new SqlParameter("@tizhong",SqlDbType.VarChar,10);
tizhong.Value=TextBox6.Text.ToString();
myCommand.Parameters.Add(tizhong);
SqlParameter nianling=new SqlParameter("@nianling",SqlDbType.VarChar,10);
nianling.Value=TextBox4.Text.ToString();
myCommand.Parameters.Add(nianling);
SqlParameter iname=new SqlParameter("@iname",SqlDbType.VarChar,10);
iname.Value=TextBox1.Text.ToString();
myCommand.Parameters.Add(iname);
Session["per_cname"]=TextBox1.Text.ToString().Trim();
SqlParameter sex=new SqlParameter("@sex",SqlDbType.VarChar,10);
sex.Value=RadioButtonList1.SelectedValue.ToString();
myCommand.Parameters.Add(sex);
SqlParameter bday=new SqlParameter("@bday",SqlDbType.VarChar,20);
bday.Value=nian.SelectedItem.Text.ToString()+"年"+yue.SelectedItem.Text.ToString()+"月"+ri.SelectedItem.Text.ToString()+"日";
myCommand.Parameters.Add(bday);
SqlParameter code=new SqlParameter("@code",SqlDbType.VarChar,20);
code.Value=TextBox2.Text.ToString();
myCommand.Parameters.Add(code);
SqlParameter mzhu=new SqlParameter("@mzhu",SqlDbType.VarChar,10);
mzhu.Value=TextBox7.Text.ToString();
myCommand.Parameters.Add(mzhu);
SqlParameter marry=new SqlParameter("@marry",SqlDbType.VarChar,10);
marry.Value=RadioButtonList2.SelectedValue.ToString();
myCommand.Parameters.Add(marry);
SqlParameter hka=new SqlParameter("@hka",SqlDbType.VarChar,20);
hka.Value=DropDownList1.SelectedItem.Text.ToString();
myCommand.Parameters.Add(hka);
SqlParameter hkb=new SqlParameter("@hkb",SqlDbType.VarChar,20);
hkb.Value=DropDownList2.SelectedItem.Text.ToString();
myCommand.Parameters.Add(hkb);
SqlParameter zzmm=new SqlParameter("@zzmm",SqlDbType.VarChar,10);
zzmm.Value=RadioButtonList3.SelectedValue.ToString();
myCommand.Parameters.Add(zzmm);
SqlParameter zcheng=new SqlParameter("@zcheng",SqlDbType.VarChar,10);
zcheng.Value=RadioButtonList4.SelectedValue.ToString();
myCommand.Parameters.Add(zcheng);
SqlParameter edu=new SqlParameter("@edu",SqlDbType.VarChar,20);
edu.Value=DropDownList3.SelectedItem.Value.ToString();
myCommand.Parameters.Add(edu);
SqlParameter zye=new SqlParameter("@zye",SqlDbType.VarChar,20);
zye.Value=DropDownList6.SelectedItem.Value.ToString();
myCommand.Parameters.Add(zye);
SqlParameter zyes=new SqlParameter("@zyes",SqlDbType.VarChar,20);
zyes.Value=DropDownList7.SelectedItem.Value.ToString();
myCommand.Parameters.Add(zyes);
SqlParameter school=new SqlParameter("@school",SqlDbType.VarChar,20);
school.Value=TextBox8.Text.ToString();
myCommand.Parameters.Add(school);
SqlParameter byday=new SqlParameter("@byday",SqlDbType.VarChar,20);
byday.Value=nian1.SelectedItem.Text.ToString()+"年"+yue1.SelectedItem.Text.ToString()+"月";
myCommand.Parameters.Add(byday);
SqlParameter language=new SqlParameter("@language",SqlDbType.VarChar,10);
language.Value=TextBox25.Text.ToString();
myCommand.Parameters.Add(language);
SqlParameter lanlevel=new SqlParameter("@lanlevel",SqlDbType.VarChar,10);
lanlevel.Value=RadioButtonList11.SelectedValue.ToString();
myCommand.Parameters.Add(lanlevel);
SqlParameter rctype=new SqlParameter("@rctype",SqlDbType.VarChar,10);
rctype.Value=RadioButtonList5.SelectedValue.ToString();
myCommand.Parameters.Add(rctype);
SqlParameter pthua=new SqlParameter("@pthua",SqlDbType.VarChar,10);
pthua.Value=RadioButtonList8.SelectedValue.ToString();
myCommand.Parameters.Add(pthua);
SqlParameter computer=new SqlParameter("@computer",SqlDbType.VarChar,10);
computer.Value=RadioButtonList7.SelectedValue.ToString();
myCommand.Parameters.Add(computer);
SqlParameter gznum=new SqlParameter("@gznum",SqlDbType.VarChar,10);
gznum.Value=TextBox12.Text.ToString();
myCommand.Parameters.Add(gznum);
SqlParameter jobtype=new SqlParameter("@jobtype",SqlDbType.VarChar,10);
jobtype.Value=RadioButtonList9.SelectedValue.ToString();
myCommand.Parameters.Add(jobtype);
SqlParameter yuex=new SqlParameter("@yuex",SqlDbType.VarChar,10);
yuex.Value=TextBox13.Text.ToString();
myCommand.Parameters.Add(yuex);
SqlParameter cname=new SqlParameter("@cname",SqlDbType.VarChar,10);
cname.Value=TextBox14.Text.ToString();
myCommand.Parameters.Add(cname);
SqlParameter phone=new SqlParameter("@phone",SqlDbType.VarChar,20);
phone.Value=TextBox17.Text.ToString();
myCommand.Parameters.Add(phone);
SqlParameter oicq=new SqlParameter("@oicq",SqlDbType.VarChar,20);
oicq.Value=TextBox19.Text.ToString();
myCommand.Parameters.Add(oicq);
SqlParameter http=new SqlParameter("@http",SqlDbType.VarChar,10);
http.Value=TextBox22.Text.ToString();
myCommand.Parameters.Add(http);
SqlParameter jobs=new SqlParameter("@jobs",SqlDbType.VarChar,20);
jobs.Value=DropDownList4.SelectedItem.Value.ToString();
myCommand.Parameters.Add(jobs);
SqlParameter job1=new SqlParameter("@job1",SqlDbType.VarChar,20);
job1.Value=DropDownList5.SelectedItem.Value.ToString();
myCommand.Parameters.Add(job1);
SqlParameter workdate=new SqlParameter("@workdate",SqlDbType.VarChar,20);
workdate.Value=RadioButtonList10.SelectedValue.ToString();
myCommand.Parameters.Add(workdate);
SqlParameter gzdd1=new SqlParameter("@gzdd1",SqlDbType.VarChar,20);
gzdd1.Value=DropDownList10.SelectedItem.Text.ToString();
myCommand.Parameters.Add(gzdd1);
SqlParameter gzdd2=new SqlParameter("@gzdd2",SqlDbType.VarChar,20);
gzdd2.Value=DropDownList11.SelectedItem.Text.ToString();
myCommand.Parameters.Add(gzdd2);
SqlParameter posts=new SqlParameter("@posts",SqlDbType.VarChar,10);
posts.Value=TextBox16.Text.ToString();
myCommand.Parameters.Add(posts);
SqlParameter shouji=new SqlParameter("@shouji",SqlDbType.VarChar,20);
shouji.Value=TextBox18.Text.ToString();
myCommand.Parameters.Add(shouji);
SqlParameter emails=new SqlParameter("@emails",SqlDbType.VarChar,20);
emails.Value=TextBox21.Text.ToString();
myCommand.Parameters.Add(emails);
SqlParameter address=new SqlParameter("@address",SqlDbType.VarChar,50);
address.Value=TextBox15.Text.ToString();
myCommand.Parameters.Add(address);
SqlParameter edus=new SqlParameter("@edus",SqlDbType.VarChar,1000);
edus.Value=TextBox9.Text.ToString();
myCommand.Parameters.Add(edus);
SqlParameter gzjl=new SqlParameter("@gzjl",SqlDbType.VarChar,1000);
gzjl.Value=TextBox10.Text.ToString();
myCommand.Parameters.Add(gzjl);
SqlParameter otheryq=new SqlParameter("@otheryq",SqlDbType.VarChar,1000);
otheryq.Value=TextBox11.Text.ToString();
myCommand.Parameters.Add(otheryq);
DateTime currentTime=new DateTime();
currentTime=DateTime.Now;
string tmpdate=currentTime.Year.ToString()+"-"+currentTime.Month.ToString()+"-"+currentTime.Day.ToString();
SqlParameter idate=new SqlParameter("@idate",SqlDbType.VarChar,20);
idate.Value=tmpdate;
myCommand.Parameters.Add(idate);
if(TextBox3.Text.ToString().Trim()=="")
TextBox3.Text="images/person_photo.jpg";
SqlParameter pic=new SqlParameter("@pic",SqlDbType.VarChar,50);
pic.Value=TextBox3.Text.ToString().Trim();
myCommand.Parameters.Add(pic);
DB.Dbopen();
myCommand.ExecuteNonQuery();
DB.Dbclose();
Response.Write("<SCRIPT language=JavaScript>alert('完毕!');");
Response.Write("this.location.href='main.aspx';</SCRIPT>" );
}
}
}
|
|