DaniWeb IT Discussion Community - simple ASP.Net Loginpage with SQL server

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)

- ASP.NET (http://www.daniweb.com/forums/forum18.html)

- - simple ASP.Net Loginpage with SQL server (http://www.daniweb.com/forums/thread68801.html)

simple ASP.Net Loginpage with SQL server

Hi All,

I am new to .Net. can anyone please tell me how to create loginpage in detail with steps and code.

Thanks,
Swapna

Re: simple ASP.Net Loginpage with SQL server

Hi..Please try to following link...

This link is step by step login creation....

http://www.asp.net/learn/security/?lang=cs

Thanks,
<email snipped>

Re: simple ASP.Net Loginpage with SQL server

u hould create table eiyh two columns and enter username and password in table using insert command.
then come to asp page
in page load 1. initialize the connection using the code

sqlconnection con=new sqlconnection();

2.open the connection

con.open()

sqlcommand cmd=new sqlcommand("select *from tablename",con);

sqldatareader dr=cmd.executereader()

while(dr.read())

if ((TxtUsername.Text) ==re.GetString(0) && (TxtPassword.Text) == re.GetString(1))
{
    Response.Redirect("default.aspx");
}
else
{
    Response.write("invalid");
}