How to save data in a C# DataGridView?

2 years ago
Isabella Edwards
1 minute

In C#, you can use the following method to save data in a DataGridView:

  1. Save data using a DataTable.
DataTable dt = new DataTable();

// 将DataGridView的列添加到DataTable中
foreach (DataGridViewColumn col in dataGridView1.Columns)
{
    dt.Columns.Add(col.HeaderText);
}

// 将DataGridView的行添加到DataTable中
foreach (DataGridViewRow row in dataGridView1.Rows)
{
    DataRow dr = dt.NewRow();
    for (int i = 0; i < dataGridView1.Columns.Count; i++)
    {
        dr[i] = row.Cells[i].Value;
    }
    dt.Rows.Add(dr);
}

// 保存DataTable数据到文件或数据库中
  1. Save data using a list.
List<List<string>> data = new List<List<string>>();

// 将DataGridView的行添加到List中
foreach (DataGridViewRow row in dataGridView1.Rows)
{
    List<string> rowData = new List<string>();
    for (int i = 0; i < dataGridView1.Columns.Count; i++)
    {
        rowData.Add(row.Cells[i].Value.ToString());
    }
    data.Add(rowData);
}

// 保存List数据到文件或数据库中
  1. Save data using the DataSource property provided by DataGridView.
// 通过设置DataGridView的DataSource属性为一个DataTable或List来保存数据
dataGridView1.DataSource = dt; // 或 data

Choose the appropriate method to save data in the DataGridView based on specific requirements.

bannerAds