Re: How can I execute a SQL-like query against an XML file?
- From: aarnan@xxxxxxxxxxx
- Date: 31 Jan 2006 12:23:43 -0800
In the hopes that some of you do not have to go through the long
tedious searching and experimenting I did...
After scouring various sources, I've learned:
1. DataDirect offers OLE DB drivers and ODBC drivers that seem to
work. They are expensive.
2. I could export to csv files and then need only the MS text
driver installed to query those csv files.
3. You can't query .NET DataSet's unless you want to perform
queries on a single DataTable. Even if you use the DataRelation class,
you can't use SQL-like queries, you have to programatically search.
4. This guy's software let's you query an in memory DataSet
object: http://www.queryadataset.com/default.aspx
.
- References:
- Prev by Date: Using ICommandExecute to insert multiple rows at once - error handling
- Next by Date: Re: Fast load options in OpenRowset
- Previous by thread: How can I execute a SQL-like query against an XML file?
- Next by thread: Inserting data into a excel spread*** using Visual C++
- Index(es):
Loading