在datatable行中按索引查找列名 [英] find column name by index in datatable row

问题描述

嗨我需要以下的东西来实现



我的问题是我有数据表中的数据。现在我想为一列只有名字xyz的价值变化

hi i require following thing to achieve

My problem is that i have data in datatable. now i want to chage value for one column only having name "xyz"

if(ResultSet.Rows[i][j].column name = "abc")
{
// then do something
}

或者有没有办法在datarow上迭代，比如

or is there any way to iterate on datarow like

foreach(datacolumn col in row)
{
if(col == "")
{
//do something
}
}

推荐答案

DataColumn类有一个名为 ColumnName 的公共属性。您可以使用它。

DataColumn class has a public property called ColumnName. You can use that.

试试这个

Try this one

DataTable DT = new DataTable();
foreach (DataColumn column in DT.Columns)
{
    Console.Write("Item: ");
    Console.Write(column.ColumnName);
    Console.Write(" ");
    Console.WriteLine(row[column]);
}

clone = ResultSet.Copy();
                clone.Columns.Remove("disbursementdate");
                clone.Columns.Add("disbursementdate");
                               for (int i = 0; i < ResultSet.Rows.Count; i++)
                {
                    clone.Rows[i]["disbursementdate"] = (Convert.ToDateTime(ResultSet.Rows[i]["disbursementdate"])).ToString("MM/dd/yyyy");
                }

这篇关于在datatable行中按索引查找列名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！