Requirement using Dataset,dataadapter:Any pointer to this?
I have to use DataAdapter,Data set concepts to maipulate records in a table.
Command object is strictly prohibited to use.
I am having the following requirements that I have to achieve with the above constraints. It is related to C# Windows application using ADO.NET:
1. When I click on button(Named First), then 1st record from the table should be displayed in textboxes on the screen.
2. When I click on button(Named Next), then Next record from the table should be displayed in textboxes on the screen.
3. When I click on button(Named Previous), then previous record from the table should be displayed in textboxes on the screen.
4. When I click on button(Named Last), then last record from the table should be displayed in textboxes on the screen.
5. When I click on button(Named Insert), new records should be inserted in table.
6.When I click on button(Named Delete), data displayed currently in textboxes should be deleted from table.
7.When I click on button(Named Update), changes made in textboxes should be updated to table also.
8. How can I use app.config file or a separate class to keep code realted to database connection that can be reused.