I accept accounting this commodity basically for the fresher and the beginners. On their apperception that how to actualize a login page and acquaintance with the database. so I will explain actuality how to actualize a login page in asp.net c# and acquaintance with the Sql server
Frist create the database and login table-
Script for Inserting Data into Login Table -
Frist create the database and login table-
Script for creating table
create database CodeSolution
USE [CodeSolution]
GO
/****** Object: Table [dbo].[login] Script Date: 05/10/2016 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[login](
[user_id] [int] IDENTITY(1,1) NOT NULL,
[username] [nvarchar](50) NULL,
[pwd] [nvarchar](50) NULL,
CONSTRAINT [PK_login] PRIMARY KEY CLUSTERED
(
[user_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS =ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
insert into login (username,pwd)values('suneel','12345678');
Source Code -
<%@ Page Language="C#" AutoEventWireup="true"CodeFile="loginpage.aspx.cs" Inherits="loginpage" %>
<!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></title>
</head>
<body>
<form id="form1" runat="server">
<div align="center">
<fieldset style ="width:200px;">
<legend>Login page </legend>
<asp:TextBox ID="txtusername" placeholder="username"runat="server"
Width="180px"></asp:TextBox>
<br />
<br />
<asp:TextBox ID="txtpassword" placeholder="password"runat="server"
Width="180px" TextMode="Password"></asp:TextBox>
<br />
<br />
<asp:Button ID="btnsubmit" runat="server" Text="Submit"
Width="81px" onclick="btnsubmit_Click" />
<br />
</fieldset>
</div>
</form>
</body>
</html>
Code behind(C#):-
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
public partial class loginpage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=SUNEEL-PC;Initial Catalog=CodeSolution;Persist Security Info=True;User ID=sa; password=12345678");
con.Open();
SqlCommand cmd = new SqlCommand("Select * from login where username='" + txtusername.Text + "' and pwd ='" + txtpassword.Text + "'", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
Response.Redirect("Details.aspx");
}
else
{
Response.Write("<script>alert('Please enter valid Username and Password')</script>");
}
}
}
------------------------------------Output------------------------------
Nice article Its easy to understand....
ReplyDelete