SQL Query On DataTables

  • Thread starter Thread starter pontifikas
  • Start date Start date
P

pontifikas

Simple as that:
How do I perform an sql query onto a DataTable(not a Database table,

but a ->

#using System.Data;
#DataTable dt = new DataTable();

)

I dont care about column names.I'll use indexes.

Thanks In advance. :)

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*
 
Hello pontifikas,

Use dt.Select("OneOfColumn = 'MyCriterion'")

You will get an array of DataRow object. Or you could use Filter of DataView
object out of DataTable object.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sql server deadlock retry 6
Why is there no default name for a DataTable here adapter.Fill(dt); 2
Insert from a DataTable 1
Code Analysis CA2000 2
Strongly typed DataTables 1
DataTable Select 3
Adding datatable data to sql database. 1
create datatable 1

Back
Top