C# 从数据表中读取值
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/11556935/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Reading values from DataTable
提问by CrBruno
I have a DataTable populated with samo data/values and I want to read data from DataTable and pass it to a string variable.
我有一个填充了 samo 数据/值的 DataTable，我想从 DataTable 读取数据并将其传递给一个字符串变量。
I have this code:
我有这个代码：
DataTable dr_art_line_2 = ds.Tables["QuantityInIssueUnit"];
I have a countert like this:
我有一个这样的计数器：
for (int i = 1; i <= broj_ds; i++ )
{
QuantityInIssueUnit_value => VALUE FROM DataTable
QuantityInIssueUnit_uom => VALUE FROM DataTable
}
Is this possible or not? If yes then how to pass data from DataTable to those variables?
这可能吗？如果是，那么如何将数据从 DataTable 传递给这些变量？
Thanks!
谢谢！
采纳答案by Nikhil Agrawal
DataTable dr_art_line_2 = ds.Tables["QuantityInIssueUnit"];
for (int i = 0; i < dr_art_line_2.Rows.Count; i++)
{
QuantityInIssueUnit_value = Convert.ToInt32(dr_art_line_2.Rows[i]["columnname"]);
//Similarly for QuantityInIssueUnit_uom.
}
回答by HatSoft
You can do it using the foreach loop
您可以使用 foreach 循环来完成
DataTable dr_art_line_2 = ds.Tables["QuantityInIssueUnit"];
foreach(DataRow row in dr_art_line_2.Rows)
{
QuantityInIssueUnit_value = Convert.ToInt32(row["columnname"]);
}
回答by Anuraj
I think it will work
我认为它会起作用
for (int i = 1; i <= broj_ds; i++ )
{
QuantityInIssueUnit_value = dr_art_line_2[i]["Column"];
QuantityInIssueUnit_uom = dr_art_line_2[i]["Column"];
}
