Hi

At the moment out solution has a login page created using the Visual Studio Website Admin tool so an anon user can see a read only gridview and a user who logs in can see a gridview that has an edit option. That is all working fine however what we would like to do is have a user login in and depending on which section they are from for example HR, they only see records associated with HR and can only edit those records.

Can anyone point us in the right direction of how to go about setting this up?

Mucho thanks

One possible way to do this is to setup a roles table in your database that associates X role to a user logon and then execute a query specific query based upon the role the user is in.

Something like this would suffice

string role = "";
//execute scalar and assign the value to role

switch(role)
{
   case "HR":
       //Execute HR Query
       break;
   case "Payroll":
      //Execute Payroll Query
      break;
}

Alternatively you could combine the scalar step and the switch statement into a single stored procedure but I think it is overkill for what you are trying to do.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========