register.aspx

来自「asp.net技术内幕的书配源码」· ASPX 代码 · 共 80 行

ASPX
80
字号
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<script language="C#" runat=server>
void Button_Click( object s, EventArgs e ) {
	SqlConnection conMyData;
	SqlCommand cmdSelect;
	SqlParameter parmReturnValue;
	int intResult;

	if ( IsValid )
	{
		conMyData = new SqlConnection( "Server=localhost;Integrated Security=SSPI;Database=myData" );
		cmdSelect = new SqlCommand( "DBRegister", conMyData );
		cmdSelect.CommandType = CommandType.StoredProcedure;
		parmReturnValue = cmdSelect.Parameters.Add( "RETURN_VALUE", SqlDbType.Int );
		parmReturnValue.Direction = ParameterDirection.ReturnValue;
		cmdSelect.Parameters.Add( "@username", txtUsername.Text );
		cmdSelect.Parameters.Add( "@password", txtPassword.Text );
		conMyData.Open();
		cmdSelect.ExecuteNonQuery();
		intResult = System.Convert.ToInt32(cmdSelect.Parameters[ "RETURN_VALUE" ].Value);
		conMyData.Close();
		if ( intResult == - 1 )
		{
		lblMessage.Text = "Username Already Registered!";
		} 
		else
		{
		FormsAuthentication.RedirectFromLoginPage( txtUsername.Text, false );
		}
	}
}

</Script>

<html>
<head><title>Register.aspx</title></head>
<body>
<form Runat="Server">

<h2>Please Register</h2>

<asp:Label
  ID="lblMessage"
  ForeColor="Red"
  Font-Bold="True"
  EnableViewState="False"
  Runat="Server" />
<p>
<b>Username:</b>
<br>
<asp:TextBox
  ID="txtUsername"
  Runat="Server" />
<asp:RequiredFieldValidator
  ControlToValidate="txtUsername"
  Text="Required!"
  Runat="Server" />
<p>
<b>Password:</b>
<br>
<asp:TextBox
  ID="txtPassword"
  Runat="Server" />
<asp:RequiredFieldValidator
  ControlToValidate="txtPassword"
  Text="Required!"
  Runat="Server" />
<p>
<asp:Button
  Text="Register!"
  OnClick="Button_Click"
  Runat="Server" />

</form>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?