linq To SQl之多表联合查询
来源:互联网 发布:淘宝离职证明哪家靠谱? 编辑:程序博客网 时间:2024/06/04 19:00
方法一:数据控件绑定
protected void LinqServerModeDataSource1_Selecting(object sender, DevExpress.Data.Linq.LinqServerModeDataSourceSelectEventArgs e)
{
ASPxGridView1.KeyFieldName = "RoleID";
e.KeyExpression = "RoleID";
e.QueryableSource = from r1 in eDataContext.Role
join r2 in eDataContext.Role on r1.ParentRoleID equals r2.RoleID
where r1.IsDeleted == false
select new { ParentRoleID = r1.ParentRoleID, RoleID = r1.RoleID, RoleName = r1.RoleName, RoleDesc = r1.RoleDesc, ParentRoleName = r2.RoleName };
}
方法二:普通绑定方法中设置联合主键(用户组别编号和用户编号组合而成)
Casagroup.Entities.EntitiesDataContext eDataContext = new Casagroup.Entities.EntitiesDataContext();
Common _common = new Common();
private void BindUserInfo()
{
UserGroup c = new UserGroup();
//联合查询用户信息
var result = from ugu in eDataContext.UserGroupUser
join us in eDataContext.User on ugu.UserID equals us.UserID
join ug in eDataContext.UserGroup on ugu.UserGroupID equals ug.UserGroupID
select new { ID = ugu.ID + "_" + us.UserID, UserPWD = us.UserPWD, UserGroupID = ugu.UserGroupID, UserID = us.UserID, UserName = us.UserName, UserGroupName = ug.UserGroupName, IsEnabled = us.IsEnabled };
this.gvUser.DataSource = result;
this.gvUser.DataBind();
}
- linq To SQl之多表联合查询
- Linq To Entity 多表联合查询
- linq To SQl之多表关联修改
- linq To SQl之多表关联修改
- LINQ To DataSet:联合查询
- MyBatis之多表联合查询
- [代码]有链接表的LINQ查询(LINQ to SQL)
- LINQ系列:LINQ to SQL Select查询
- LINQ to SQL查询句法
- Linq to SQL 查询Tips
- LINQ to SQL 简单查询
- LINQ TO SQL Null 查询
- LINQ TO SQL Null 查询 .
- LINQ TO SQL Null 查询
- LINQ to SQL异步查询
- Linq to sql :查询句法
- Linq to sql查询句法
- Linq to SQL查询数据库
- 网络流(c++源码)
- SilkTest
- .htaccess文件
- linq To SQl之多表关联修改
- CCS2.2以后版本的GEL文件介绍
- linq To SQl之多表联合查询
- json_decode使用注意事项
- EJB开发体会
- 厚积薄发,有的放矢
- 搞笑:VC(风险投资)与泡妞的关系
- 数据结构学习笔记二 顺序表
- Spring-----> IOC(控制反转)
- 如何写个FLASH,上传到PHP管理系统啊
- MySQL 5.1.31编译安装