I'm creating an application in C# VS2008 for a Smart Device.
What I already have in my application is a SQLCE database which I can fill and I can read the data from it.
But what I would like to do is:
I would like to get some data out of a datatable by creating a SqlQuery. (the query I can make) but all the rows that match the query I want to save somehow and I want to browse through these rows which match the query. I also want to be able to select a row
and see the data or change it and this has to be saved in the database.
How can I do this?
I know I can walk throug a query by executing a command to a SqlCeDataReader. But I only can see the next row in this reader and can't go back to the previous row. Or is this possible but I don't know how.
Hope you can help,
View Complete Post