首先在aspnetdb中建立这样一张表
前台页面
---------------------------------------------------------------------------------------------------------------
按钮事件的处理
protected void Button1_Click(object sender, EventArgs e) { MembershipCreateStatus ex;//创建用户返回的错误信息 MembershipUser newuser = Membership.CreateUser(TextName.Text.Trim(), TextPwd.Text.Trim(), TextEmail.Text.Trim() +"@"+ DropDownListemail.SelectedValue, TextQues.Text.Trim(), TextAnswer.Text.Trim(),true,out ex); if (newuser == null) { Msg.Text = GetErrorMessage(ex); } else {
//newuser.ProviderUserKey 返回用户唯一标识对象 CreatXinx((Guid)newuser.ProviderUserKey, TextAdress.Text.Trim(), TextTel.Text.Trim(), TextPhon.Text.Trim(), TextCompany.Text.Trim(), TextCountry.Text.Trim()); Msg.Text = "创建成功!";
//do nothing!! } }
//遍历错误类型。输出错误信息 public string GetErrorMessage(MembershipCreateStatus status) { switch (status) { case MembershipCreateStatus.DuplicateUserName: return "Username already exists. Please enter a different user name.";
case MembershipCreateStatus.DuplicateEmail: return "A username for that e-mail address already exists. Please enter a different e-mail address.";
case MembershipCreateStatus.InvalidPassword: return "The password provided is invalid. Please enter a valid password value.";
case MembershipCreateStatus.InvalidEmail: return "The e-mail address provided is invalid. Please check the value and try again.";
case MembershipCreateStatus.InvalidAnswer: return "The password retrieval answer provided is invalid. Please check the value and try again.";
case MembershipCreateStatus.InvalidQuestion: return "The password retrieval question provided is invalid. Please check the value and try again.";
case MembershipCreateStatus.InvalidUserName: return "The user name provided is invalid. Please check the value and try again.";
case MembershipCreateStatus.ProviderError: return "The authentication provider returned an error. Please verify your entry and try again. If the problem persists, please contact your system administrator.";
case MembershipCreateStatus.UserRejected: return "The user creation request has been canceled. Please verify your entry and try again. If the problem persists, please contact your system administrator.";
default: return "An unknown error occurred. Please verify your entry and try again. If the problem persists, please contact your system administrator."; } }
//向表中添加用户的信息
public void CreatXinx(Guid UserId,string Adress,string tel,string phone,string company,string country) { public static string Aspnetdbconn = "server=.;database=aspnetdb;uid=sa;pwd=qwe2323478"; SqlConnection conn = new SqlConnection(Aspnetdbconn); SqlCommand MyCommand = new SqlCommand(); conn.Open(); string sqlstr = "INSERT INTO User_xinxi(UserId,Adress,Pone,Commpany,Country,Tel) VALUES (@UserId,@Adress,@Pone,@Commpany,@Country,@Tel)"; MyCommand.Connection = conn; MyCommand.CommandText = sqlstr; MyCommand.Parameters.AddWithValue("@UserId", UserId); MyCommand.Parameters.AddWithValue("Adress", Adress); MyCommand.Parameters.AddWithValue("Pone", phone); MyCommand.Parameters.AddWithValue("Commpany", company); MyCommand.Parameters.AddWithValue("Country", country); MyCommand.Parameters.AddWithValue("Tel", tel); MyCommand.ExecuteNonQuery(); conn.Close(); }
下面为登陆页前台代码,可以忽略。可供朋友复制 <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Login.aspx.cs" Inherits="Login" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd ">
<html xmlns="http://www.w3.org/1999/xhtml " > <head runat="server"> <title>无标题页</title> </head> <body> <form id="form1" runat="server"> <div> <table cellpadding="1" cellspacing="1" style=" 523px; height: 199px; background-color: #cc6600"> <tr> <td align="right" style=" 132px"> </td> <td align="center" style=" 264px"> User</td> <td> </td> </tr> <tr> <td align="right" style=" 132px"> Username</td> <td style=" 264px"> <asp:TextBox ID="TextName" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td> </td> </tr> <tr> <td align="right" style=" 132px"> Password</td> <td style=" 264px"> <asp:TextBox ID="TextPwd" runat="server" BackColor="#FFC0C0" TextMode="Password" Width="149px"></asp:TextBox></td> <td> </td> </tr> <tr> <td align="right" style=" 132px"> </td> <td style=" 264px"> <asp:TextBox ID="TextPwd2" runat="server" BackColor="#FFC0C0" TextMode="Password" Width="149px"></asp:TextBox></td> <td> </td> </tr> <tr> <td align="right" style=" 132px; height: 26px"> Quesqtion</td> <td style=" 264px; height: 26px"> <asp:TextBox ID="TextQues" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td style="height: 26px"> </td> </tr> <tr> <td align="right" style=" 132px; height: 26px"> Answer</td> <td style=" 264px; height: 26px"> <asp:TextBox ID="TextAnswer" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td style="height: 26px"> </td> </tr> <tr> <td align="right" style=" 132px"> Email</td> <td style=" 264px"> <asp:TextBox ID="TextEmail" runat="server" BackColor="#FFC0C0" Width="114px"></asp:TextBox>@<asp:DropDownList ID="DropDownListemail" runat="server" BackColor="#FFC0C0" Width="99px"> <asp:ListItem Value="163.com"></asp:ListItem> <asp:ListItem Value="yahoo.com.cn"></asp:ListItem> </asp:DropDownList></td> <td> </td> </tr> <tr> <td align="right" style=" 132px; height: 13px"> Adress</td> <td style=" 264px; height: 13px"> <asp:TextBox ID="TextAdress" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td style="height: 13px"> </td> </tr> <tr> <td align="right" style=" 132px; height: 8px"> Tel</td> <td style=" 264px; height: 8px"> <asp:TextBox ID="TextTel" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td style="height: 8px"> </td> </tr> <tr> <td align="right" style=" 132px; height: 20px"> Phone</td> <td style=" 264px; height: 20px"> <asp:TextBox ID="TextPhon" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td style="height: 20px"> </td> </tr> <tr> <td align="right" style=" 132px"> Company</td> <td style=" 264px"> <asp:TextBox ID="TextCompany" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td> </td> </tr> <tr> <td align="right" style=" 132px"> Country</td> <td style=" 264px"> <asp:TextBox ID="TextCountry" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td> </td> </tr> <tr> <td align="right" style=" 132px"> </td> <td align="center" style=" 264px"> <asp:Button ID="Button1" runat="server" BackColor="#FFE0C0" OnClick="Button1_Click" Text="OK" Width="51px" /> <input id="Reset1" style="background-color: #ffe0c0" type="reset" value="reset" /></td> <td> </td> </tr> <tr> <td align="center" colspan="3" rowspan="2"> <asp:Label ID="Msg" runat="server"></asp:Label></td> </tr> <tr> </tr> <tr> <td align="right" style=" 132px; height: 21px"> </td> <td style=" 264px; height: 21px"> </td> <td style="height: 21px"> </td> </tr> </table> </div> </form> </body> </html> <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Login.aspx.cs" Inherits="Login" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd ">
<html xmlns="http://www.w3.org/1999/xhtml " > <head runat="server"> <title>无标题页</title> </head> <body> <form id="form1" runat="server"> <div> <table cellpadding="1" cellspacing="1" style=" 523px; height: 199px; background-color: #cc6600"> <tr> <td align="right" style=" 132px"> </td> <td align="center" style=" 264px"> User</td> <td> </td> </tr> <tr> <td align="right" style=" 132px"> Username</td> <td style=" 264px"> <asp:TextBox ID="TextName" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td> </td> </tr> <tr> <td align="right" style=" 132px"> Password</td> <td style=" 264px"> <asp:TextBox ID="TextPwd" runat="server" BackColor="#FFC0C0" TextMode="Password" Width="149px"></asp:TextBox></td> <td> </td> </tr> <tr> <td align="right" style=" 132px"> </td> <td style=" 264px"> <asp:TextBox ID="TextPwd2" runat="server" BackColor="#FFC0C0" TextMode="Password" Width="149px"></asp:TextBox></td> <td> </td> </tr> <tr> <td align="right" style=" 132px; height: 26px"> Quesqtion</td> <td style=" 264px; height: 26px"> <asp:TextBox ID="TextQues" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td style="height: 26px"> </td> </tr> <tr> <td align="right" style=" 132px; height: 26px"> Answer</td> <td style=" 264px; height: 26px"> <asp:TextBox ID="TextAnswer" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td style="height: 26px"> </td> </tr> <tr> <td align="right" style=" 132px"> Email</td> <td style=" 264px"> <asp:TextBox ID="TextEmail" runat="server" BackColor="#FFC0C0" Width="114px"></asp:TextBox>@<asp:DropDownList ID="DropDownListemail" runat="server" BackColor="#FFC0C0" Width="99px"> <asp:ListItem Value="163.com"></asp:ListItem> <asp:ListItem Value="yahoo.com.cn"></asp:ListItem> </asp:DropDownList></td> <td> </td> </tr> <tr> <td align="right" style=" 132px; height: 13px"> Adress</td> <td style=" 264px; height: 13px"> <asp:TextBox ID="TextAdress" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td style="height: 13px"> </td> </tr> <tr> <td align="right" style=" 132px; height: 8px"> Tel</td> <td style=" 264px; height: 8px"> <asp:TextBox ID="TextTel" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td style="height: 8px"> </td> </tr> <tr> <td align="right" style=" 132px; height: 20px"> Phone</td> <td style=" 264px; height: 20px"> <asp:TextBox ID="TextPhon" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td style="height: 20px"> </td> </tr> <tr> <td align="right" style=" 132px"> Company</td> <td style=" 264px"> <asp:TextBox ID="TextCompany" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td> </td> </tr> <tr> <td align="right" style=" 132px"> Country</td> <td style=" 264px"> <asp:TextBox ID="TextCountry" runat="server" BackColor="#FFC0C0"></asp:TextBox></td> <td> </td> </tr> <tr> <td align="right" style=" 132px"> </td> <td align="center" style=" 264px"> <asp:Button ID="Button1" runat="server" BackColor="#FFE0C0" OnClick="Button1_Click" Text="OK" Width="51px" /> <input id="Reset1" style="background-color: #ffe0c0" type="reset" value="reset" /></td> <td> </td> </tr> <tr> <td align="center" colspan="3" rowspan="2"> <asp:Label ID="Msg" runat="server"></asp:Label></td> </tr> <tr> </tr> <tr> <td align="right" style=" 132px; height: 21px"> </td> <td style=" 264px; height: 21px"> </td> <td style="height: 21px"> </td> </tr> </table> </div> </form> </body> </html>