Querying Datasets?

[Vax]

Id like to run SQL queries on a dataset I have in memory without creating a database or requiring a connection to a SQL server. I have several tables in this dataset, and its faster than standard data manipulation, but I keep running into this brick wall. Thought I had it wih an OleDbConnection, but no such luck... sigh. Suggestions are welcome.

-Vax

 

[Derek Stone]

SQL queries require a database server that interprets them. You cant execute SQL statements without one.

 

[Vax]

sigh.... not what I wanted to hear. Still, in VB6, I was able to create a .mdb MS Access-type database, and manipulate data in that. I dont see such options in VB .NET...

Im trying to create an application that imports data, manipulates it, allows user input, saves the data as current, and then prints reports based on the data, but the machine is not connected to any database server, and the people Im doing this for are too cheap to get one. Theres a fairly large amout of data (approx 50,000 records, 22 columns per), so performance is an issue. Any suggestions?

 

[Robby]

but the machine is not connected to any database server, and the people Im doing this for are too cheap to get one

Im not sure I understood, do you need to do this with MS Access?

 

[Vax]

The only thing the VB.NET support files seems to talk about is how to create a database on a SQL Server machine. Thats all well and good, except that I dont have one, and have less than a snowballs chance in hell of getting these people to get one, especially for this one application. There seems to be no documentation for running SQL queries locally on a local database without installing the desktop version of SQL Server, another thing that is not acceptable.

All I really need to do is run SQL commands and queries on the data that I have in these datasets. In VB6, there were no datasets, I did everything like this with recordsets, based off of MS-access type database tables I had created at runtime, using the Jet engine. That option no longer seems available. Ive tried manipulating this data by code, but it takes forever and a day, so Im looking for a database-oriented solution. Maybe I can save the data tables in these datasets to a local database? Im floundering here, and any ideas would be highly welcome.