如何从vb.net数据表中选择特定的列? [英] how to select specific columns from a data table in vb.net?
本文介绍了如何从vb.net数据表中选择特定的列?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有对此我根据条件筛选数据的数据表,但如何只从数据表中显示特定列?
昏暗申作为新的DataTable
昏暗SQLDA作为SqlDataAdapter的=新SqlDataAdapter的(SQLCMD)
SQlDa.Fill(TrackingDt)
昏暗的行()作为的DataRow = Dt.Select(状态=+'+国+')
昏暗TempDt作为新的DataTable
如果Rows.Length>然后-1
TempDt = Rows.CopyToDataTable()
万一
返回TempDt
解决方案
悲观的看法作为新的数据视图(MyDataTable)
昏暗distinctValues作为数据表= view.ToTable(真,ColumnA)
I have a data table from which i am filtering data based on condition,but how to display specific columns only from the data table?
Dim Dt As New DataTable
Dim SQlDa As SqlDataAdapter = New SqlDataAdapter(SqlCmd)
SQlDa.Fill(TrackingDt)
Dim Rows() As DataRow = Dt.Select("State = " + "'" + State + "'")
Dim TempDt As New DataTable
If Rows.Length > -1 Then
TempDt = Rows.CopyToDataTable()
End If
Return TempDt
解决方案
Dim view As New DataView(MyDataTable)
Dim distinctValues As DataTable = view.ToTable(True, "ColumnA")
这篇关于如何从vb.net数据表中选择特定的列?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文