how to skip for/forach by using linq

Question

0.00/5 (No votes)

See more:

VB

I want to skip for/foreach by using linq for below code-
'For Each row In uxDataGridView.Rows
                '    If Not row.Cells(0).ReadOnly Then
                '        row.Cells(0).Value = True
                '    End If
                'Next

Posted 12-Dec-12 1:27am

Member 9111713

Add a Solution

Comments

Member 9111713 12-Dec-12 7:29am

Please help me ASAP.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Sperneder Patrick · Answer 1 · 2012-12-12T02:24:00

I think you need to understand what Linq under the hood really does...

To clear this a little bit to you: Linq is just syntactic sugar, this means under the hood linq uses
Enumerators over its datasources.. And that anyway will end in an foreach loop.
I guess now i know what you want to achieve, it seems you just want a performant way to edit the cells that are accessible.?!

im afraid you dont have other choices as to do as i mentioned, or to rethink the whole logic of your table if
you come up to iterate over 4000! rows...

Sperneder Patrick · Answer 2 · 2012-12-12T01:50:00

Solution 1

maybe this works...

C#

uxDataGrid.Rows.Where(c => c.Cells[0].ReadOnly == false).ForEach(c => c.Cells[0] = true);

Mark as answer if it worked!

regards Patrick

Posted 12-Dec-12 1:50am

Sperneder Patrick

Updated 12-Dec-12 2:01am

v4

Comments

Member 9111713 12-Dec-12 8:09am

Hi Patrick,
Thanks for reply..but I want to do this because of the performance issue (to select first cell of each row if 4000 rows in grid takes 10-15 second) and I tried the below code also but not useful.
Dim rowsList = (From row In uxDataGridView.Rows Where Not row.Cells(0).ReadOnly Select row).ToList()
rowsList.ForEach(Sub(p As DataGridViewRow)
p.Cells(0).Value = True
End Sub)

I just don't want to add foreach in my code. Please reply if someone has any other solution.