Hi this is simple example of registration prcess using store proc.
<asp:TextBox ID="txtFName" runat="server" CssClass="form-text required">
</asp:TextBox> </br>
<asp:TextBox ID="txtEmail" runat="server" CssClass="form-text required"></asp:TextBox></br>
<asp:Button ID="btnSubmitRegist" runat="server" Text="submit" OnClick="btnSubmitRegist_Click"/>
--
.aspx code
protected void btnSubmitRegist_Click(object sender, EventArgs e)
{
registerNewUser();
}
public void registerNewUser()
{
objcUserInfo.Firstname = txtFName.Text;
objcUserInfo.Email = txtEmail.Text;
}
-----
public class cUserInfo
{
private string firstname;
public string Firstname
{
get { return firstname; }
set { firstname = value; }
}
private string email;
public string Email
{
get { return email; }
set { email = value; }
}
}
---dal layer
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
public void newRegistration(cUserInfo userInfo)
{
try
{
con.Open();
SqlCommand cmdInsert = new SqlCommand("USP_NewUserRegistration", con);
cmdInsert.CommandType = CommandType.StoredProcedure;
cmdInsert.Parameters.AddWithValue("@strFirstName", userInfo.Firstname);
cmdInsert.Parameters.AddWithValue("@strEmail", userInfo.Email);
int i = cmdInsert.ExecuteNonQuery();
}
store proc:
CREATE PROCEDURE [dbo].[USP_NewUserRegistration]
(
@strFirstName nvarchar(50),
@strEmail nvarchar(50)
}
AS
BEGIN
DECLARE @UID INT=0
IF @strusername NOT IN (SELECT UserName from userRegistrationTB)
BEGIN
BEGIN TRANSACTION
INSERT INTO userRegistrationTB
(
firstname,
useremail
}
VALUES
{
@strFirstName,
@strEmail
}
COMMIT
END
ELSE
BEGIN
SELECT 'user already exists pleae choose different username'
END
hope u can understnd ths...just call dal layer from ur aspx by creating class object . i have used only 2 field here for ur ease of understanding.
Rajesh081725, if this helps please login to Mark As Answer. | Alert Moderator