LInQ Query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

.NET Inside SQL Server (2005)

LInQ Query

Author

Topic

Shilpa22
Starting Member

37 Posts

Posted - 2009-08-20 : 09:07:49

Hi All,
I have the result set consisting og 4 values.using LINQ query i want to select only 2 values from them. can i use select key word in c# for multiple selections.
For single selection its working..
example:
var filterValues = from det in rolesAndMembers where det.RoleID == cmbExistingRole.SelectedItem.ToString() select det.roleId;
In the similar way how to select det.roleName

Please help me out

Thanks in Advance
Shilpa

rudeboy
Starting Member

3 Posts

Posted - 2009-08-27 : 14:16:40

You could try something like:

var filterValues = from det in rolesAndMembers where det.RoleID == cmbExistingRole.SelectedItem.ToString() select new { det.roleId, det.roleId };

rudeboy
Starting Member

3 Posts

Posted - 2009-08-27 : 14:17:59

Sorry for the above typo...I meant:

var filterValues = from det in rolesAndMembers where det.RoleID == cmbExistingRole.SelectedItem.ToString() select new { det.roleId, det.roleName };

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources