Asp.net实现简易的注册系统

最新推荐文章于 2021-11-27 23:34:59 发布

原创最新推荐文章于 2021-11-27 23:34:59 发布 · 1.6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#asp.net #textbox #exception #asp #button #email

ASP.NET 专栏收录该内容

212 篇文章

订阅专栏

本文介绍了一个基于ASP.NET和OleDbParameter参数传递的简单注册系统的实现方法。该系统通过网页收集用户输入的用户名、密码及电子邮件地址，并将这些信息存入Access数据库。

本实例使用OleDbParameter参数传递完成数据库写入功能

.aspx代码

<form id="Form1" method="post" runat="server">
<asp:Label id="Label1" style="Z-INDEX: 101; LEFT: 256px; POSITION:

absolute; TOP: 32px" runat="server">Asp.net实现简易的注册系统</asp:Label>
<TABLE id="Table1" style="Z-INDEX: 102; LEFT: 176px; POSITION:

absolute; TOP: 64px" cellSpacing="1"
    cellPadding="1" width="300" border="1">
    <TR>
     <TD><FONT face="宋体">用户名：</FONT></TD>
     <TD><FONT face="宋体">
       <asp:TextBox id="TextBox1"

runat="server"></asp:TextBox></FONT></TD>
    </TR>
    <TR>
     <TD><FONT face="宋体">密  码：</FONT></TD>
     <TD>
      <asp:TextBox id="TextBox2"

runat="server"></asp:TextBox></TD>
    </TR>
    <TR>
     <TD><FONT face="宋体">E-mail:</FONT></TD>
     <TD>
      <asp:TextBox id="TextBox3"

runat="server"></asp:TextBox></TD>
    </TR>
    <TR>
     <TD></TD>
     <TD>
      <asp:Button id="Button1" runat="server"

Text="注册"></asp:Button></TD>
    </TR>
    <TR>
     <TD></TD>
     <TD></TD>
    </TR>
    <TR>
     <TD></TD>
     <TD></TD>
    </TR>
   </TABLE>
  </form>

.aspx.cs代码

using System.Data.OleDb;

private void Button1_Click(object sender, System.EventArgs e)
  {//注册
   if(Page.IsValid){
    OleDbConnection conn=new OleDbConnection

("provider=microsoft.jet.oledb.4.0;data source="+Server.MapPath("Data1.mdb"));
    try
    {
     conn.Open();
    }
    catch(Exception ex){
     Response.Write(ex.ToString());
     Response.End();
    }
    OleDbCommand cmd=new OleDbCommand();
    cmd.CommandType=CommandType.Text;
    cmd.CommandText="insert into DataShow(name,pass,email)

values(@name,@pass,@email)";
cmd.Connection=conn;
OleDbParameter para1=new OleDbParameter

("@name",OleDbType.VarChar,20);
    para1.Direction=ParameterDirection.Input;
    para1.Value=TextBox1.Text;
    cmd.Parameters.Add(para1);
    OleDbParameter para2=new OleDbParameter

("@pass",OleDbType.VarChar,20);
    para2.Direction=ParameterDirection.Input;
    para2.Value=TextBox2.Text;
    cmd.Parameters.Add(para2);
    OleDbParameter para3=new OleDbParameter

("@email",OleDbType.VarChar,20);
    para3.Direction=ParameterDirection.Input;
    para3.Value=TextBox2.Text;
    cmd.Parameters.Add(para3);
    try
    {
     Response.Write("<script>alert('注册成

功');</script>");
     cmd.ExecuteNonQuery();
    }
    catch(Exception ex){
     Response.Write(ex.ToString());
     Response.End();
    }
    finally{
     cmd.Dispose();
     conn.Dispose();
    }
   }