在datatable行中按索引查找列名 [英] find column name by index in datatable row
本文介绍了在datatable行中按索引查找列名的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨我需要以下的东西来实现
我的问题是我有数据表中的数据。现在我想为一列只有名字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屋!
查看全文