kfirba
Well-known member
- Joined
- Dec 29, 2012
- Messages
- 77
- Programming Experience
- 1-3
Hello!
Is it possible querying a dataset instead of the Database? When I create a query in the designer, I think that when I activate the query, I actually querying the Database and not the Dataset.
In addition, lets say I want to find some record in the dataset from Table called "books" how do I search for it? The way I do it now is using a query with "WHERE" and retrieving/deleting/updating the record.
and again, if I query the Dataset, for example get all the books that their name contains the letter 'a' how do I store the result? In a dataTable? How do I actually query a dataset and only once the user presses on the "save" button, the Adapter will update the Database?
Thanks!
Is it possible querying a dataset instead of the Database? When I create a query in the designer, I think that when I activate the query, I actually querying the Database and not the Dataset.
In addition, lets say I want to find some record in the dataset from Table called "books" how do I search for it? The way I do it now is using a query with "WHERE" and retrieving/deleting/updating the record.
and again, if I query the Dataset, for example get all the books that their name contains the letter 'a' how do I store the result? In a dataTable? How do I actually query a dataset and only once the user presses on the "save" button, the Adapter will update the Database?
Thanks!