Format SQL query string using asp:loginname

[Loopsludge]

ASP.NET 2.0/ SQL Server 2005/ Login Controls

Does anyone know how to format a SQL query string using asp:loginname
in the WHERE clause?

Alternatively would I need to store the login name upon login w/in a
Session variable?

Can someone give me an example?

Thanks,
Loopsludge

 

[NIan]

login control, requires you to install Role Management schema for
SQL.(I think)

 

[Guest]

Well you could use a parameter for the where clause and then set that
parameter to be a ControlParameter that with the ControlID property set to
the ID of your <asp:LigonNAme> control.

 

[Loopsludge]

Sounds reasonable. Do you have an example on how that may look?

Loopsludge