This should work. Use a crazy WHERE clause in your SELECT statement (something like: WHERE Name = 'Einar Kvandahl') in your data adapter (would make it faster if you used an indexed field). Then use the data adapter fill method to fill a dataset.
In theory it should work just fine, but I am not sure it is the "best" way of doing it.
Einar
>Is there a way to retrieve an empty dataset? It seems like EmptyDataSet() returns the dataset AFTER emptying it. I do not want to touch the current records. I was not sure if the Clone() would be approppriate here.
>Thanks - Mark
Semper ubi sub ubi.