CREATE PROCEDURE [dbo].[sp2]
@uname varchar(150), @pwd varchar(150)
AS
SELECT id,fname,lname FROM employee WHERE fname=@uname AND lname=@pwd
<%@ Page Language=”C#” Debug=”true” %>
<%@ Import Namespace=”System.Data” %>
<%@ Import Namespace=”System.Data.SqlClient” %>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<script runat=”server”>
class Program
{
private string source;
private string query;
public void callStoreProc(string u, string p)
{
this.source = @”Data Source=LIT-SIMANTA\SQLEXPRESS;user id=sa;pwd=root;database=testdb”;
SqlConnection conn = new SqlConnection(source);
conn.Open();
SqlCommand cmd = new SqlCommand(“sp2″, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter(“@uname”, SqlDbType.VarChar, 150));
cmd.Parameters.Add(new SqlParameter(“@pwd”, SqlDbType.VarChar, 150));
cmd.Parameters["@uname"].Value = u;
cmd.Parameters["@pwd"].Value = p;
SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.SingleRow);
sdr.Read();
if (sdr.HasRows)
{
int userid = Convert.ToInt32(sdr["id"]);
if (userid > 0)
{
HttpContext.Current.Response.Write(“User Found: ” + sdr.GetValue(1) + ” ” + sdr.GetValue(2));
}
}
else
{
HttpContext.Current.Response.Write(“No such user.”);
}
conn.Close();
}
}
protected void submit_Click(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
}
else
{
string user = uname.Text;
string pwd = passwd.Text;
Program p = new Program();
p.callStoreProc(user, pwd);
}
}
</script>
<html xmlns=”http://www.w3.org/1999/xhtml”>
<head runat=”server”>
<title>Login Page</title>
</head>
<body>
<form id=”form1″ runat=”server” method=”post”>
<div>
<table border=”0″ cellpadding=”0″ cellspacing=”2″>
<tr>
<td><strong>Username:</strong></td>
<td><asp:TextBox runat=”server” ID=”uname” TextMode=”SingleLine”></asp:TextBox></td>
<td><asp:RequiredFieldValidator ID=”RequiredFieldValidator1″ runat=”server” ControlToValidate=”uname” Text=”*”></asp:RequiredFieldValidator></td>
</tr>
<tr>
<td><strong>Password:</strong></td>
<td><asp:TextBox runat=”server” ID=”passwd” TextMode=”Password”></asp:TextBox></td>
<td><asp:RequiredFieldValidator ID=”RequiredFieldValidator2″ runat=”server” ControlToValidate=”passwd” Text=”*”></asp:RequiredFieldValidator></td>
</tr>
<tr>
<td align=”center” colspan=”3″><asp:Button runat=”server” ID=”submit” Text=”Login”
onclick=”submit_Click” /></td>
</tr>
</table>
</div>
</form>
</body>
</html>
