Dynamically getting visible gridview names

Question

0.00/5 (No votes)

See more:

Hello everyone,

I have 20 gridviews which are static i.e. they are created in design view only not created at runtime. Now these gridviews are shown i.e. their visibility is set to true on basis of one query ,which shows how many gridviews should be visible.

Now these visible gridviews have many data in it i.e. there are may rows in each gridview.

Now i want to save each and every row data of each and every gridview in temporary table of database.

Now i have written code like this, that counter for how many gridviews are visible and on the basis of their counter rows are fetched and inserted to database..but my guide doesn't wants this.

What he wants is to do everything in one loop i.e. for example three (3) gridviews are visible then. first it should read each row of 1st gridview , then as soon as its rows are completed it should go to next gridview.. but how could it be possible when i m fetching gridview rows by its name.. like gridview1.rows[i].cells[j].text where gridview1 is name of gridview...

Please help me out..

Thanks & Regards,
Krunal Panchal

Posted 28-Jun-11 1:56am

krunal25

Add a Solution

3 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)

archer007 · Answer 1 · 2011-06-28T02:19:00

If your gridviews name are folowing some consistent pattren like gridview1, gridview2, gridview3.... so on.
you can do it with one loop only i think. by just adding the variable counter value with the "gridview" constant name.
and in that loop you can get total rows as

var grid = document.getelementById("gridview"+counter);

var totalrows = grid.rows.count;

Wayne Gaylard · Answer 2 · 2011-06-28T04:05:00

You need to do something like this

C#

foreach (Control ctrl in this.Controls)
            {
                if (ctrl is DataGridView && ctrl.Visible == true)
                {
                    DataGridView dgv = ctrl as DataGridView;
                    foreach (DataGridViewRow row in dgv.Rows)
                    {
                        //commit to database
                    }
                }
            }

Hope this helps

Simon_Whale · Answer 3 · 2011-06-28T06:07:00

Solution 3

Further to Waynes Code, same in VB.NET

VB

for each crtl as control in me.controls
  if typeof ctrl is datagridview and ctrl.visible = true then
    for each row as datagridviewrow in ctrl.rows
      'commit to database
    next
  end if
next

Posted 28-Jun-11 6:07am

Simon_Whale

Dynamically getting visible gridview names

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0