Adding a New Record to the DataGridBy John Sanborn
I've done a lot of reading on ASP.NET since it was ASP+, but only recently got around to actually doing anything with it. I started putting together a page with the DataGrid and was pretty happy with the ease of coding all the functionality it provides. Displaying, editing and deleting records is a breeze. (For information on editing the records in a DataGrid, be sure to read: A Thorough Examination of the DataGrid Web Control: Part 6. To see how to delete a record from the DataGrid, be sure to read Part 8.)
When I got to the question of adding new records, though, I seemed to hit a wall. While I found plenty of information in books and on the Internet on editing, deleting and customizing the DataGrid's display, I couldn't find much at all about how to add records without creating another page. Tinkering around with the grid a little I came up with a way to easily add a "New Record" row to the bottom of the grid.
Essentially, I display a series of TextBox Web controls in the Footer of the DataGrid into which
the user can enter values for a new record. The screenshot below shows an example Web page using the
code I will present in this article. Note that for each record in the
bound to the DataGrid, the details are displayed, along with an "Edit" and "Delete" button. In the
Footer, there is a TextBox for each column, along with an "Add" button. A user can add a new record
by simply entering values into these bottom TextBoxes and clicking the "Add" button.
In this article I use the
stores table from the SQL Server
For simplicity, this page only has five text fields and doesn't include any validation, so mind your
data constraints if you try it out as-is. Displaying, editing, and deleting data with the DataGrid has
been thoroughly covered already, so I'll limit my explanation here to adding the "New Record" row.
Creating the TextBox Web Controls in the Footer
Adding a TextBox Web control in the Footer is a snap if you are using TemplateColumns. TemplateColumns, contain a number of templates. The template that is rendered for a particular row of the DataGrid depends on the type of the row being added. For example, if the row is an ordinary item row, the ItemTemplate or AlternatingItemTemplate is used, depending on whether or not the row being added is an odd or even row. If the row being added is specified as the
EditItemIndexrow, then the TemplateColumn's EditItemTemplate is used. Finally, if the row being rendered is the Header or Footer, the HeaderTemplate or FooterTemplate is used.
To add a TextBox Web control to the Footer, we simply need to use a TemplateColumn for each column of
the DataGrid, and provide a FooterTemplate. Below you will see a DataGrid declaration that uses the
FooterTemplate. Before we examine this DataGrid, though, it is
important to point out that the DataGrid does not display the Footer row by default. In order to have
it displayed you must set the DataGrid's
ShowFooter property to True.
Also note that the DataGrid's
ItemCommand event is wired up to the event handler
ItemCommand event fires whenever a command button in the DataGrid is clicked.
The "Add" button is a command button, and when it is clicked we'll have to execute some code that inserts
a new record into the database based on the values provided by the user. Later on in this article
we'll be examining the
doInsert event handler in detail.
While this code shows only one TemplateColumn, realize that this standard TemplateColumn would be used for every databound column in the DataGrid. Using the FooterTemplate, a TextBox Web control has been added to the bottom of each column.
The ItemTemplate and EditItemTemplate's are pretty straightforward. The ItemTemplate simply
displays the value of the
DataSource field this column is to display, while the
EditItemTemplate creates a TextBox Web control for the user to edit the data.
Following these TemplateColumns needs to be an EditCommandColumn. The EditCommandColumn is a built-in DataGrid column that displays the Edit button for each row. When a particular row's Edit button is clicked, the row enters "edit mode" and the row's EditItemTemplate is used when the DataGrid is rendered. Additionally, the EditCommandColumn chnages for the row being edited so as to display an Update and Cancel button. This EditCommandColumn is added to our DataGrid like so:
The final DataGrid column is used to display a Delete button for the populated data rows and the
"Add" button for the DataGrid Footer rows. Recall that this "Add" button, when clicked, will add
the new record to the DataGrid. Note that the
CommandName property for the Button Web control
in the Footer is set to
Insert. We'll need to use this knowledge in the DataGrid's
ItemCommand event handler, which will execute after the user clicks the "Add" button.
Examining the Source Code for the
doInsert Event Handler
The code-behind (or server side script) for the update, delete or cancel procedures go pretty much unchanged from what you would expect. The only exception is a line of code added to the procedure for displaying the edit row. To make the table more user friendly, the new record row (Footer) is hidden when an existing data row is selected for editing. This is accomplished by simply setting the
ShowFooterproperty to False programmatically:
ShowFooter property is set back to True in the procedures for updating and
The update event handler would need the
storeGrid.ShowFooter = True line inserted
In order to handle the case when the user clicks the "Add" button, we must provide an event handler
for the DataGrid's
ItemCommand event. This event handler,
must contain an
If statement to check the
CommandName property before the code
to insert a new record is executed. This is because all command buttons in the DataGrid, when
clicked, cause the DataGrid's
ItemCommand event to fire. This includes the Edit, Update,
Cancel, and Delete buttons as well. Therefore, we need to make sure that the
property that caused the
ItemCommand event to fire is the same as the
property of the Add button.
After this check, we simply need to read in the values of the Footer TextBoxes, issue an
appropriate database call, and then rebind the data to the DataGrid. The code for
is given below:
As you can see, adding that much desired "New Record" row to the DataGrid control couldn't be simpler. You only need to make use of the Footer for the new data entry fields, add a button and include a procedure for inserting the record to the database. Definitely easier than creating a new page!