This documentation is archived and is not being maintained.

How to: Add New Rows in the Results Pane 

You can add new data either by typing it in or by pasting it from another program such as Notepad or Excel. A row to be pasted must have exactly the same number and types of columns as the table into which you are pasting. You can paste multiple rows into the Results pane at once.

For information about how to enter data see Rules for Updating Results.


The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

To add a new data row

  1. Navigate to the bottom of the Results pane, where a blank row is available for adding a new data row.

    The initial values for all columns will be NULL.


    To go directly to the first empty row use the navigation bar at the bottom of the Results pane.

  2. If you are pasting rows from the Clipboard, select the new row by clicking the button to its left.


    If one or more of the rows you're pasting can't be committed to the database you will receive a message telling you which row(s) couldn't be committed.

  3. Enter the data for the new row. If you are pasting, choose Paste from the Edit menu.

  4. Leave that row to commit it to the database.

If an error occurs when you save the row the Query and View Designer displays a message and then returns you to the row you were editing. You can then:

  • Resolve the error by making further edits in the row.

  • Cancel the edit by pressing ESC. If you press ESC while in a cell that you changed, the changes for that cell are canceled. If you press ESC while in a cell you have not changed, the changes for the entire row are canceled.

See Also