Login-Validating(ASP.NET) against a DB

[Naijaacoder]

I'm looking for an ASP.NET(login page) that validates against a database.
And after succesful logon ..PRINT the USERS name on the Page(Session)!!
Can anybody help?

___
Newsgroups brought to you courtesy of [url]www.dotnetjohn.com[/url]

[John G.]

Here's one article.
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT03.asp[/url]
--
John Goodfellow
irtfnm
use john at goodfellowassoc dot com


"Naijaacoder" <patrickige@acn.waw.pl> wrote in message
news:uHYgPqp5DHA.2720@TK2MSFTNGP09.phx.gbl...

> I'm looking for an ASP.NET(login page) that validates against a database.
> And after succesful logon ..PRINT the USERS name on the Page(Session)!!
> Can anybody help?
>
> ___
> Newsgroups brought to you courtesy of [url]www.dotnetjohn.com[/url]

[David Coe]

You can take the user ID/password and compare them to what you have in the database. If an item is found that is matching, grab the user name (ie, David) from the database, and display the name in a label. If the name is something that you want to persist across pages, then you could store the name in a session variable and then display it on several pages across the app.

int iUser = 0;
SqlDataReader reader = myCommand.ExecuteReader();

while(reader.Read())
{
myLabel.Text = reader["FirstName"].ToString();
// Session["UserFirstName"] = reader["FirstName"].ToString();
}

if (iUser == 0)
// in valid user id/password
else
// continue