Hi mikekiwa,
As per your query i have create the sample. If you have any doubt please revert me back. Below is the working sample.
SQL
CREATE TABLE Logins
(
Uid INT IDENTITY(1,1)
,UserName VARCHAR(200)
,Passwords VARCHAR(200)
)
INSERT INTO Logins VALUES('sameer','sameer123')
INSERT INTO Logins VALUES('zameer','zameer123')
INSERT INTO Logins VALUES('ifra','12324')
INSERT INTO Logins VALUES('danish','12345')
INSERT INTO Logins VALUES('shreekanth','3455')
GO
-----------------------------------------------------------
CREATE PROCEDURE ValidateUserLogin
@UserName VARCHAR(50) = NULL,
@Password VARCHAR(50) = NULL
AS
BEGIN
IF EXISTS(SELECT UserName FROM Logins WHERE UserName = @UserName)
BEGIN
DECLARE @UserId INT
SELECT @UserId = Uid FROM Logins WHERE UserName = @UserName AND Passwords = @Password
IF @UserId IS NOT NULL
BEGIN
SELECT 'User Valid.' AS 'Status'
END
ELSE
BEGIN
SELECT 'Invalid UserName or Password.' AS 'Status'
END
END
ELSE
BEGIN
SELECT 'Invalid UserName.' AS 'Status'
END
END
HTML
<table>
<tr>
<td>
UserName:
</td>
<td>
<asp:TextBox ID="txtUserName" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Password:
</td>
<td>
<asp:TextBox ID="txtPassword" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td align="center" colspan="2">
<asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="btnSubmit_Click" />
</td>
</tr>
</table>
C#
protected void btnSubmit_Click(object sender, EventArgs e)
{
string cns = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
using (SqlConnection con = new SqlConnection(cns))
{
SqlCommand cmd = new SqlCommand("ValidateUserLogin");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@UserName", txtUserName.Text);
if (!string.IsNullOrEmpty(txtPassword.Text))
{
cmd.Parameters.AddWithValue("@Password", txtPassword.Text);
}
con.Open();
object status = cmd.ExecuteScalar();
con.Close();
if (status.ToString().ToUpper() == "USER VALID.")
{
Response.Redirect("Home.aspx");
}
else if (status.ToString().ToUpper() == "INVALID USERNAME OR PASSWORD.")
{
Response.Write(status.ToString());
}
else if (status.ToString().ToUpper() == "INVALID USERNAME.")
{
Response.Write(status.ToString());
}
}
}
VB.Net
Protected Sub btnSubmit_Click(sender As Object, e As EventArgs)
Dim cns As String = ConfigurationManager.ConnectionStrings("ConString").ConnectionString
Using con As New SqlConnection(cns)
Dim cmd As New SqlCommand("ValidateUserLogin")
cmd.CommandType = CommandType.StoredProcedure
cmd.Connection = con
cmd.Parameters.AddWithValue("@UserName", txtUserName.Text)
If Not String.IsNullOrEmpty(txtPassword.Text) Then
cmd.Parameters.AddWithValue("@Password", txtPassword.Text)
End If
con.Open()
Dim status As Object = cmd.ExecuteScalar()
con.Close()
If status.ToString().ToUpper() = "USER VALID." Then
Response.Redirect("Home.aspx")
ElseIf status.ToString().ToUpper() = "INVALID USERNAME OR PASSWORD." Then
Response.Write(status.ToString())
ElseIf status.ToString().ToUpper() = "INVALID USERNAME." Then
Response.Write(status.ToString())
End If
End Using
End Sub