DataGrid (Grid view) Question:

Download Job Interview Questions and Answers PDF

How do I copy a whole row or multiple rows of data?

DataGrid (Grid view) Interview Question
DataGrid (Grid view) Interview Question

Answer:

To copy one row of data, put your cursor in a cell in the grid and press Ctrl+Insert. This will copy the row and its column headers to the clipboard. To copy multiple rows of data, right-click in the grid and choose "Allow multiselect". Use Shift-Click to select multiple adjacent rows, or use Ctrl+Click to select individual, non-adjacent rows. Press Ctrl+C. This will copy all of the rows and their column headers to the clipboard. To copy a single cell's data, turn off "Allow multiselect". Click on the cell you want to copy and press Ctrl+C.

The following table gives details of what happens with the various copy keys and multi-select options.
Multi-Select OFF Multi-Select ON
EDIT COPY CTRL+C CTRL+INS EDIT COPY CTRL+C CTRL+INS
One Cell Highlighted Cell only Cell only Row plus headings Cell only Cell Only Row plus headings
Many Cells(rows) highlighted N/A N/A N/A All highlighted rows plus headings All highlighted rows plus headings All highlighted rows plus headings

Download DataGrid (Grid view) Interview Questions And Answers PDF

Previous QuestionNext Question
How can I view the Chinese and Japanese character sets through Toad?Why can not I add an entry via the grid for a table containing a CLOB column?