DataGridView行循环和单元格数据访问

本文关键字:数据 访问 单元格 循环 DataGridView | 更新日期: 2023-09-27 18:17:12

我有一个从数据库填充的DataGridView,我需要取每一行并从中创建一个对象。我不知道该怎么做。

DataGridView Columns: Name Price ProductId Condition MemberId Description

代码:

foreach(DataGridViewRow row in members_dg.rows)
{
    foreach(DataGridViewCell cell in row.Cells)
    {
        // need to get info. This should show u what im looking for. 
        //string name = cell1.Text;
        //string price = cell2.Text;
        //etc
        //Member member = new Member(name, price, ...);
    }
}

DataGridView行循环和单元格数据访问

也许是这个?

foreach(DataGridViewRow row in members_dg.rows)
{
  // need to get info. This should show u what im looking for. 
  string name = row.Cells[0].Value.ToString();  // first column
  string price = row.Cells[1].Value.ToString();  // second column
  //etc
  Member member = new Member(name, price, ...);
}

你不需要遍历每个单元格,只需要调用你所在行的单元格索引

if(cell.OwningColumn.IsDataBound)
{
    Member member = new Member();
    //switch statement or you can use reflection
    switch(cell.OwningColumn.DataPropertyName)
    {
        case "name":
             member.Name=cell.Value;//need cast
        ....
    }
}