Username and Password

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ahmd - 13 May 2007 06:12 GMT

Pls some one help me. i have a users table in my database and a login
screen. when login button is clicked after supplying usernme password,
i want to check it from the database and if username and password is
right..then login into admin page.

Pls helpg. very urgent. I user SQL Serverf 2000 db.

thanks

Reply to this Message

Mark Rae - 13 May 2007 09:31 GMT

> Pls some one help me. i have a users table in my database and a login
> screen. when login button is clicked after supplying usernme password,
> i want to check it from the database and if username and password is
> right..then login into admin page.
>
> Pls helpg. very urgent. I user SQL Serverf 2000 db.

How is your ASP.NET app currently querying your SQL Server? Do you use a
DAL?

Signature

http://www.markrae.net

Reply to this Message

Ahmd - 13 May 2007 14:16 GMT

> > Pls some one help me. i have a users table in my database and a login
> > screen. when login button is clicked after supplying usernme password,
[quoted text clipped - 7 lines]
>
> --http://www.markrae.net

I use SQL Datasource to connect to sql server.

Reply to this Message

Mark Rae - 13 May 2007 14:30 GMT

> I use SQL Datasource to connect to sql server.

Ah...

Is it not possible to run a stored procedure to which you pass the userid
and password as parameters and which returns you the number of users which
meet those criteria...?

It the answer is 1, then the login was successful...

Signature

http://www.markrae.net

Reply to this Message

Ahmd - 14 May 2007 05:29 GMT

> > I use SQL Datasource to connect to sql server.
>
[quoted text clipped - 7 lines]
>
> --http://www.markrae.net

Sorry im new to asp.net, pls can u give me sample code to do this
task. i mean a store procedure to check usernname and a password.
thanks in advance

Reply to this Message

Mark Rae - 14 May 2007 06:51 GMT

>> > I use SQL Datasource to connect to sql server.
>>
[quoted text clipped - 12 lines]
> task. i mean a store procedure to check usernname and a password.
> thanks in advance

CREATE PROC CheckLogin
@pstrUserID varchar(20)
@pstrPassword varchar(20)
SELECT COUNT(*) FROM tblUser
WHERE strUserID = @pstrUserID
AND strPassword = @pstrPassword

Signature

http://www.markrae.net

Reply to this Message

Ahmd - 14 May 2007 10:45 GMT

> >> "Ahmd" <mkahme...@gmail.com> wrote in message
>
[quoted text clipped - 27 lines]
>
> - Show quoted text -

Thank you very much for this. if you dont mind.. pls tell me, how to
pass the parameter to the stored procedure as i have never used stored
procedure before and also how to check what it retrived( i mean 1 or
0)

thanks in advance..

Reply to this Message

Mark Rae - 14 May 2007 10:55 GMT

> Thank you very much for this. if you dont mind.. pls tell me, how to
> pass the parameter to the stored procedure as i have never used stored
> procedure before and also how to check what it retrived( i mean 1 or
> 0)

Please don't take this the wrong way, but database integration is absolutely
*fundamental* to any sort of web application...

I appreciate that you are a newbie - we were all newbies once - but you are
going to struggle very badly unless you acquire some very basic ASP.NET
knowledge...

I suggest you get a copy of this:
http://www.amazon.com/ASP-NET-Everyday-Apps-Dummies-Computer/dp/0764597760/ref=p
d_sim_b_1/104-8662182-0953532?ie=UTF8&qid=1177696190&sr=8-2

and work your way through it...

Otherwise, you're going to be forever asking "What do I do next?", "What do
I do next?"...

Signature

http://www.markrae.net

Reply to this Message

Ahmd - 14 May 2007 12:43 GMT

> > Thank you very much for this. if you dont mind.. pls tell me, how to
> > pass the parameter to the stored procedure as i have never used stored
[quoted text clipped - 16 lines]
>
> --http://www.markrae.net

Thank you for your advice.. i really appreciate you.

Reply to this Message

Username and Password

Free Magazines