»Dotnet Ads
»Message Boards
Message Boards
Dotnet Books
»Member Details
Register
Login
LogOut
Submit Code
Submit Jobs
Submit Projects
»Competition
Community
Winners
Prizes
Write For Us
Members
»Other Resources
Links
Dotnet Resources
|
Authanticate UserName,Password in the Database using C# and SQL Server
//Authanticate UserName,Password in the Database using C# and SQL Server
// Settings in webconfig page
// in <configuration> section
<appSettings/>
<connectionStrings>
<add name="SqlConnectionString" connectionString="Data Source=localhost;Initial Catalog=yourdatabasename;connection timeout=60; User Id=username;Password=password; "/>
</connectionStrings>
//****************
//*************************************************** Login.aspx page listing ********************************//
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Login Page</title>
<script language='JavaScript' type="text/javascript">
<!--
function SetFocus()
{
document.Form1['Login1_UserName'].focus();
}
window.onload = SetFocus;
// -->
</script>
</head>
<body onload="SetFocus();">
<form id="Form1" runat="server">
<div>
<br />
<br />
<table border="0" cellspacing="0" cellpadding="0" width="800" >
<tr>
<td align="center">
<asp:Login ID="Login1" runat="server" BackColor="#EFF3FB" BorderColor="#B5C7DE"
BorderPadding="4" BorderStyle="Solid" BorderWidth="1px" Font-Bold="True" Font-Names="Verdana"
Font-Size="0.8em" ForeColor="#333333" Height="135px" Style="position: static"
OnAuthenticate="Login1_Authenticate" DisplayRememberMe="False" >
<TitleTextStyle BackColor="#507CD1" Font-Bold="True" Font-Size="0.9em" ForeColor="White" />
<InstructionTextStyle Font-Italic="True" Fo
|