Asp.Net Login Form with C# and SQL Server Database
Asp.Net Login Form with C# and SQL Server Database
----------------------------------------------------------Heading-----------------------------------------------------------
//netdna.bootstrapcdn.com/twitter-bootstrap/2.3.2/css/bootstrap-//netdna.bootstrapcdn.com/twitter-bootstrap/2.3.2/js/bootstrap.min.js
//code.jquery.com/jquery-1.11.1.min.js
------------------------------------------Database Table--------------------------------------------------------
CREATE TABLE CustomerDetails(Id int IDENTITY(1,1) PRIMARY KEY, Username nvarchar(50),[Password] nvarchar(50), Fullname nvarchar(50))
------------------------------------------Database Procedure--------------------------------------------------------
Create proc GetLoginDetails
(
@Username nvarchar(50),
@Password nvarchar(50)
)
AS
Begin
SELECT * FROM [CustomerDetails]
where
Username=@Username
and [Password]=@Password
End
--------------------------------------------C# Code------------------------------------------------------------------------------------------
SqlConnection conn = new SqlConnection("Server=.;Database=LoginFormDB;Trusted_Connection=True");
SqlCommand cmd = new SqlCommand("GetLoginDetails", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Username", Username);
cmd.Parameters.AddWithValue("@Password", Password);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable data = new DataTable();
adp.Fill(data);
{ lblMessage.Text = "Yes, username and password successfully matched in our record. your full name is "+Convert.ToString( data.Rows[0]["Fullname"]); }
else{lblMessage.Text = "Invalid username and password";}