Querying Datasets?

[Guest Vax]

I'd 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 it's 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 can't execute SQL statements without one.

[Guest 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 don't see such options in VB .NET...

 

I'm 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 I'm doing this for are too cheap to get one. There's 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 I'm doing this for are too cheap to get one

 

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

[Guest Vax]

The only thing the VB.NET support files seems to talk about is how to create a database on a SQL Server machine. That's all well and good, except that I don't have one, and have less than a snowball's 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. I've tried manipulating this data by code, but it takes forever and a day, so I'm looking for a database-oriented solution. Maybe I can save the data tables in these datasets to a local database? I'm floundering here, and any ideas would be highly welcome.