He helps with DataSet and DataTable

[edcha]

I am new in .Net and I am learning in C # and I need help me with the
following,
Certainly I thank your help.

When one connects to a motor of data base like SQL Server
And only one wants to extract a certain columns use the following.

SELECT productid, nomprod, price FROM product WHERE productid = 1

The above extracts of the table "product" only the columns "productid,
nomprod, price" than in the column "productid = 1"


I am charging the data in a DataSet from .xml file
Now then I understand that a dataset is not a motor of data base or a
data base
the subject is, as I make a consultation like the previous? That only
certain columns be given back to me
How to do the consultations SELECT in one DataSet and DataTable?

Thanks.

 

[edcha]

like SQLServer or MySQL

the DataSet is fill from a xml file and need to make the next
sql expression

SELECT productid, nomprod, price FROM product WHERE productid = 1

Thanks