Asp.Net Registration Form, C# and SQL Server (Part 2)
Asp.Net Registration Form, C#, SQL Server, Html, Bootstrap
1. For Registration, Copy html contents from (https://bootsnipp.com/snippets/k7A)
2. Replace all html control into asp.net control
3. Apply validation on asp.net control
4. Get asp.net control value into C#
5. Create Table into database
6. Use ADO.Net code to insert data into database
---------------DB Script------------------------------
Create table RegistrationForm(
Id int identity(1,1)primary key,
Username nvarchar(50),
FullName nvarchar(50),
Email nvarchar(50),
[Password] nvarchar(50)
--No need confirm passoword
)
------------------Sp--------------------------------
Create proc AddRegistrationForm
(
@Id int ,
@Username nvarchar(50),
@FullName nvarchar(50),
@Email nvarchar(50),
@Password nvarchar(50)
)
as
Begin
Insert into RegistrationForm(Username,FullName,Email,[Password])
values(@Username,@FullName,@Email,@Password)
select 'success'as RetParam
End
-------------------------Connection String--------------------
Data Source=.;Initial Catalog=?;Persist Security Info=True;User ID=?;Password=?
------------------------------------------------------------------------------