日期:2014-05-17 浏览次数:20631 次
protected void AddUserInfo() {
SqlConnection cn = new SqlConnection("....");
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = "AddUserInformation";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserName", CreateUserWizard1.UserName.ToString());
cmd.Parameters.AddWithValue("@Balance",0);
cmd.Parameters.AddWithValue("@Addre",null);
cmd.Parameters.AddWithValue("@Telephon",null);
try
{
cn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
string s = e.Message;
Response.Write("<scrpit>alert('" + s + "')</scrpit>");
}
finally {
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
}
}
protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
{
Roles.AddUserToRole(CreateUserWizard1.UserName.ToString(), "User");
AddUserInfo();
Response.Redirect("~/Anonymity/Login.aspx");
}