如何将datagridview中的值存储到集合类C＃中(How to store the value in datagridview in to a collection class C#)

 首先，我将csv文件导入datagridview并将其更改为我想要的格式。 
 
 我可以通过单击按钮过滤掉我不想要的数据，通过使用console.writeline获取我想要的数据。 （仅用于测试，所以我可以看到实际发生的事情）。 有相当数量的列不满足我想要计算的数据，所以我使用.contains()和.replace来过滤它。 
 
 现在，我想存储cell.value.toString（），它将值保存到数组但我不知道如何将数组植入其中。 
 
 这是代码 
 
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;


namespace test2
{
    public partial class Form1 : Form
    {   
        OpenFileDialog openFile = new OpenFileDialog();

        public int colC { get; private set; }

        public Form1()
        {
            InitializeComponent();
        }


        public void Button1_Click(object sender, EventArgs e)
        {
            if (openFile.ShowDialog() == DialogResult.OK)
            {
                List<string[]> rows = File.ReadLines(openFile.FileName).Select(x => x.Split(',')).ToList();
                DataTable dt = new DataTable();
                List<string> headerNames = rows[0].ToList();

                foreach (var headers in rows[0])
                {
                    dt.Columns.Add(headers);
                }
                foreach (var x in rows.Skip(1).OrderBy(r => r.First()))
                {
                    if (x[0] == "Lot ID")   //linq to check if 2 lists are have the same elements (perfect for strings)
                        continue;     //skip the row with repeated headers
                    if (x.All(val => string.IsNullOrWhiteSpace(val))) //if all columns of the row are whitespace / empty, skip this row
                        continue;
                    dt.Rows.Add(x);
                }

                dataGridView1.DataSource = dt;
                dataGridView1.ReadOnly = true;
               // dataGridView1.Columns["Lot ID"].ReadOnly = true;    
                //dataGridView1.Columns[" Magazine ID"].ReadOnly = true;
                //dataGridView1.Columns["Frame ID"].ReadOnly = true;

            }
        }

        public void Form1_Load_1(object sender, EventArgs e)
        {
            openFile.Filter = "CSV|*.csv";

        }

        public void Button2_Click(object sender, EventArgs e)
        {

            SaveFileDialog sfd = new SaveFileDialog();
            sfd.Filter = "txt files (*.txt)|*.txt|Csv files (*.csv)|*.csv";
            sfd.FilterIndex = 2;


            if (sfd.ShowDialog() == DialogResult.OK)
            {
                try
                {
                    StreamWriter sw = new StreamWriter(sfd.FileName, false);
                    {
                        string columnHeaderText = "";

                        int countColumn = dataGridView1.ColumnCount - 1;

                        if (countColumn >= 0)
                        {
                            columnHeaderText = dataGridView1.Columns[0].HeaderText;
                        }

                        for (int i = 1; i <= countColumn; i++)
                        {
                            columnHeaderText = columnHeaderText + ',' + dataGridView1.Columns[i].HeaderText;
                        }


                        sw.WriteLine(columnHeaderText);

                        foreach (DataGridViewRow dataRowObject in dataGridView1.Rows)
                        {
                            if (!dataRowObject.IsNewRow)
                            {
                                string dataFromGrid = "";

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

                                for (int i = 1; i <= countColumn; i++)
                                {
                                    dataFromGrid = dataFromGrid + ',' + dataRowObject.Cells[i].Value.ToString();

                                }
                                sw.WriteLine(dataFromGrid);
                            }
                        }

                        sw.Flush();
                        sw.Close();
                    }
                }
                catch (Exception exceptionObject)
                {
                    MessageBox.Show(exceptionObject.ToString());
                }
                }
            }

        public void Button3_Click(object sender, EventArgs e)
        {


            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                foreach (DataGridViewCell cell in row.Cells)
                {
                    //prevent error occur coz , only execute the not null line
                    if(cell.Value != null)
                    {
                        string cellV = cell.Value.ToString();

                        //do operations with cell, filter out the unnecessary data 
                        if (!cellV.Contains("="))
                        {
                            continue;
                        }
                       else if (cellV.Contains("P = "))
                        {
                            cellV = cellV.Replace("P = ", "");
                        }
                        else if (cellV.Contains("F = n/a"))
                        {
                            cellV =cellV.Replace("F = n/a", "0");

                        }
                        else if (cellV.Contains("F = "))
                        {
                            cellV = cellV.Replace("F = ", "");

                        }

                        Console.WriteLine(cellV + "\n");
                    }

                }
            }

        }

    }
    }
 
 请查看最后一个方法和图片。  
 
 这是输出。  
 
 我使用continue跳过所有与计算无关的数据 
 
 如何存储我在数组中过滤掉的数据??? 
 
 如果您对此问题有任何疑问，请随时询问。 

First, I import a csv file to the datagridview and changed it to the format that I want.
 
I'm able to filter out the data that i do not want by clicking a button, i get the data i want in the console by using console.writeline. (just for testing so i can see what's actually happen). There are quite numbers of column that do not content the data i want for calculation, so i use .contains() and .replace to filter it out.
 
Now, i want to store the cell.value.toString() which hold the value to an array but i have no idea how to implant array to it. 
 
Here is the code
 
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;


namespace test2
{
    public partial class Form1 : Form
    {   
        OpenFileDialog openFile = new OpenFileDialog();

        public int colC { get; private set; }

        public Form1()
        {
            InitializeComponent();
        }


        public void Button1_Click(object sender, EventArgs e)
        {
            if (openFile.ShowDialog() == DialogResult.OK)
            {
                List<string[]> rows = File.ReadLines(openFile.FileName).Select(x => x.Split(',')).ToList();
                DataTable dt = new DataTable();
                List<string> headerNames = rows[0].ToList();

                foreach (var headers in rows[0])
                {
                    dt.Columns.Add(headers);
                }
                foreach (var x in rows.Skip(1).OrderBy(r => r.First()))
                {
                    if (x[0] == "Lot ID")   //linq to check if 2 lists are have the same elements (perfect for strings)
                        continue;     //skip the row with repeated headers
                    if (x.All(val => string.IsNullOrWhiteSpace(val))) //if all columns of the row are whitespace / empty, skip this row
                        continue;
                    dt.Rows.Add(x);
                }

                dataGridView1.DataSource = dt;
                dataGridView1.ReadOnly = true;
               // dataGridView1.Columns["Lot ID"].ReadOnly = true;    
                //dataGridView1.Columns[" Magazine ID"].ReadOnly = true;
                //dataGridView1.Columns["Frame ID"].ReadOnly = true;

            }
        }

        public void Form1_Load_1(object sender, EventArgs e)
        {
            openFile.Filter = "CSV|*.csv";

        }

        public void Button2_Click(object sender, EventArgs e)
        {

            SaveFileDialog sfd = new SaveFileDialog();
            sfd.Filter = "txt files (*.txt)|*.txt|Csv files (*.csv)|*.csv";
            sfd.FilterIndex = 2;


            if (sfd.ShowDialog() == DialogResult.OK)
            {
                try
                {
                    StreamWriter sw = new StreamWriter(sfd.FileName, false);
                    {
                        string columnHeaderText = "";

                        int countColumn = dataGridView1.ColumnCount - 1;

                        if (countColumn >= 0)
                        {
                            columnHeaderText = dataGridView1.Columns[0].HeaderText;
                        }

                        for (int i = 1; i <= countColumn; i++)
                        {
                            columnHeaderText = columnHeaderText + ',' + dataGridView1.Columns[i].HeaderText;
                        }


                        sw.WriteLine(columnHeaderText);

                        foreach (DataGridViewRow dataRowObject in dataGridView1.Rows)
                        {
                            if (!dataRowObject.IsNewRow)
                            {
                                string dataFromGrid = "";

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

                                for (int i = 1; i <= countColumn; i++)
                                {
                                    dataFromGrid = dataFromGrid + ',' + dataRowObject.Cells[i].Value.ToString();

                                }
                                sw.WriteLine(dataFromGrid);
                            }
                        }

                        sw.Flush();
                        sw.Close();
                    }
                }
                catch (Exception exceptionObject)
                {
                    MessageBox.Show(exceptionObject.ToString());
                }
                }
            }

        public void Button3_Click(object sender, EventArgs e)
        {


            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                foreach (DataGridViewCell cell in row.Cells)
                {
                    //prevent error occur coz , only execute the not null line
                    if(cell.Value != null)
                    {
                        string cellV = cell.Value.ToString();

                        //do operations with cell, filter out the unnecessary data 
                        if (!cellV.Contains("="))
                        {
                            continue;
                        }
                       else if (cellV.Contains("P = "))
                        {
                            cellV = cellV.Replace("P = ", "");
                        }
                        else if (cellV.Contains("F = n/a"))
                        {
                            cellV =cellV.Replace("F = n/a", "0");

                        }
                        else if (cellV.Contains("F = "))
                        {
                            cellV = cellV.Replace("F = ", "");

                        }

                        Console.WriteLine(cellV + "\n");
                    }

                }
            }

        }

    }
    }
 
Please have a look in the last method and the Picture. 
 
Here is the output. 
 
I skip all the data which is not related to calculation by using continue
 
How do i store the data that i filtered out in array???
 
Please do not hesitate to ask if you have any inquiry about the question.

原文：https://stackoverflow.com/questions/44939611