How to get DataGridView data in a 2d array?

Question

In my application i am trying to get datagridview (5rows and 5columns)data to a 2d array,can anybody help to get data in to array...

        int countColumn = dataGridView1.ColumnCount -1;
        int j=0,k=0;
        string dataFromGrid = "";
        foreach (DataGridViewRow i in dataGridView1.Rows)
        {
            if (!i.IsNewRow)
            {


                //dataFromGrid = r.Cells[0].Value.ToString();

                for ( j = 0; j <= countColumn; j++)
                {
                    dataFromGrid = dataFromGrid + i.Cells[j].Value.ToString();


                }

            }
           var[k,j], Convert.ToInt32(dataFromGrid)
           k=k+1;

Inner loop condition should be j < countColumn

Shaharyar
– Shaharyar

2014-09-09 14:07:32 +00:00
Commented Sep 9, 2014 at 14:07 — Shaharyar
– Shaharyar, Commented Sep 9, 2014 at 14:07

Lucaci Andrei · Accepted Answer · 2014-09-09 14:36:21Z

4

If you fancy the foreach loop, you could do this:

var array = new object[dataGridView1.RowCount,dataGridView1.ColumnCount];
foreach (DataGridViewRow i in dataGridView1.Rows)
{
    if (i.IsNewRow) continue;
    foreach (DataGridViewCell j in i.Cells)
    {
        array[j.RowIndex, j.ColumnIndex] = j.Value;
    }
}

edited Sep 9, 2014 at 14:36

answered Sep 9, 2014 at 14:30

Lucaci Andrei

40710 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Lucaci Andrei Over a year ago

I'm not sure I understood correctly, but, your array 'value' will actually be a 2x2 array containing all your values from your grid. In order to "get the value" from the array, you'll need to construct a string containing all the items from the array, that is parsing again the array, and creating the string. If you'd like, you could create this string when you're populating the array, thus eliminating an unnecessary loop. But again, I don't fully understand what you mean by "print the array value in textbox".

Lucaci Andrei Over a year ago

Well, you have to consider that there are multiple values in your array. If you have only one textbox, then you'll have to decide yourself what value from the array to put into it. If you already have your indexes, you just have to grab the value from your array: myTextBox.Text = array[iIndex, jIndex].ToString();

Sam · Accepted Answer · 2014-09-09 14:17:35Z

2

object[,] arr2d = new object[dataGridView1.Rows.Count,dataGridView1.Columns.Count];

for (int x = 0; x < arr2d.GetLength(0); x++)
     for (int i = 0; i < arr2d.GetLength(1); i++)
            arr2d[x, i] = dataGridView1.Rows[x].Cells[i].Value;

This should work

answered Sep 9, 2014 at 14:17

Sam

2,9601 gold badge20 silver badges26 bronze badges

1 Comment

Sam Over a year ago

@user3413736 just cycle it again and add the values to .Text

Alex · Accepted Answer · 2017-08-11 10:48:47Z

0

//first of all create a 2D array varialble and count the rows and //column of data grid view
string[,] dataValue = new string[gridViewBillingItems.Rows.Count, gridViewBillingItems.Columns.Count];

//loop through the rows of data grid view 
foreach (DataGridViewRow row in gridViewBillingItems.Rows)
{
    //getting index of row
    int i = row.Index;
    //loop through the column of data grid view

    foreach (DataGridViewColumn col in gridViewBillingItems.Columns)
    {
        //getting index of column
        int j = col.Index;
        //add all the rows and column to 2D Array
        dataValue[row.Index, col.Index] = gridViewBillingItems.Rows[i].Cells[j].Value.ToString();
    }
}

edited Aug 11, 2017 at 10:48

Alex

1,4519 silver badges18 bronze badges

answered Aug 11, 2017 at 10:08

Bijay Budhathoki

18612 bronze badges

Collectives™ on Stack Overflow

How to get DataGridView data in a 2d array?

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related