列出当前在线销售员创建的所有客户.即在gridview中列出客户 [英] List all customer who are created by presently online Salesperson. i.e list customer in gridview

问题描述

protected void Page_Load(object sender, EventArgs e)
        {
            string str = Convert.ToString(Session["id"]);
            cid = new Guid(str);
            GetUsers();
        }
        private void GetUsers()
        {
            var createdId = from crid in cr.PersonalDetails
                            where crid.createdBy == cid
                            select crid.UserId;
            var usr = from u in cr.aspnet_Users
                      where createdId.Contains(u.UserId)
                      select u;

            //var users = from u in cr.aspnet_Users
            //            where cr.PersonalDetails.Any(e => e.createdBy == u.UserId)
            //            select u;
            grvCustomer.DataSource = usr;
            grvCustomer.DataBind();
        }

推荐答案

是否正在寻找内部联接?如果是这种情况，请查看如何:执行内部联接[ ^ ]

Are looking for inner join? If that''s the case, have a look at How to: Perform Inner Joins[^]

这篇关于列出当前在线销售员创建的所有客户.即在gridview中列出客户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！