<br /> private bool AuthenticateUser(String username, string password)<br /> {<br /> string cs = ConfigurationManager.ConnectionStrings["HamdardConnectionString"].ConnectionString;<br /> using (SqlConnection con = new SqlConnection(cs))<br /> {<br /> SqlCommand cmd = new SqlCommand("mp_authenticateadmin",con);<br /> cmd.CommandType = CommandType.StoredProcedure;<br /> <br /> SqlParameter paramUsername = new SqlParameter("@Username",username);<br /> SqlParameter paramPassword = new SqlParameter("@Password", password);<br /> <br /> cmd.Parameters.Add(paramUsername);<br /> cmd.Parameters.Add(paramPassword);<br /> <br /> con.Open();<br /> int ReturnCode = (int)cmd.ExecuteScalar();<br /> return ReturnCode == 1;<br /> <br /> <br /> }<br /> <br /> }<br /> <br /> <br /> <br /> protected void btnloginn_click(object sender, EventArgs e)<br /> {<br /> if (AuthenticateUser(txtusername.Text, txtpassword.Text))<br /> {<br /> FormsAuthentication.RedirectFromLoginPage(txtusername.Text,true);<br /> <br /> <br /> }<br /> else<br /> {<br /> lblerror.Text = "Invalid Username or /and Password";<br /> <br /> }<br /> }<br /> <br />
<br /> <configuration><br /> <connectionStrings><br /> <add name="HamdardConnectionString" connectionString="Data Source=localhost;Initial Catalog=Hamdard;Integrated Security=True"<br /> providerName="System.Data.SqlClient" /><br /> </connectionStrings><br /> <br /> <system.web><br /> <compilation debug="true" targetFramework="4.0"/><br /> <br /> <authentication mode="Forms"><br /> <forms loginUrl="Login.aspx" defaultUrl="Default.aspx"><br /> </forms><br /> </authentication><br /> <br /> <br /> <authorization><br /> <deny users ="?" /><br /> <br /> </authorization><br /> </system.web><br /> </configuration><br />
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)