ASP.NET RSS ASP.NET RSS

ASP.NET Registration Page

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Thread Solved

•
•
Join Date: Feb 2003
Posts: 793
Reputation: Paladine has a spectacular aura about Paladine has a spectacular aura about Paladine has a spectacular aura about 
Solved Threads: 27
Team Colleague
Paladine's Avatar
Paladine Paladine is offline Offline
Master Poster

ASP.NET Registration Page

 
0
  #1
May 15th, 2005
This is a continuation of the Updated: ASP.NET Login Page Tutorial.

This tutorial will demonstrate how to create a registration page for new users to your site. This registration page will utilize the same principles used in the Login Page Tutorial, so this should be no more difficult to do than the login page. I am using the SQL Server 2000, and programmed this part of the application in Visual Studio .NET 2003. I choose VB because it is more natural language to me, but there is no reason you can't use the same concepts I use here to code this in any other language in the .NET framework.

1. Create the basic HTML layout for the registration page. REGISTER.ASPX
- This page will require all entries to be filled in for a successful registration
- UserName, Password, FirstName and LastName
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="Register.aspx.vb" Inherits="NorthLogin3.Register"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
	<head>
	    <title>Register</title>
		<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
		<meta name="CODE_LANGUAGE" content="Visual Basic .NET 7.1">
		<meta name="vs_defaultClientScript" content="JavaScript">
		<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
	</head>
	<body ms_positioning="GridLayout">
	    <h1>Welcome to the Norwthwind DB Registration Page</h1>
		<form id="frmRegister" method="post" runat="server">
		    <table id="tblRegister" border="1" cellpadding="2" cellspacing="1">
		        <tr>
		    		<td style="WIDTH: 108px">User Name:</td>
		    	    <td><asp:textbox id="txtUserName" runat="server"></asp:textbox><font color="#ff3300" size="4"><strong>*</strong></font></td>
		    	    <td><asp:requiredfieldvalidator id="rvUserName" runat="server" errormessage="<-- Required" controltovalidate="txtUserName"></asp:requiredfieldvalidator></td>
		        </tr>
		        <tr>
		    		<td style="WIDTH: 108px; HEIGHT: 23px">Password:</td>
		    		<td style="HEIGHT: 23px"><asp:textbox id="txtPassword" runat="server" textmode="Password"></asp:textbox><font color="#ff3300" size="4"><strong>*</strong></font></td>
		    	    <td><asp:requiredfieldvalidator id="rvPassword" runat="server" errormessage="<-- Required" controltovalidate="txtPassword"></asp:requiredfieldvalidator></td>
		        </tr>
		        <tr>
		    		<td style="WIDTH: 108px">First Name:</td>
		    	    <td><asp:textbox id="txtFirst" runat="server"></asp:textbox><font color="#ff3300" size="4"><strong>*</strong></font></td>
		    	    <td><asp:requiredfieldvalidator id="rvFirstName" runat="server" errormessage="<-- Required" controltovalidate="txtFirst"></asp:requiredfieldvalidator></td>
		        </tr>
		        <tr>
		    		<td style="WIDTH: 108px">Last Name:</td>
		    	    <td><asp:textbox id="txtLast" runat="server"></asp:textbox><font color="#ff3300" size="4"><strong>*</strong></font></td>
		    	    <td><asp:requiredfieldvalidator id="rvLastName" runat="server" errormessage="<-- Required" controltovalidate="txtLast"></asp:requiredfieldvalidator></td>
		        </tr>
		        <tr>
		    		<td colspan="2" align="center"><asp:button id="cmdSubmit" text="Submit" runat="server"></asp:button>
		    	    </td>
		        </tr>
			</table>
		</form>
	    <p><font color="#ff3300" size="4">*</font> Required Field
		    <asp:label id="lblError" style="Z-INDEX: 101; LEFT: 656px; POSITION: absolute; TOP: 264px"
		        runat="server" width="216px"></asp:label></p>
	    <p>&nbsp;</p>
	    <p>&nbsp;</p>
	    <asp:label id="lblResult" runat="server" width="424px"></asp:label>
	</body>
</html>

2. Create the Store Procedures you will need to add a new user
- You will need to handle duplicates
- You will need to handle the adding of a new user.

a. Check for Duplicates. SP_CHECKFORDUPLICATES 
CREATE PROCEDURE sp_CheckForDuplicates
(
	@UserName VARCHAR(50) = NULL,
	@FirstName VARCHAR(50) = NULL,
	@LastName VARCHAR(50) = NULL,
	@Duplicates INT = 0
)
AS
	SET @Duplicates =(SELECT COUNT(*) FROM NorthWindUsers
			WHERE UserName = @UserName
		    OR FirstName = @FirstName AND LastName = @LastName)
RETURN @Duplicates

b. Add New User. SP_REGISTERNEWUSER
CREATE PROCEDURE sp_RegisterNewUser
(
	@UserName VARCHAR(50) = NULL,
	@Password VARCHAR(50) = NULL,
	@FirstName VARCHAR(50) = NULL,
	@LastName VARCHAR(50) = NULL
)
AS
IF @UserName IS NULL OR 
   @Password IS NULL OR 
   @FirstName IS NULL OR 
   @LastName IS NULL
	RAISERROR('Please fill in all fields', 16, 1)
ELSE
BEGIN
	INSERT INTO NorthWindUsers
	(UserName, Password, FirstName, LastName)
	VALUES (@UserName, @Password, @FirstName, @LastName)
	IF @@error <> 0
		RAISERROR('User was not added', 16, 1)
	ELSE
	BEGIN
		DECLARE @ID int
		SELECT @ID = @@IDENTITY
		SELECT Count(*)
		FROM NorthWindUsers
		WHERE UserID = @ID
	END
END
RETURN


4. Create the code behind to provide functionality to your registration page. REGISTER.ASPX.VB
- This code behind will do several things; Validate the entries for completeness, duplication, and add the new user.
- I test for duplicates in UserName, as well as First & Last Name.

Imports System.Web.Security	 '   ||||||   Required Class for Authentication
Imports System.Data			 '   ||||||   DB Accessing Import
Imports System.Data.SqlClient   '   ||||||   SQL Server Import
Imports System.Configuration    '   ||||||   Required for Web.Config appSettings |||||
Public Class Register
	Inherits System.Web.UI.Page
...
...

Imports System.Web.Security	 '   ||||||   Required Class for Authentication
	Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
		'Put user code to initialize the page here
	End Sub

	Private Sub cmdSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSubmit.Click
		If Page.IsValid Then    '   ||||| Meaning the Control Validation was successful!
		    '	|||||   All fields have been filled in!
		    If ValidateNewUser(txtUserName.Text.Trim(), txtFirst.Text.Trim(), txtLast.Text.Trim()) Then
			    AddNewUser(txtUserName.Text.Trim(), txtFirst.Text.Trim(), txtLast.Text.Trim(), txtPassword.Text.Trim())
				Response.Redirect("login.aspx")
			End If
		End If


	End Sub

	Function ValidateNewUser(ByVal strAlias As String, ByVal strFirst As String, ByVal strLast As String) As Boolean
		'   <summary>
	    '	   |||||   This function simply verifies that there is no existing match on
	    '	   |||||   username (alias), and that the user has not already registered!
		'   </sumary>

		'   |||||   Set up a Connection Object to the SQL DB
		Dim MyConn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("strConn"))
		'   |||||   Pass in the StoreProcedure or Command String, as well as the Connection object
		Dim MyCmd As New SqlCommand("sp_CheckForDuplicates", MyConn)
		'   |||||   Set the Command Type (Stored Procedure, Text, etc)
		MyCmd.CommandType = CommandType.StoredProcedure
		'   |||||   Create Parameter Objects for values passed in
		Dim objParam1, objParam2, objParam3 As SqlParameter
		'   |||||   Create a parameter to store your Return Value from the Stored Procedure
		Dim objReturnParam As SqlParameter
		'   |||||   Add your parameters to the parameters Collection
		objParam1 = MyCmd.Parameters.Add("@UserName", SqlDbType.VarChar)
		objParam2 = MyCmd.Parameters.Add("@FirstName", SqlDbType.VarChar)
		objParam3 = MyCmd.Parameters.Add("@LastName", SqlDbType.VarChar)
		objReturnParam = MyCmd.Parameters.Add("@Duplicates", SqlDbType.Int)
		objReturnParam.Direction = ParameterDirection.ReturnValue
		'   |||||   Set the Parameter values to the passed in values
		objParam1.Value = strAlias
		objParam2.Value = strFirst
		objParam3.Value = strLast

		Try
		    '   |||||   Check if Connection to DB is already open, if not, then open a connection
		    If MyConn.State = ConnectionState.Closed Then
			    '   |||||   DB not already Open...so open it
				MyConn.Open()
				MyCmd.ExecuteNonQuery()
			End If
		    '   |||||   Was the return value greater than 0 ???
		    If objReturnParam.Value > 0 Then
			    lblResult.Text = "UserName already exists or you are already a registered user!"
				Return False
			Else
				Return True
			End If

		    '   |||||   Close the Connection Closes with it
			MyConn.Close()


		Catch ex As Exception
			lblError.Text = "Error Connecting to Database!"
		End Try

	End Function

	Sub AddNewUser(ByVal strUser As String, ByVal strFirst As String, ByVal strLast As String, ByVal strPass As String)

		'   |||||   Set up a Connection Object to the SQL DB
		Dim MyConn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("strConn"))
		'   |||||   Pass in the StoreProcedure or Command String, as well as the Connection object
		Dim MyCmd As New SqlCommand("sp_RegisterNewUser", MyConn)
		'   |||||   Set the Command Type (Stored Procedure, Text, etc)
		MyCmd.CommandType = CommandType.StoredProcedure
		'   |||||   Create Parameter Objects for values passed in
		Dim objParam1, objParam2, objParam3, objParam4 As SqlParameter
		'   |||||   Create a parameter to store your Return Value from the Stored Procedure
		Dim objReturnParam As SqlParameter
		'   |||||   Add your parameters to the parameters Collection
		objParam1 = MyCmd.Parameters.Add("@UserName", SqlDbType.VarChar)
		objParam2 = MyCmd.Parameters.Add("@FirstName", SqlDbType.VarChar)
		objParam3 = MyCmd.Parameters.Add("@LastName", SqlDbType.VarChar)
		objParam4 = MyCmd.Parameters.Add("@Password", SqlDbType.VarChar)
		'   |||||   Set the Parameter values to the passed in values
		objParam1.Value = strUser
		objParam2.Value = strFirst
		objParam3.Value = strLast
		objParam4.Value = strPass

		Try
		    '   |||||   Check if Connection to DB is already open, if not, then open a connection
		    '   |||||   DB not already Open...so open it
			MyConn.Open()
			MyCmd.ExecuteNonQuery()

		    '   |||||   Close the Connection Closes with it
			MyConn.Close()


		Catch ex As Exception
			lblError.Text = "Error Connecting to Database!"
		End Try


	End Sub
End Class

5. Final thing to do: Link the Registration Page to the Login Page
- I used a Hyperlink on the login page to do this, but you could use anything. It is just a simple <a href="Register.aspx" ...> line of code to use for this. On that note I also send the user right back to the login page on successful registration. This is not the ideal thing to do. It would be better to direct them to a page that said "You are now registered! Would you like to return to the login page?" and a means of allowing them to return to the login page. But you specific use of this may be different, so the choice is yours.

6. Compile and run.....

Happy coding
Assistant Manager, Pharmacy Informatics
Wordpress Learning Blog
Updated : ASP.Net Login Code
Reply With Quote Quick reply to this message  
•
•
Join Date: Apr 2005
Posts: 18
Reputation: millers_35 is an unknown quantity at this point 
Solved Threads: 2
millers_35 millers_35 is offline Offline
Newbie Poster

Re: ASP.NET Registration Page

 
0
  #2
May 16th, 2005
Nice this is good stuff Paladine.

Miller
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2005
Posts: 2
Reputation: Farlie_76 is an unknown quantity at this point 
Solved Threads: 1
Farlie_76's Avatar
Farlie_76 Farlie_76 is offline Offline
Newbie Poster

Re: ASP.NET Registration Page

 
0
  #3
Jul 22nd, 2005
Hi

I have tried to add more fields ie: Address, Phone, Email etc everything compiles ok but when running the app it comes up with the database error (lblError)

I have updated the Stored procedure and the database with the correct fields so i think i know it is not that.

any way here is codebehind: 

Imports System.Web.Security ' |||| Required Class for Authentication
Imports System.Data ' |||| DB Accessing Import
Imports System.Data.SqlClient ' |||| SQL Server Import
Imports System.Configuration ' |||| Web.Config appsettings
Public Class register
	Inherits System.Web.UI.Page

#Region " Web Form Designer Generated Code "

	'This call is required by the Web Form Designer.
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

	End Sub
	Protected WithEvents txtUserName As System.Web.UI.WebControls.TextBox
	Protected WithEvents rvUserName As System.Web.UI.WebControls.RequiredFieldValidator
	Protected WithEvents txtPassword As System.Web.UI.WebControls.TextBox
	Protected WithEvents rvPassword As System.Web.UI.WebControls.RequiredFieldValidator
	Protected WithEvents txtFirst As System.Web.UI.WebControls.TextBox
	Protected WithEvents rvFirstName As System.Web.UI.WebControls.RequiredFieldValidator
	Protected WithEvents txtLast As System.Web.UI.WebControls.TextBox
	Protected WithEvents rvLastName As System.Web.UI.WebControls.RequiredFieldValidator
	Protected WithEvents cmdSubmit As System.Web.UI.WebControls.Button
	Protected WithEvents lblError As System.Web.UI.WebControls.Label
	Protected WithEvents lblResult As System.Web.UI.WebControls.Label
	Protected WithEvents txtCompany As System.Web.UI.WebControls.TextBox
	Protected WithEvents rvCompany As System.Web.UI.WebControls.RequiredFieldValidator
	Protected WithEvents txtAddress As System.Web.UI.WebControls.TextBox
	Protected WithEvents rvAddress As System.Web.UI.WebControls.RequiredFieldValidator
	Protected WithEvents txtCity As System.Web.UI.WebControls.TextBox
	Protected WithEvents rvCity As System.Web.UI.WebControls.RequiredFieldValidator
	Protected WithEvents txtPostCode As System.Web.UI.WebControls.TextBox
	Protected WithEvents rvPostCode As System.Web.UI.WebControls.RequiredFieldValidator
	Protected WithEvents txtEmail As System.Web.UI.WebControls.TextBox
	Protected WithEvents rvEmail As System.Web.UI.WebControls.RequiredFieldValidator
	Protected WithEvents txtPhone As System.Web.UI.WebControls.TextBox
	Protected WithEvents rvPhone As System.Web.UI.WebControls.RequiredFieldValidator
	Protected WithEvents txtFax As System.Web.UI.WebControls.TextBox

	'NOTE: The following placeholder declaration is required by the Web Form Designer.
	'Do not delete or move it.
	Private designerPlaceholderDeclaration As System.Object

	Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
		'CODEGEN: This method call is required by the Web Form Designer
		'Do not modify it using the code editor.
		InitializeComponent()
	End Sub

#End Region

	Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
		' |||| Put user code to initialize the page here
	End Sub

	Private Sub cmdSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSubmit.Click
		If Page.IsValid Then ' |||| Meaning the Control Validation was successful!
			' |||| All Fileds have been filled in!
		    If ValidateNewUser(txtUserName.Text.Trim(), txtFirst.Text.Trim(), txtLast.Text.Trim()) Then
			    AddNewUser(txtUserName.Text.Trim(), txtFirst.Text.Trim(), txtLast.Text.Trim(), txtPassword.Text.Trim())
				Response.Redirect("login2.aspx")
			End If
		End If
	End Sub

	Function ValidateNewUser(ByVal strAlias As String, ByVal strFirst As String, ByVal strLast As String) As Boolean
		' |||| This function simply varifies that there is no existing match on
		' |||| username (alias), and that the user has not already registered!
		' |||| |||| |||| |||| |||| |||| |||| |||| |||| ||||
		' |||| Set up a connection object to the SQL DB
		Dim MyConn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("strConn"))
		' |||| Pass in the StoredProcedure or Command String, as well as the Connection object
		Dim MyCmd As New SqlCommand("sp_CheckForDuplicates", MyConn)
		' |||| Set the command type (stored procedure, text, etc)
		MyCmd.CommandType = CommandType.StoredProcedure
		' |||| Create Parameter Objects for values passed in
		Dim objParam1, objParam2, objParam3, objParam5 As SqlParameter
		' |||| Create a parameter to store your Return value from the stored procedure
		Dim objReturnParam As SqlParameter
		' |||| Add your parameters to the parameters Collection
		objParam1 = MyCmd.Parameters.Add("@UserName", SqlDbType.VarChar)
		objParam2 = MyCmd.Parameters.Add("@FirstName", SqlDbType.VarChar)
		objParam3 = MyCmd.Parameters.Add("@LastName", SqlDbType.VarChar)
		objReturnParam = MyCmd.Parameters.Add("@Duplicates", SqlDbType.Int)
		objReturnParam.Direction = ParameterDirection.ReturnValue
		' |||| Set the Parameter values to the passed in values
		objParam1.Value = strAlias
		objParam2.Value = strFirst
		objParam3.Value = strLast


		Try
		    ' |||| Check if Connection to the DB is already open , if not, then open a connection
		    If MyConn.State = ConnectionState.Closed Then
			    ' |||| DB not already open... so open it
				MyConn.Open()
				MyCmd.ExecuteNonQuery()
			End If
		    ' |||| Was the return value greater that 0?
		    If objReturnParam.Value > 0 Then
			    lblResult.Text = "UserName already exists or you are already a registered user!"
				Return False
			Else
				Return True
			End If
		    ' |||| Close the connection Closes with it
			MyConn.Close()

		Catch ex As Exception
			lblError.Text = "Error Connecting to DataBase!"
		End Try

	End Function

	Sub AddNewUser(ByVal strUser As String, ByVal strFirst As String, ByVal strLast As String, ByVal strPass As String)
		' |||| Set up new Connection To the SQL DB
		Dim MyConn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("strConn"))
		' |||| Pass in the StoredProcedure or Command String, as well as the Connection object
		Dim MyCmd As New SqlCommand("sp_RegisterNewUser", MyConn)
		' |||| Set the command type (Stored Procedure, Test, etc)
		MyCmd.CommandType = CommandType.StoredProcedure
		' |||| Create Parameter objects for values passed in
		Dim objParam1, objParam2, objPAram3, objParam4, objParam5, objParam6, objParam7, objParam8, objParam9, objParam10, objParam11 As SqlParameter
		' |||| Creat an Parameter to store your return Value from the Stored Procedure
		Dim objReturnParam As SqlParameter
		' |||| Add your parameters to the parameters Collection
		objParam1 = MyCmd.Parameters.Add("@UserName", SqlDbType.VarChar)
		objParam2 = MyCmd.Parameters.Add("@FirstName", SqlDbType.VarChar)
		objPAram3 = MyCmd.Parameters.Add("@LastName", SqlDbType.VarChar)
		objParam4 = MyCmd.Parameters.Add("@Password", SqlDbType.VarChar)
		objParam5 = MyCmd.Parameters.Add("@Company", SqlDbType.VarChar)
		objParam6 = MyCmd.Parameters.Add("@Address", SqlDbType.VarChar)
		objParam7 = MyCmd.Parameters.Add("@City", SqlDbType.VarChar)
		objParam8 = MyCmd.Parameters.Add("@PostCode", SqlDbType.VarChar)
		objParam9 = MyCmd.Parameters.Add("@Email", SqlDbType.VarChar)
		objPAram10 = MyCmd.Parameters.Add("@Phone", SqlDbType.VarChar)
		objParam11 = MyCmd.Parameters.Add("@Fax", SqlDbType.VarChar)
		' |||| Set the Parameter values to the passed in values
		objParam1.Value = strUser
		objParam2.Value = strFirst
		objPAram3.Value = strLast
		objParam4.Value = strPass

		Try
		    ' |||| Check if connection is already open
			MyConn.Open()
			MyCmd.ExecuteNonQuery()
			MyConn.Close()
		Catch ex As Exception
			lblError.Text = "Error Connecting to DataBase!"
		End Try
	End Sub
End Class
Last edited by Paladine; Jul 22nd, 2005 at 12:06 pm. Reason: Adding code blocks
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2003
Posts: 793
Reputation: Paladine has a spectacular aura about Paladine has a spectacular aura about Paladine has a spectacular aura about 
Solved Threads: 27
Team Colleague
Paladine's Avatar
Paladine Paladine is offline Offline
Master Poster

Re: ASP.NET Registration Page

 
0
  #4
Jul 22nd, 2005
OK, couple of things.

1. Please use code blocks "[code"]["/code]" for displaying your code.
2. Please provide the error message you are getting
3. You have the "strConn" variable listed in the web.config file correct?
4. Are you able to login in?
5. Please provide the code for the stored procedure.
6. Looking are your code, if you have added the extra variables to stored procedure, then why are you not passing them in to it? You show that you are adding 11 parameters to the collection, but onlying passing in 4 ? Although that is unlikely to cause an error unless they are "required fields".

Assistant Manager, Pharmacy Informatics
Wordpress Learning Blog
Updated : ASP.Net Login Code
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2005
Posts: 2
Reputation: Farlie_76 is an unknown quantity at this point 
Solved Threads: 1
Farlie_76's Avatar
Farlie_76 Farlie_76 is offline Offline
Newbie Poster

Re: ASP.NET Registration Page

 
0
  #5
Jul 22nd, 2005
•
•
•
•
Originally Posted by Paladine
OK, couple of things.

1. Please use code blocks "[code"]["/code]" for displaying your code.
2. Please provide the error message you are getting
3. You have the "strConn" variable listed in the web.config file correct?
4. Are you able to login in?
5. Please provide the code for the stored procedure.
6. Looking are your code, if you have added the extra variables to stored procedure, then why are you not passing them in to it? You show that you are adding 11 parameters to the collection, but onlying passing in 4 ? Although that is unlikely to cause an error unless they are "required fields".


Hi Thanks for getting back to me.

Ok answer to question 2 is "Error Connecting to DataBase!" and also asks for a *Required field at the bottom as well, this was supplied!
i am not getting a specific .net output error just a page error lblError.text message response.

Q3, strConn is listed in the web.config file.

Q4, I am able to log in ok

Q5, here is the stored procedure:

Q6, I see what you are saying and tried to add them but VS said that it wasn't declared so i tried to add it, which would of been on lines 76, 83 and 90 for example but it still wanted to be declared!


do i need to add the fields into this section ? ( as in txtAddress.text.trim()... ) etc etc.
ASP.NET Syntax (Toggle Plain Text) 
  1. Private Sub cmdSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSubmit.Click
  2.         If Page.IsValid Then        '   ||||    Meaning the Control Validation was successful!
  3.             '   ||||    All Fileds have been filled in!
  4.             If ValidateNewUser(txtUserName.Text.Trim(), txtFirst.Text.Trim(), txtLast.Text.Trim()) Then
  5.                 AddNewUser(txtUserName.Text.Trim(), txtFirst.Text.Trim(), txtLast.Text.Trim(), txtPassword.Text.Trim())
  6.                 Response.Redirect("login2.aspx")
  7.             End If
  8.         End If
  9.     End Sub

ASP.NET Syntax (Toggle Plain Text) 
  1.  
  2. ALTER PROCEDURE dbo.sp_RegisterNewUser
  3.  
  4. 	(
  5. 		@UserName VARCHAR(50) = NULL,
  6. 		@Password VARCHAR(50) = NULL,
  7. 		@FirstName VARCHAR(50) = NULL,
  8. 		@LastName VARCHAR(50) = NULL,
  9. 		@Company VARCHAR(50) = NULL,
  10. 		@Address VARCHAR(100) = NULL,
  11. 		@City VARCHAR(50) = NULL,
  12. 		@PostCode VARCHAR(10) = NULL,
  13. 		@Email VARCHAR(50) = NULL,
  14. 		@Phone VARCHAR(50) = NULL,
  15. 		@Fax VARCHAR(50) = NULL		
  16. 	)
  17.  
  18. AS
  19. IF @UserName IS NULL OR
  20.    @Password IS NULL OR
  21.    @FirstName IS NULL OR
  22.    @LastName IS NULL OR
  23.    @Company IS NULL OR
  24.    @Address IS NULL OR
  25.    @City IS NULL OR
  26.    @PostCode IS NULL OR
  27.    @Email IS NULL OR
  28.    @Phone IS NULL OR
  29.    @Fax  IS NULL
  30. 		RAISERROR('Please fill in all fields', 16, 1)
  31. ELSE
  32. BEGIN
  33. 	INSERT INTO tblUsers
  34. 	(UserName, Password, FirstName, LastName, Company, Address, City, PostCode, Email, Phone, Fax)
  35. 	VALUES (@UserName, @Password, @FirstName, @LastName, @Company, @Address, @City, @PostCode, @Email, @Phone, @Fax)
  36. 	IF @@error <> 0
  37. 			RAISERROR('User was not added', 16, 1)
  38. 	ELSE
  39. 	BEGIN
  40. 			DECLARE @ID int
  41. 			SELECT @ID = @@IDENTITY
  42. 			SELECT Count(*)
  43. 			FROM tblUsers
  44. 			WHERE CmrID = @ID
  45. 	END
  46. END
  47. RETURN
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2003
Posts: 793
Reputation: Paladine has a spectacular aura about Paladine has a spectacular aura about Paladine has a spectacular aura about 
Solved Threads: 27
Team Colleague
Paladine's Avatar
Paladine Paladine is offline Offline
Master Poster

Re: ASP.NET Registration Page

 
0
  #6
Jul 22nd, 2005
Ok.

Thanks that helps clear things up.

With regards to the additional fields... of course they are not declared. Look the the AddUser Parameters, you are only declaring three things, but requesting more. Understanding the code you are copying from is important. The number of parameters in your subroutine or function must be equal to the number of parameters/values you pass into it. (some exceptions, but that is more detail that won't help).

So if you want to add strEmail etc, you have to add it to the parameters of the your subroutine. And you have to pass it in. Logic!! Make sense?

As for your error, I would have to go line by line (so put in break points) and see where it fails, and what values it is passing around. Looking at the code, it looks sound to me.


Hope this helps.
Assistant Manager, Pharmacy Informatics
Wordpress Learning Blog
Updated : ASP.Net Login Code
Reply With Quote Quick reply to this message  
•
•
Join Date: Jan 2006
Posts: 275
Reputation: f1 fan is an unknown quantity at this point 
Solved Threads: 11
f1 fan f1 fan is offline Offline
Posting Whiz in Training

Re: ASP.NET Registration Page

 
0
  #7
Jan 12th, 2006
Just one quick one on stored procedure names... dont prefix a stored procedure with sp_ use anything but this as when you call a stored procedure SQL Server looks at the name and if it starts with sp_ it will go to the master database first, do a search for the stored proc and only when it fails will it then look in your database. It can be a big performance hit.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2005
Posts: 7
Reputation: HardTech is an unknown quantity at this point 
Solved Threads: 1
HardTech HardTech is offline Offline
Newbie Poster

Re: ASP.NET Registration Page

 
0
  #8
Sep 1st, 2006
I was wondering how this would convert over for lets say an access database?

Ive tried to convert it over, but its a no go.
Reply With Quote Quick reply to this message  
•
•
Join Date: Oct 2008
Posts: 4
Reputation: rajbav2000 is an unknown quantity at this point 
Solved Threads: 1
rajbav2000 rajbav2000 is offline Offline
Newbie Poster

Re: ASP.NET Registration Page

 
0
  #9
Oct 23rd, 2008
i want the coding in c#.net could u post a thread
Reply With Quote Quick reply to this message  
•
•
Join Date: Oct 2008
Posts: 4
Reputation: misselegant is an unknown quantity at this point 
Solved Threads: 1
misselegant misselegant is offline Offline
Newbie Poster

Re: ASP.NET Registration Page

 
0
  #10
Oct 28th, 2008
I also want it in the C# code (aspx) page & coressponding (aspx.cs)
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread has been marked solved.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the ASP.NET Forum
Thread Tools Search this Thread



.net 2.0 activexcontrol advice ajax alltypeofvideos appliances asp asp.net bc30451 beginner bottomasp.net browser button c# c#gridviewcolumn cac checkbox commonfunctions compatible confirmationcodegeneration content courier css dataaccesslayer database datagridview datagridviewcheckbox datalist deadlock development dgv dropdownlist dynamically edit fileuploader fill flash formatdecimal forms formview gridview gudi homeedition iframe iis javascript jquery listbox microsoft mono mouse mssql multistepregistration news numerical objects opera panelmasterpagebuttoncontrols radio ratings redirect registration relationaldatabases reportemail rotatepage schoolproject search security serializesmo.table sessionvariables silverlight smartcard smoobjects software sql-server sqlserver2005 suse textbox tracking treeview unauthorized validatedate validation vb.net video videos virtualdirectory vista visual-studio visualstudio web webapplications webarchitecture webdevelopemnt webprogramming webservice xml xsl youareanotmemberofthedebuggerusers
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC