hello techies,
here i will explain how to make login page nd check whether user has registered or not using store procedure...firstly make simple table by name"stuloginstoreproc " in database which has id(set as identity) name and password...and then make store procedure named "signin" as follows....
create PROCEDURE [dbo].[signin]
@name varchar(50),
@password int
AS
BEGIN
SET NOCOUNT ON;
SELECT * from stuloginstoreproc where @name=name and @password=password
END
following is the design u can make according to ur need
<%@ Page Language="C#" MasterPageFile="~/nationalmaster.master" AutoEventWireup="true" CodeFile="signin.aspx.cs" Inherits="signin" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<br />
username
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
<br />
password <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br />
<br />
<asp:Button ID="btnsign" runat="server" OnClick="btnsign_Click" OnClientClick ="return confirm('are u sure want move')" Text="sign in" />
<asp:Label ID="lblsign" runat="server"></asp:Label><br />
<br />
new user?<br />
<a href="register.aspx">Register Here</a>
</asp:Content>
and then write code separation file as follows...means aspx.cs file
using System.Data.SqlClient;
public partial class signin : System.Web.UI.Page
{
dbClass db = new dbClass();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnsign_Click(object sender, EventArgs e)
{
db.myconnection();
SqlCommand cmd = new SqlCommand("signin", db.sqlcon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", SqlDbType.VarChar).Value = TextBox1.Text;
cmd.Parameters.AddWithValue("@password", SqlDbType.Int).Value = TextBox2.Text;
SqlDataReader dr = cmd.ExecuteReader ();
dr.Read();
if (dr.HasRows)
{
lblsign.Text = "successfully logged in";
Session["Loginname"] = TextBox1.Text;
Response.Redirect("welcome.aspx");
}
else
{
lblsign.Text = "login failed";
}
}
}
now u are done njoy