SQL Query by login

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bret - 30 Sep 2006 00:03 GMT

I am VB developer learning ASP.net.
Have successfully creating a Login page and a GridView. My question is:
After a user successfully logins, I want to capture there login ID and use it
to feed a parameter in the SQL statement in the Gridview (or dataset?) so the
results returned of course are only the logged in user. What is the best way
to accomplish this?

thanks in advance.

Reply to this Message

Bret - 30 Sep 2006 01:23 GMT

sorry I've posted this question twice

> I am VB developer learning ASP.net.
> Have successfully creating a Login page and a GridView. My question is:
[quoted text clipped - 4 lines]
>
> thanks in advance.

Reply to this Message

Gaurav Vaish (www.EduJiniOnline.com) - 30 Sep 2006 14:55 GMT

> to feed a parameter in the SQL statement in the Gridview (or dataset?) so
> the
> results returned of course are only the logged in user. What is the best
> way
> to accomplish this?

In VB.Net?
If Request.IsAuthenticated = True Then
dim username as string

username = Request.Identity.Name

'Do whatever you want to with the username...
End If

'And enjoy life :-)

Signature

Happy Hacking,
Gaurav Vaish | http://www.mastergaurav.com
http://www.edujinionline.com
http://articles.edujinionline.com/webservices
-------------------

Reply to this Message

Rate this thread:

SQL Query by login

Free Magazines