如何使用数据集.select [英] How to use dataset .select

问题描述

大家好，

我有一个带有值的数据集.我需要使用ds.select()方法从该数据集中获取一些数据，该方法是如何在条件为
的情况下使用count(*)
预先感谢

hi all,

i am having one dataset with values in that. i need get some data from that dataset by using ds.select () method in that how to use count (*) with where condition

thanks in advance

推荐答案

DataSet是DataTables的容器，DataTable的每一行都保存在DataRowCollection中，这是DataTable的Rows属性. />
beloe代码可帮助您获取名为"ds"的指定数据集的行数.

DataSet is a container for DataTables, the each row of your DataTable is held in the DataRowCollection, which is the Rows property of the DataTable.

The beloe code helps you to fetch row count of the specified dataset named ''ds''

ds.Tables("mytable").Rows.Count

thanks for reponse. but my quesition is how we use

suppose i have total table survey  in one dataset. i need to get below query

 select  distinct EmpRacfid from Survey  how can i get in dataset.select  method

这篇关于如何使用数据集.select的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！