C#从DataTable或BindingSource获取值 [英] C# getting values from DataTable or BindingSource
本文介绍了C#从DataTable或BindingSource获取值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我可以查询数据库,但是如何从DataTable中提取值并将它们放在
谢谢
解决方案
在DataTable中,您有行和列。要选择特定的单元格,您需要执行此操作:
label1.Text = dataTable [0] [0];
这将将label1文本设置为第0行列0值。
要遍历每一行,请使用:
foreach(DataRow row在dataTable.Rows)
{
Console.WriteLine(row [ColumnName1]);
Console.WriteLine(row [ColumnName2]);
Console.WriteLine(row [ColumnName3]);
Console.WriteLine(row [ColumnName4]);
}
这将打印每列列的值。在此代码中,您需要使用列名称
替换列名称(例如ColumnName1)的字符串
I have a labels that need values retreieved from a Database.
I am able to query the database but how can I extract values from a DataTable and place them in the appropiate labels
Thanks
解决方案
In DataTable you have rows and columns. To select a particular cell you need to do this:
label1.Text = dataTable[0][0];
This will set the label1 text to Row 0, Column 0 value.
To iterate through each row use:
foreach(DataRow row in dataTable.Rows)
{
Console.WriteLine(row["ColumnName1"]);
Console.WriteLine(row["ColumnName2"]);
Console.WriteLine(row["ColumnName3"]);
Console.WriteLine(row["ColumnName4"]);
}
This will print values for columns against each row. In this code you need to replace string for columnname (e.g. ColumnName1) with your column names
这篇关于C#从DataTable或BindingSource获取值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文