dataset refresh after update to mssql db(Sql2008R2)
Posted on 2012-12-31
Step1 - I am retriving db data from 3 stored procedures into 3 tables of a dataset. i have established a relation ship between the three tables. table1 - linked to - table 2 and table 2 - linked to table 3. hierarchial structure.
Step 2 - I am binding these tables to a grid in the front end. when user clicks on any row in grid 1 (table 1) all the relevent rows in grid 2(table 2) is displayed. when user clicks on any row of grid 2 (table2) all relevent rows of grid 3 (table3) is getting displayed.
Step 3 - i edit the data in the grid and submit the data using data table. I am having a insert_update stored procedure wherein it accepts a table variable and using merge statement it either updtates/inserts depending the on the condition of data.
all this logic is created in a DAL layer different from UI. i am passing datatable byval.
Up to this it is working fine and updates and inserts are happening fine.
Now once the update is done, to refresh the data in the grid i am loading the data entirely
(Step 1). This is causing some performance issues. is there any way to refresh the dataset moment it executes the insert_update stored procedure for the updates in the db and reflect these changes back to ui and the grid. I am using executenonquery of command object in excuting insert_update procedure.
Request some expert to respond at the earliest.