如何过滤数据表或从数据表中搜索 [英] how to filter Datatable or search from Data Table

问题描述

嗨
谁能说出如何过滤数据表或从数据表中搜索.
可以在DataTable上应用SQL查询吗?
问候.

Hi
Can any one tell that how to filter datatable or seach from datatable.
Can Sql Queries be applied on DataTable
Regards.

推荐答案

看看

http://www.dotnetperls.com/datatable-select [ http://msdn.microsoft.com/en-us/library/det4aw50.aspx [ ^ ]

have a look

http://www.dotnetperls.com/datatable-select[^]


http://msdn.microsoft.com/en-us/library/det4aw50.aspx[^]

好的博客文章可从 http://www.akamarketing获得. com/blog/161-filtering-sorting-datatable-datatableselect-method.html [

Nice blog article is available at http://www.akamarketing.com/blog/161-filtering-sorting-datatable-datatableselect-method.html[^]

是的，您可以像这样将搜索和过滤查询应用于数据表....
首先为您的数据表创建 DataView ，然后根据您的requiremnets开始过滤和搜索条件.

在示例查询下面.

通过DataView过滤

yes you can apply search and filter query to your datatable like that....
first create DataView for your Datatable then start filter and search criteria as per your requiremnets.

below the sample query.

filter through DataView

DataView dv = dt.DefaultView;
dv.RowFilter = "AssetID>=1000000005 and AssetID<=1000000010";
dv.Sort = "AssetID desc";

这篇关于如何过滤数据表或从数据表中搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！