Loop through datagridviews on a tabcontrol

Question

4.00/5 (1 vote)

See more:

I have a TabControl with 6 pages. Each page has a GroupBox with a DataGridView on it.
I need to loop through all 6 DataGridViews as part of a cell validation routine.

What I have tried:

I've created this code to find all the DGV's so I can loop through them but it does not seem to find any DGV's at all.

foreach (DataGridView dgv in this.tabControl1.Controls.OfType<DataGridView>())
{
}

Also tried

foreach (DataGridView dgv in this.Controls.OfType<DataGridView>())

which is also a failure.

I can find the DGV's with this code drilling down through the individual control collections but it seems ridiculously complicated. Surely there is a simpler way?

foreach (Control c in this.tabControl1.Controls)
       {
           if (c is TabPage)
           {
               foreach (Control d in c.Controls)
               {
                   if (d is GroupBox)
                   {
                       foreach (Control e in d.Controls)
                       {
                           if (e is DataGridView)
                           {
                               DataGridView dgv = (DataGridView)e;
                                // process the DGVs
                           }
                       }
                   }
               }
           }
       }

What am I missing?

Posted 1-Apr-19 12:08pm

Member 11709930

Updated 4-Apr-19 6:38am

v5

Add a Solution

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)

BillWoodruff · Accepted Answer · 2019-04-02T00:06:00

You gotta drill-down; I'd use Linq:

private List<DataGridView> DGViews;

private void Form1_Load(object sender, EventArgs e)
{
    DGViews = tabControl1.TabPages
        .Cast<TabPage>()
        .SelectMany((TabPage tab) => tab.Controls.OfType<DataGridView>())
        .ToList();
}

Since every call to 'OfType returns an IEnumerable, the use of 'SelectMany does the right thing to enumerate those intermediate results.

You can use 'Controls.Find which can optionally recurse, but it searches on the key/name property of a Control: you can''t use that to get all Controls of the same Type.

Richard Deeming · Accepted Answer · 2019-04-04T06:38:00

Here's a helper method I find useful in this sort of situation:

C#

public static class TreeExtensions
{
    public static IEnumerable<T> SelectRecursive<T>(this IEnumerable<T> source, Func<T, IEnumerable<T>> getChildren)
    {
        if (source is null) throw new ArgumentNullException(nameof(source));
        if (getChildren is null) throw new ArgumentNullException(nameof(getChildren));
        return Iterator();
        
        IEnumerable<T> Iterator()
        {
            var stack = new Stack<IEnumerator<T>>();
            try
            {
                stack.Push(source.GetEnumerator());
                while (stack.Count != 0)
                {
                    var iter = stack.Peek();
                    if (iter.MoveNext())
                    {
                        var current = iter.Current;
                        yield return current;
                        
                        var children = getChildren(current);
                        if (children != null) stack.Push(children.GetEnumerator());
                    }
                    else
                    {
                        iter.Dispose();
                        stack.Pop();
                    }
                }
            }
            finally
            {
                while (stack.Count != 0)
                {
                    stack.Pop().Dispose();
                }
            }
        }
    }
}

With that in place, you can now search your entire control tree using LINQ:

C#

IEnumerable<DataGridView> dataGrids = this.Controls.Cast<Control>()
    .SelectRecursive(c => c.HasChildren ? c.Controls.Cast<Control>() : null)
    .OfType<DataGridView>();

Loop through datagridviews on a tabcontrol

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0