SQL Query On DataTables

[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
*-----------------------*

[Hayato Iriumi]

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.

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
*-----------------------*

[Joel Martinez]

Look into the .Select() method of the DataTable

http://msdn.microsoft.com/library/de...electtopic.asp

Joel Martinez
http://www.onetug.org - Orlando .NET User Group
http://www.codecube.net - blog

cs******@scylla.cs.uoi-dot-gr.no-spam.invalid (pontifikas) wrote in message news:<41**********@Usenet.com>...

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
*-----------------------*

[pontifikas]

Good!! :D
Thanks a lot guys!

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*