如何从DB / datagridview / datatable中提取数据 [英] how to pull data from DB/datagridview/datatable
本文介绍了如何从DB / datagridview / datatable中提取数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有这个表..我想拉一个具体的数据..
让我们说..我有家得宝按钮。我如何将 CameraID
值为2,并将其放在一个变量上。
这样的东西..
'dim foo as string = cameraID其中MarkerName是Home Depot
解决方案
鉴于您使用 DataTable
,例如:
'示例DataTable'
Dim dt = new DataTable()
dt.Columns.Add(cameraID,gettype(integer))
dt.Columns .Add(MarkerName,gettype(string))
dt.Rows.Add(new object(){2,Home Depot})
dt.Rows.Add(new object() 1,CSI})
您可以使用LINQ查询:
'foo现在是2'
/ pre>
Dim foo = dt.AsEnumerable()_
.Where(function(row)row MarkerName)=Home Depot)_
.Select(function(row)row(cameraID))_
.Single()
或
选择
方法来过滤DataTable
:'foo2现在是2'
Dim foo2 = dt.Select(MarkerName ='Home Depot')(0) (cameraID)
I have this table.. and I want to pull a specific data..
Let's say.. I have Home Depot as a button. how can I pull the
CameraID
value of 2 and put it on a variable.. something like this..'dim foo as string = cameraID where MarkerName is Home Depot
解决方案Given you use a
DataTable
, e.g.:' example DataTable ' Dim dt = new DataTable() dt.Columns.Add("cameraID", gettype(integer)) dt.Columns.Add("MarkerName", gettype(string)) dt.Rows.Add(new object() {2, "Home Depot"}) dt.Rows.Add(new object() {1, "CSI"})
you could use a LINQ-query:
' foo is now 2 ' Dim foo = dt.AsEnumerable() _ .Where(function(row) row("MarkerName") = "Home Depot") _ .Select(function(row) row("cameraID")) _ .Single()
or the
Select
method to filter theDataTable
:' foo2 is now 2 ' Dim foo2 = dt.Select("MarkerName = 'Home Depot'")(0)("cameraID")
这篇关于如何从DB / datagridview / datatable中提取数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文