User Roles

[kewldudehere]

Hi,

I want to display different type of grid with different cols in a same page based upon the role of user logged in .
Can anybody give me a hint how to approach to the solution.

Bye.

[aliasruel]

Hi,
you can use panel object control dragged in you web page.

regards,
Ruel

Hi,

I want to display different type of grid with different cols in a same page based upon the role of user logged in .
Can anybody give me a hint how to approach to the solution.

Bye.

[kewldudehere]

Will Panel Cotrol achieve this functionality.? I am just wondering, if i place 3 gridview controls in one panel but only 1 will be displayed at a time based upon the role of user logged in. Will the other 2 appear as blank or will they be hidden and appear as if only 1 control exist on that page.?

Like if i place one type of gridview for basic user first in a panel and place second gridview control for manager next in a same panel and if manager logs in will he see the first gridview control as blank in the panel.?

I am new to panel control. Can u guide me in this?

[Frinavale]

Will Panel Cotrol achieve this functionality.? I am just wondering, if i place 3 gridview controls in one panel but only 1 will be displayed at a time based upon the role of user logged in. Will the other 2 appear as blank or will they be hidden and appear as if only 1 control exist on that page.?

Like if i place one type of gridview for basic user first in a panel and place second gridview control for manager next in a same panel and if manager logs in will he see the first gridview control as blank in the panel.?

I am new to panel control. Can u guide me in this?

I don't think you need to use the Panel Control to do this.


How are you defining the Role's of your user?
Are you using Membership to do this?

What you need to do is create a custom data source for your grid view based on the user's role...

So, when you are generating the data source for the GridView, check the user's role first and generate the data source accordingly.

Does this make sense?

-Frinny

[kewldudehere]

HI Frinny,

I have Roles defined in Roles table. Each role will have different view of the gridview with different cols.

So do i need to write 3 seperate Queries for 3 roles and bind the Query to gridview. If this is the case, how to define gridview in aspx page. Do i need to mention all column names that can appear in the grid and bind those cols for appropriate col in database.? If i do like this, the cols that are not being displayed for particulat role will be displayed as blank? I have never worked in this scenario before.

[Frinavale]

HI Frinny,

I have Roles defined in Roles table. Each role will have different view of the gridview with different cols.

So do i need to write 3 seperate Queries for 3 roles and bind the Query to gridview. If this is the case, how to define gridview in aspx page. Do i need to mention all column names that can appear in the grid and bind those cols for appropriate col in database.? If i do like this, the cols that are not being displayed for particulat role will be displayed as blank? I have never worked in this scenario before.

Yup you're getting it.

For example:
So say you have employees that work in 2 different departments. Some employees will be in the role that lets them see Aquatics products and some employees will be in the role that lets them see Dog products.....
So, basically you want to do something like this (please note this is pseudo code):

If the User isInRole("aquatics") Then
    myGridView.DataSource = CreateAquaticsDataSource()
If the User isInRole("dogs") Then
    myGridView.DataSource = CreateDogsDataSource()
End Ifs
 
myGridView.DataBind
 

Where you'd have a function CreateAquaticsDataSource that returns a DataView or some such thing that contains a table with all the different types of aquatics stuff....and a function called CreateDogsDataSource that returns a DataView or some such thing that contains a table with all the different types of dogs stuff...

These DataViews will set the GridView's column titles and fill the GridView with information...

eg

Private Function CreateAquaticsDataSource As DataView
  Dim dr As Data.DataRow
  Dim dt As Dat.DataTable
 
   dt.Columns.Add(New Data.DataColumn("Fish Variety", GetType(String))
   dt.Columns.Add(New Data.DataColumn("Price", GetType(String))
 
   dr = dt.NewRow
   dr("Fish Variety") = "Gold Fish"
   dr("Price") = "$12.95"
 
   dt.Rows.Add(dr)
 
   dr = dt.NewRow
   dr("Fish Variety") = "Beta Fish"
   dr("Price") = "$10.95"
 
   dt.Rows.Add(dr)
 
'this will return a DataView with 2 columns named "Fish Variety" and "Price"
'it has 2 rows of data in it.
 
   Return New Data.DataView(dt)
 
End Function
 
 
Private Function CreateDogsDataSource As DataView
  Dim dr As Data.DataRow
  Dim dt As Dat.DataTable
 
   dt.Columns.Add(New Data.DataColumn("Dog Toy", GetType(String))
   dt.Columns.Add(New Data.DataColumn("Colour", GetType(String))
   dt.Columns.Add(New Data.DataColumn("Price", GetType(String))
 
   dr = dt.NewRow
   dr("Dog Toy") = "Squeaky Toy"
   dr("Colour") = "Blue"
   dr("Price") = "$15.00"
 
   dt.Rows.Add(dr)
 
   dr = dt.NewRow
   dr("Dog Toy") = "Tug-of-War Toy"
   dr("Colour") = "White and Red"
   dr("Price") = "$23.99"
 
   dt.Rows.Add(dr)
 
'this DataView has 3 columns: Dog Toy, Colour, and Price.
'it has 2 rows of data in it.
   Return New Data.DataView(dt)
 
End Function
 

So what you need to do is somehow check what role your user is in and create a DataSource for your grid view based on the role that the user is in.

Cheers!

-Frinny

[nmsreddi]

Hello

when you are using three different queries for different users ,its not a problem to show different data for different users just bind the grid in page load depending on the userid who so ever login ,

but remember you cannot use template colmns in this case .make autogenerate columns as true and your queries should select only the required columns for a particular users

Regards

[Frinavale]

...
but remember you cannot use template colmns in this case .make autogenerate columns as true and your queries should select only the required columns for a particular users

Thanks Nmsreddi!

I forgot to mention that :)

-Frinny

[kewldudehere]

Thanks guys for all ur replies..i will try the same way and let u know if i am stuck..Thanks

[kewldudehere]

Hi, its not working. Its throwing me a runtime error as column not bound.
The column name that does'nt appear for particular role , is not getting bound by datasource which is obvious and throwing a runtime error.

I have used asp:bound field for this column.

Any suggetsions

[Frinavale]

Hi, its not working. Its throwing me a runtime error as column not bound.
The column name that does'nt appear for particular role , is not getting bound by datasource which is obvious and throwing a runtime error.

I have used asp:bound field for this column.

Any suggetsions

As mentioned before, you cannot have your columns bound using this method.
Try removing your bound column and try again.

:)

[kewldudehere]

As mentioned before, you cannot have your columns bound using this method.
Try removing your bound column and try again.

:)

I tried to use asp:hyperlinkfield too...but no good...So what is the appropriate column should i use from the given columsn of gridview.

[Frinavale]

I tried to use asp:hyperlinkfield too...but no good...So what is the appropriate column should i use from the given columsn of gridview.

You cannot set the columns of the grid like that.

Could you please post snippets of your code so that we can help you better?

[kewldudehere]

HI.. these are the columns for first query for a particular role.

  <asp:HyperLinkField DataTextField="WeekBeginningDate" 
                                    DataNavigateUrlFields="TimeCardID" 
                                    DataNavigateUrlFormatString="ActivityEntry.aspx?id={0}" 
                                    HeaderText="WeekBeginningDate" 
                                    SortExpression="WeekBeginningDate"/>
 
 
               <asp:BoundField DataField="TC_STATUS" HeaderText="Timecard Status" SortExpression="TC_STATUS" HtmlEncode="false" HeaderStyle-Wrap="false" />

These are next set of cols in same page for second query and second role

<asp:HyperLinkField DataTextField="TotalCountofTimeCards" DataNavigateUrlFields="TimeCardID" DataNavigateUrlFormatString="ActivityEntry.aspx?id={0}" HeaderText="Total Count of TimeCards"  />
               <asp:HyperLinkField DataTextField="TotalApproved" DataNavigateUrlFields="TimeCardID" DataNavigateUrlFormatString="ActivityEntry.aspx?id={0}" HeaderText="Total Approved"  />
 

In the code behind of page load event i have,,.,

 If role = "Team Manager" Then
            query = "select TimeCardID,WeekBeginningDate,TC_Status from timecards "
            FillGrid(grdTimeCardStatus, query)
 
        End If
        If role = "Line Item Approver" Then
            query = "select TimeCardID,TotalCountofTimeCards,TotalApproved from timecards"
            FillGrid(grdTimeCardStatus, query)
 
        End If

[Frinavale]

From what I understand, you are actually filling the GridView with the same data for each role Except for one you want to show 2 extra columns.

In this case I would recommend filling the GridView with the same amount of columns. Then in the method that handles the RowDataBound event, make those 2 extra rows invisible for the group that's not supposed to see this data.

Eg:

 Protected Sub MyGridView_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GV_SearchResults.RowDataBound
 
        'setting the Last column to be invisible
        e.Row.Cells(e.Row.Cells.Count - 1).Visible = False
        'setting the Second Last column to be invisible
        e.Row.Cells(e.Row.Cells.Count-2).Visible = False
    End Sub
 

If this doesn't help you let me know and we'll try something else.

Oh, and in the future please put code within [code] tags.
For instance if I wanted to post my VB.NET code I would type

'My VB.NET code
 

Or if I wanted to post my ASP code I would type

'My Asp Code
 

This just makes things easier to read and follow.

Thanks!

-Frinny