Click here to Skip to main content
15,918,041 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a 2 tables:
Mrg: 
UserID || UserID_Mrg || Status
and 
User:
UserID || Name 
I want to display all employees (UserID) under each Manager (UserID_Mrg)
example:
UserID_Mrg = 12
So display all UserID with UserID_Mrg = 12
so far I could just display the users Information an their Manager:


What I have tried:

<pre lang="c#">private void BindGridView()
    {
        using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString))
        using (SqlDataAdapter adapter = new SqlDataAdapter(@"
SELECT tbl_user.Name, tbl_mrg.UserID_Mrg FROM   tbl_mrg 
INNER JOIN tbl_user ON tbl_mrg.UserID = tbl_user.UserID 
WHERE  ((tbl_mag.user_ID = @UserID))
ORDER BY     tbl_user.Name", con))
        {
            adapter.SelectCommand.Parameters.Add(new SqlParameter("@UserID", SessionHelper.UserID));
            adapter.Fill(Data2);
            GridView2.DataSource = Data2;
            GridView2.DataBind();
        }
    }


<asp:GridView ID="GridView2" runat="server">
                <Columns>      
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="Mrg" HeaderText="Manager" SortExpression="Manager" />

                </Columns>
            </asp:GridView>
Posted
Updated 7-Feb-17 21:46pm

Assuming @userID is the manager id, this
tbl_mgr.user_ID = @UserID
should be
tbl_mgr.UserID_Mrg = @UserID

such as
select u.userid, u.name from user u join mrg m on u.userid=m.userid where userid_mrg = 12
 
Share this answer
 
v2
As per your question you want to see the all the users of a manager.
So the condition should be passed userid_mrg instead of userid and the query will be .

"SELECT
tbl_user.Name
,tbl_mrg.UserID_Mrg
FROM tbl_mrg
INNER JOIN tbl_user
ON tbl_mrg.UserID = tbl_user.UserID
WHERE tbl_mrg.UserID_Mrg = @managerid" // Here @managerid=12 you can pass.
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900