How to move selected cell data to an array in DataGrid programatically

Question

Here is a code that moves all the data from datagrid to the array. But I want only selected data to be moved to this array. Selection may be done by mouse.

public List<double[]> ExtractGridData(DataGridView grid)
    {
        int numCols = grid.Columns.Count;
        List<double[]> list = new List<double[]>();
        foreach (DataGridViewRow row in grid.Rows)
        {
            if (row.IsNewRow) // skip the new row
                continue;
            double[] cellsData = new double[numCols];
            foreach (DataGridViewCell cell in row.Cells)
                if (cell.Value != null)
                    cellsData[cell.ColumnIndex] = Convert.ToDouble(cell.Value);
            list.Add(cellsData);
        }

        return list;
    }

Moha Dehghan · Accepted Answer · 2013-03-16 09:34:07Z

1

Use grid.SelectedRows instead of grid.Rows.

You can also use grid.SelectedCell if the SelectionMode is set to CellSelect and you need individual cell values:

List<double> cellsData = new List<double>();
foreach (DataGridViewCell cell in grid.SelectedCells)
{
    if( cell.Value != null)
        cellsData.Add(Convert.ToDouble(cell.Value));
}

edited Mar 16, 2013 at 9:34

answered Mar 16, 2013 at 9:20

Moha Dehghan

18.5k3 gold badges60 silver badges74 bronze badges

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

8 Comments

user2049436 Over a year ago

How do i set SelectionMode to CellSelect?

Moha Dehghan Over a year ago

@user2049436 What do you mean "didn't work"? What happened exactly? In design mode, select your grid, bring the Porperties window (press F4), change SelectionMode to CellSelect. Or in code: grid.SelectionMode = DataGridViewSelectionMode.CellSelect;.

user2049436 Over a year ago

Am getting an exception even after selecting the rows.

user2049436 Over a year ago

In the code: "cellsData does not exist in current context" is the error.

Moha Dehghan Over a year ago

@user2049436 Please look closely at the code in the answer. cellsData is defined by me, on the line before the foreach loop. What is the exception? Please read some books and learn how to really program in C# and Winforms.

|

Collectives™ on Stack Overflow

How to move selected cell data to an array in DataGrid programatically

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related