He helps with DataSet and DataTable

  • Thread starter Thread starter edcha
  • Start date Start date
E

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.
 
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
 
Back
Top