Want to output list from a gridview output

Question

5.00/5 (1 vote)

See more:

.NET3.5

I have a table that contains all employee data, it is a flat sql table. It contains General managers who manage managers, and managers who manage team leaders, who manage agents. I have an output on gridview which lists all agents under the GM, that is fine but what I need to do is limit the managers to view only the agents that are under his group. His group is usually composed of 5 team leaders who manage around 8 agents each.
I currently can output the the team leaders from their group on a gridview, the field I need is called Full_name. What I can't do is create a loop that can loop on the gridview full_name as that name is the supervisor_name on the agents record and it's that field that will pull the agents under the team leaders under the managers.
I am using linq to create the query that fills the gridview.
Your help is greatly appreciated.

Posted 28-Jun-11 15:45pm

TonyJPerez

Updated 28-Jun-11 16:33pm

v3

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Not Active · Accepted Answer · 2011-06-28T16:02:00

Solution 1

Hopefully you are using a stored procedure to retrieve the results, if not, you should be. In which case add a where clause to filter by the manager.

Posted 28-Jun-11 16:02pm

Not Active

Comments

TonyJPerez 28-Jun-11 22:50pm

.I am not using a stored procedure. I will post my query tomorrow from work, but basically I call the team leaders by filtering the manager's name as his name appears as supervisor on the team leaders records. I have updated my original post to correct the fields I need. I actually need the full_name field from my gridview as that name will be the supervisor_name on the agents records. So the where clause would be; where supervisor_name = full_name name from the gridview output, the table is the same table. I can output to a new gridview or dropdown box or a combobox as that output will be used to lookup info on another table regarding the employee.

thanks for your reply.

TonyJPerez 29-Jun-11 7:10am

Here is the query I'm using:
Protected Sub allbymgr_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles allbymgr.Click

Dim dC As New APDDataClassesDataContext()
Dim MG = From p In dC.ALLs_employees _
Where p.SUPERVISOR_NAME = lblfname.Text And _
p.EMPLOYMENT_STATUS = "A" _
Order By p.FULL_NAME _
Select p.FULL_NAME, p.LOCATION_NAME, p.EMPLOYMENT_STATUS, _
p.SUPERVISOR_NAME

GridView3.DataSource = MG
GridView3.DataBind()

TonyJPerez · Accepted Answer · 2011-06-28T16:43:00

I am not using a stored procedure. I will post my query tomorrow from work, but basically I call the team leaders by filtering the manager's name as his name appears as supervisor on the team leaders records. I have updated my original post to correct the fields I need. I actually need the full_name field from my gridview as that name will be the supervisor_name on the agents records. So the where clause would be; where supervisor_name = full_name name from the gridview output, the table is the same table. I can output to a new gridview or dropdown box or a combobox as that output will be used to lookup info on another table regarding the employee.

thanks for your reply.