今天在向数据库插入数据,之后使用Server.Transfer跳回本页面时,抛出异常:正在终止线程
ry
{if(0== String.Compare(PassWord.Text.Trim(), ConfirmPassword.Text.Trim()))//两次输入密码相同{
MembershipUser mu= Membership.CreateUser(UserName.Text, Password.Text);//添加注册用户Roles.AddUserToRole(UserName.Text,"worker");//添加角色String strConn ="server=.;database=ComInfo;integrated security=true;";//连接字符串SqlConnection conn =newSqlConnection(strConn);//创建数据库链接conn.Open();//打开连接String PassUserid = Request.QueryString["C_Id"];
String userid= mu.PRoviderUserKey.ToString();//获取注册IDSqlCommand cmd =newSqlCommand("insert into Emp(E_Name,E_Sex,E_Position,E_Organisation,E_Address,E_Phone,C_Id,User_Id) values("+"'"+ UserName.Text.Trim() +"',"+"'"+ edt_sex.Text.Trim() +"',"+"'"+ edt_pos.Text.Trim() +"',"+"'"+ edt_dep.Text.Trim() +"',"+"'"+ edt_address.Text.Trim() +"',"+"'"+ edt_phone.Text.Trim() +"',"+"'"+ PassUserid +"',"+//公司ID"'"+ userid +"'"+//用户注册ID")", conn);//sql语句,向Emp表添加数据cmd.ExecuteNonQuery();
conn.Close();
Server.Transfer("~/User/Imformation.aspx");
}
}elseResponse.Write("<script>window.alert('两次输入的密码不同!');</script>");
}catch(Exception ex)
{
Response.Write("<script>window.confirm('"+ ex.Message.ToString() +"');</script>");
}
原因:Server.Transfer的执行,将会内部调用Response.End,将此执行切换到应用程序的事件管线中的application_EndRequest 事件,同时抛出ThreadAbortException 异常,异常信息为“正在中止线程”。
解决办法:将Server.Transfer语句放到finally中,不再抛出异常
finally{
Server.Transfer("~/User/Imformation.aspx");
}