Using SQL to access data in a datagrid

[dougconran]

I'm sure there is an easy answer here but I just can't find it.

I have an Ascii file of data that I load into a datagrid using VB .net oledb tools.

What I want to be able to do is execute SQL commands on the data in the dataset that feeds the datagrid but I can't work out how.

I can load data into the grid from a file and can set up an OledbConnection to an existing database but can't work out how to import data into a database from a file or point it at a file to load from. I guess it is something to do with the oledbconnection connectionstring - but what?

TIA

Doug

 

[Korach]

You can load data to a dataset from any source, if you have a provider for it (you can even write your own provider). What is the file type?

 

[dougconran]

Korach, sorry not to respond to your reply more quickly. In fact I found out how to do it by playing around and then forgot that I'd asked.



Tks

Doug