ASP.NET

This linq to datatable works, however, is there a 'better' way? RSS

3 replies

Last post Jul 11, 2012 03:30 PM by WebAppArchitect

‹ Previous Thread|Next Thread ›

- Reply
WebAppArchit...

Member

7 Points

39 Posts
This linq to datatable works, however, is there a 'better' way?

Jul 10, 2012 06:43 PM|LINK
```
Dim intEmpCritGID As Int32 = DirectCast(e.Row.DataItem, DataRowView).Row.ItemArray(0)

Dim result1 = (From c In Criteria.EmployeeCriteriaInfo
                Where c.Field(Of Integer)("EmpCritGID").Equals(intEmpCritGID)
                Select c.Field(Of Boolean)("CritOrgFlag"))
```
I have been playing around with method syntax and how I was writing it was too long. I knew I was doing something wrong so I went back to this syntax.
- Edited by WebAppArchitect on Jul 10, 2012 06:43 PM
- Reply
itsbpk

Member

475 Points

144 Posts
Re: This linq to datatable works, however, is there a 'better' way?

Jul 10, 2012 08:56 PM|LINK
```
I dont think so.
```
```
Dim result1 = (Criteria.EmployeeCriteriaInfo
.Where( c => c.Field(Of Integer)("EmpCritGID").Equals(intEmpCritGID) )
.Select( c => c.Field(Of Boolean)("CritOrgFlag")))
```
- Edited by itsbpk on Jul 10, 2012 08:56 PM
- Edited by itsbpk on Jul 10, 2012 08:56 PM
- Marked as answer by WebAppArchitect on Jul 11, 2012 03:29 PM
- Reply
mayankpathak...

Contributor

3643 Points

850 Posts

Re: This linq to datatable works, however, is there a 'better' way?

Jul 11, 2012 06:04 AM|LINK

better approach is your second post using lambda....

Regards, Mayank
- Marked as answer by WebAppArchitect on Jul 11, 2012 03:29 PM
- Reply
WebAppArchit...

Member

7 Points

39 Posts

Re: This linq to datatable works, however, is there a 'better' way?

Jul 11, 2012 03:30 PM|LINK

Thanks for the feebback everbody!