VB.NET从数据集中选择列
VB.NET从数据集中选择列
提问于 2012-08-24 05:37:40
我有以下几点：
Dim dt As DataTable = ds.Tables(0)表(0)大约有20列。我喜欢只选几个。"PrID“是其中一个字段。
我试过了
Dim dt As DataTable = ds.Tables(0).Select("PrID")百无所成。有什么想法吗？
Stack Overflow用户
发布于 2016-09-07 14:55:52
'first create a new Dataview
Dim [Dataview] As New DataView
'here add the table to Dataview you want to filter its columns
[Dataview].Table = Ds.Tables(" here Write TableName ")
'here you can display selected Columns in Datatable
Dim [datatable] As DataTable = [Dataview].ToTable(False, "desired column Name ", "desired Column Name")
'here you can display selected Columns in DatagridView1
DataGridView1.DataSource = [Dataview].ToTable(False, "desired column Name ", "desired Column Name")页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/12100360
复制相关文章
相似问题
腾讯云开发者
