ASP.NET数据库添加记录练习

最新推荐文章于 2024-02-28 16:26:49 发布

原创最新推荐文章于 2024-02-28 16:26:49 发布 · 5.6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#asp.net #数据库 #string #asp #textbox #server

ASP.NET 专栏收录该内容

12 篇文章

订阅专栏

本文介绍了一个使用 ASP.NET 的 Web 应用程序如何通过三种不同的方法实现用户注册功能：拼接 SQL 语句、使用参数化查询及调用存储过程。文章详细展示了每种方法的具体实现步骤，并提供了完整的 C# 代码示例。

update.aspx

<%@ Page language="C#" Codebehind="update.aspx.cs" AutoEventWireup="false" Inherits="DotNetTest.database.update" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

<HEAD>

<title>update</title>

</HEAD>

<body>

------------帐号注册------------

必填:

帐号:

<asp:TextBox id="TB_Account" runat="server"></asp:TextBox>

<asp:Label id="Lbl_Msg" style="Z-INDEX: 101; LEFT: 305px; POSITION: absolute; TOP: 94px" runat="server" Width="177px" Height="59px" BackColor="White" ForeColor="Red"></asp:Label>

密码:

<asp:TextBox id="TB_Password1" runat="server"></asp:TextBox>

确认密码:

<asp:TextBox id="TB_Password2" runat="server"></asp:TextBox>

---------

<asp:Button id="B_OKGOPinjie" runat="server" Text="OK,GO拼接字符串" Width="160px"></asp:Button>

<asp:LinkButton id="LB_SeeResult" style="Z-INDEX: 102; LEFT: 312px; POSITION: absolute; TOP: 203px" runat="server" Width="116px" Height="23px" Visible="False">查看数据库内容</asp:LinkButton>

---------

<asp:Button id="B_OKGOParm" runat="server" Text="OK,GO使用参数" Width="161px"></asp:Button>

---------

<asp:Button id="B_OKGOStore" runat="server" Text="OK,GO使用存储过程" Width="161px"></asp:Button>

选填:

昵称:

<asp:TextBox id="TB_VirtualName" runat="server"></asp:TextBox>

性别:

<asp:RadioButtonList id="RBL_Sex" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow">

<asp:ListItem Value="M" Selected="True">男</asp:ListItem>

<asp:ListItem Value="F">女</asp:ListItem>

</asp:RadioButtonList>

</form>

</body>

</HTML>

update.aspx.cs

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

using System.Configuration;

namespace DotNetTest.database

{

/// <summary>

/// update 的摘要说明。

/// </summary>

public class update : System.Web.UI.Page

{

protected System.Web.UI.WebControls.TextBox TB_Account;

protected System.Web.UI.WebControls.TextBox TB_Password1;

protected System.Web.UI.WebControls.TextBox TB_Password2;

protected System.Web.UI.WebControls.TextBox TB_VirtualName;

protected System.Web.UI.WebControls.Button B_OKGOPinjie;

protected System.Web.UI.WebControls.Button B_OKGOParm;

protected System.Web.UI.WebControls.Button B_OKGOStore;

protected System.Web.UI.WebControls.Label Lbl_Msg;

protected System.Web.UI.WebControls.LinkButton LB_SeeResult;

protected System.Web.UI.WebControls.RadioButtonList RBL_Sex;

private bool CheckInfo()

{

if(this.TB_Account.Text.Trim()=="")

{

Alert("学号不完整");

return false;

}

else if(this.TB_Password1.Text.Trim()==""||this.TB_Password2.Text.Trim()=="")

{

Alert("密码不完整");

return false;

}

else if(this.TB_Password1.Text.Trim()!=this.TB_Password2.Text.Trim())

{

Alert("密码确认失败!");

return false;

}

return true;

}

private void Alert(string str)

{

Lbl_Msg.Text=str;

Lbl_Msg.BackColor=System.Drawing.Color.DimGray;

LB_SeeResult.Visible=true;

}

private bool IsOKAccount()

{

string usrAccount=this.TB_Account.Text.Trim();

try

{

//config the database

string strConn=ConfigurationSettings.AppSettings["MSSQLConnStr_FSLink"];

SqlConnection sqlConn=new SqlConnection();

sqlConn.ConnectionString=strConn;

//the SQL string

string sqlCount="SELECT COUNT(*) FROM FSL_USER WHERE USER_ID=@userID";

//create the command

SqlCommand cmd=new SqlCommand(sqlCount,sqlConn);

//add parameters

cmd.Parameters.Add(new SqlParameter("@userID",usrAccount));

//open the database

sqlConn.Open();

//save the affected result

string aff=cmd.ExecuteScalar().ToString();

//close the database

sqlConn.Close();

if(Int32.Parse(aff)!=0)

{

Alert("帐号已经存在");

return false;

}

return true;

}

catch(Exception ex)

{

Alert(ex.Message);

return false;

}

private void Page_Load(object sender, System.EventArgs e)

{

// 在此处放置用户代码以初始化页面

}

Web Form Designer generated code

private void B_OKGOPinjie_Click(object sender, System.EventArgs e)

{

if(!IsOKAccount())

{

return;

}

if(this.CheckInfo())

{

//get the acquired value

string usrAccount=this.TB_Account.Text.Trim();

string usrPassword=this.TB_Password1.Text.Trim();

string usrVirtualName=this.TB_VirtualName.Text.Trim();

string usrSex=this.RBL_Sex.SelectedItem.Value.Trim();

//operate the database

try

{

//config the database

string strConn=ConfigurationSettings.AppSettings["MSSQLConnStr_FSLink"];

SqlConnection sqlConn=new SqlConnection();

sqlConn.ConnectionString=strConn;

//the SQL string

string sqlInsert="INSERT INTO FSL_USER(USER_ID,USER_NAME,USER_SEX,USER_PASSWORD)"+

" VALUES('"+usrAccount+"','"+usrVirtualName+"','"+usrSex+"','"+usrPassword+"')";

//create the command

SqlCommand cmd=new SqlCommand(sqlInsert,sqlConn);

//open the database

sqlConn.Open();

//save the affected result

int aff=cmd.ExecuteNonQuery();

//close the reader and the database

sqlConn.Close();

Alert("使用拼接字符串:数据添加成功"+aff+"条!");

}

catch(Exception ex)

{

Alert(ex.Message);

}

private void B_OKGOParm_Click(object sender, System.EventArgs e)

{

if(this.CheckInfo())

{

if(!IsOKAccount())

{

return;

}

//get the acquired value

string usrAccount=this.TB_Account.Text.Trim();

string usrPassword=this.TB_Password1.Text.Trim();

string usrVirtualName=this.TB_VirtualName.Text.Trim();

string usrSex=this.RBL_Sex.SelectedItem.Value.Trim();

//operate the database

try

{

//config the database

string strConn=ConfigurationSettings.AppSettings["MSSQLConnStr_FSLink"];

SqlConnection sqlConn=new SqlConnection();

sqlConn.ConnectionString=strConn;

//the SQL string

string sqlInsert="INSERT INTO FSL_USER(USER_ID,USER_NAME,USER_SEX,USER_PASSWORD)"+

" VALUES(@userID,@userName,@userSex,@userPassword)";

//create the command

SqlCommand cmd=new SqlCommand(sqlInsert,sqlConn);

//add parameters

cmd.Parameters.Add(new SqlParameter("@userID",usrAccount));

cmd.Parameters.Add(new SqlParameter("@userName",usrVirtualName));

cmd.Parameters.Add(new SqlParameter("@userSex",usrSex));

cmd.Parameters.Add(new SqlParameter("@userPassword",usrPassword));

//open the database

sqlConn.Open();

//save the affected result

int aff=cmd.ExecuteNonQuery();

//close the reader and the database

sqlConn.Close();

Alert("使用参数:数据添加成功"+aff+"条!");

}

catch(Exception ex)

{

Alert(ex.Message);

}

private void B_OKGOStore_Click(object sender, System.EventArgs e)

{

if(!IsOKAccount())

{

return;

}

if(this.CheckInfo())

{

//get the acquired value

string usrAccount=this.TB_Account.Text.Trim();

string usrPassword=this.TB_Password1.Text.Trim();

string usrVirtualName=this.TB_VirtualName.Text.Trim();

string usrSex=this.RBL_Sex.SelectedItem.Value.Trim();

//operate the database

try

{

//config the database

string strConn=ConfigurationSettings.AppSettings["MSSQLConnStr_FSLink"];

SqlConnection sqlConn=new SqlConnection();

sqlConn.ConnectionString=strConn;

//create the command

SqlCommand cmd=new SqlCommand("InsertUser",sqlConn);

cmd.CommandType=CommandType.StoredProcedure;

//add parameters

cmd.Parameters.Add(new SqlParameter("@userID",usrAccount));

cmd.Parameters.Add(new SqlParameter("@userName",usrVirtualName));

cmd.Parameters.Add(new SqlParameter("@userSex",usrSex));

cmd.Parameters.Add(new SqlParameter("@userPassword",usrPassword));

//open the database

sqlConn.Open();

//save the affected result

int aff=cmd.ExecuteNonQuery();

//close the reader and the database

sqlConn.Close();

Alert("使用存储过程:数据添加成功"+aff+"条!");

}

catch(Exception ex)

{

Alert(ex.Message);

}

private void LB_SeeResult_Click(object sender, System.EventArgs e)

{

Server.Transfer("select_adapter.aspx");

}