<html xmlns="http://www.w3.org/1999/xhtml"> <br /> <head> <h2> Log In </h2> <p> Please enter your username and password. <asp:HyperLink ID="RegisterHyperLink" runat="server" EnableViewState="False" ForeColor="Blue" NavigateUrl="~/register.aspx">Register if you don't have an account. </p> <div class="accountInfo"> <fieldset class="login"> <legend>Account Information</legend> <title>Login Form</title> </head> <body> <div> <table> <tr> <td> Username: </td> <td> <asp:TextBox ID="txtUserName" runat="server"/> <asp:RequiredFieldValidator ID="rfvUser" ErrorMessage="Please enter Username" ControlToValidate="txtUserName" runat="server" /> </td> </tr> <tr> <td> Password: </td> <td> <asp:TextBox ID="txtPWD" runat="server" TextMode="Password"/> <asp:RequiredFieldValidator ID="rfvPWD" runat="server" ControlToValidate="txtPWD" ErrorMessage="Please enter Password"/> </td> </tr> <tr> <td> </td> <td> <asp:Button ID="btnSubmit" runat="server" Text="Submit" onclick="btnSubmit_Click" /> </td> </tr> </table> </div> </body> </fieldset></div> </html>
<asp:LoginView ID="HeadLoginView" runat="server" EnableViewState="True"> <anonymoustemplate> [ <a href="~/Lg1.aspx" ID="HeadLoginStatus" runat="server">Member Log In ] </anonymoustemplate> <loggedintemplate> <asp:LoginName ID="LoginName1" FormatString="Welcome {0}!" runat="server" /> [ <asp:LoginStatus ID="HeadLoginStatus" runat="server" LogoutAction="Redirect" LogoutText="Log Out" LogoutPageUrl="~/"/> ] </loggedintemplate>
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using System.Configuration; public partial class Lg1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void btnSubmit_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("select * from User_information where UserName =@username and Password=@password",con); cmd.Parameters.AddWithValue("@username", txtUserName.Text); cmd.Parameters.AddWithValue("@password", txtPWD.Text); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if(dt.Rows.Count>0) { Response.Redirect("Default.aspx"); } else { ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert('Invalid Username and Password')</script>"); } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)