hi,
I my opinion i think i should use datasets fully when performing select, insert, update and delete operations to DB.
Foloowing this concept, The applications control flow should be:
Assume there is a CRUD application to manage Employee
1. When the Employee Manager loads it should create a empty Dataset
2. When the user searches a EMployee it should load the create dataset with retreived values
3. When user updates a reterived value, then thayt update should reflect in the dataset then send to DB
4. When user deletes a record from the dataset then it should remove the record from the dataset then remove from DB
However, in my previouse application i only used Dataset in Searching values and all the retreived data was stored in a dataset but or other operations i dont use the dataset.
I have the followng questions:
1. IN the Employee manager application, should i load whole table to the dataset, when the application loads so that each search and update and insert happens to the the dataset, so a search is not send to teh database instead it searches a value inthe dataset, that makes search faster?
2.Should i create all the relationships that i made with the tables in the database in the dataset as well?
I have more qs but this thread will be longer but i'm sure that you would understand my question that i'm looking for the way to create apps that does CRUD operations professionally using professional techniques (especially using Datasets)..... Could any direct me to links or give some guidance on creation of CRUD applications?
TY in Advance