我可以对存储在数据集对象中的表应用选择语句吗 [英] can i apply select statement on table stored in data set object

问题描述

我可以对存储在数据集对象中的表应用选择语句吗?

can i apply select statement on table stored in data set object

推荐答案

嗨
在这里，我提供了用于过滤数据集中的数据的链接

http://howinaspnet.blogspot.in/2010/07/how-to-filter-data-in-dataset-dataview.html [ http://en.csharp-online.net/Introducing_LINQ%E2%80%94Coding_a_Simple_LINQ_to_DataSet_Query ^ ]


所有Best

Hi
Here I''m providing link for filtering data in dataset

http://howinaspnet.blogspot.in/2010/07/how-to-filter-data-in-dataset-dataview.html[^]

If you familiar with Linq just look at this
http://en.csharp-online.net/Introducing_LINQ%E2%80%94Coding_a_Simple_LINQ_to_DataSet_Query[^]


All the Best

是的，您可以在存储在DataSet对象中的表上使用Select

首先创建一个DataTable对象，并使用DataSet对象中的表对其进行初始化. DataTable类包含4个具有不同参数的Select方法，这些方法将表的行作为DataRow数组返回:

Yes you can use Select on the table stored in DataSet object

First create a DataTable object and initialize it with the table from the DataSet object. DataTable class contains 4 Select methods with different parameters that returns table''s rows as DataRow array :

DataTable dt=DataSet1.Tables[0];
DataRow[] rows=dt.Select("EmpId=123");

在这里它将在表上运行"SELECT * FROM Employee WHERE EmpId = 123"，并返回EmpId为123的行.
您可以参考MSDN以获得不同的Select方法:
msdn.microsoft.com/en-us/library/t5ce3dyt.aspx

Here it will run "SELECT * FROM Employee WHERE EmpId=123" on the table and return rows with EmpId as 123

You can refer to MSDN for different Select methods :
msdn.microsoft.com/en-us/library/t5ce3dyt.aspx

是的，你可以做.

请参考

http://www.java2s.com/Code/CSharp/Database-ADO.net/PopulateaDataSetobjectusingaSELECTstatement.htm [ ^ ]

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

yes you can do.

refer this

http://www.java2s.com/Code/CSharp/Database-ADO.net/PopulateaDataSetobjectusingaSELECTstatement.htm[^]

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

这篇关于我可以对存储在数据集对象中的表应用选择语句吗的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！