Quick Edit For Table Row Data In Query Result Grid
Scenario:
If I run any select query where filed1=value1 etc, and it shows one or more rows in the grid below.
Now I identify a required change and want to update that column value in a particular row.
Current Process:
One option is to write an update query and change the column value.
The second option is to right-click on the table and go to edit but again it only shows a limited number of rows at a time.
Requirement:
Option1: Allow right click on result grid and give the option to script the selected row/columns(s) as edit query.
Option2: Allow right click on result grid and give the option to directly open edit for that table/row
Option3: Allow direct edit of the row in result grid or in an editable popup window.