1. Right-click the DataGrid in the DisplayProductsGrid.aspx page, select Property Builder and click the Columns tab.

2. Uncheck the Create Columns Automatically at Run Time check box.

3. Add a Bound Column to the Selected columns panel with the following properties:

   Property	Value
   Header text	ID
   Data Field	ProductID

4. Add a second Bound Column to the Selected columns panel with the following properties:

   Property	Value
   Header text	Name
   Data Field	ProductName

5. Add a third Bound Column to the Selected columns panel with the following properties:

   Property	Value
   Header text	Price
   Data Field	UnitPrice
   Formatting expression	{0:c}

6. Click OK to close the DataGrid1 Properties dialog box.

7. Right-click the DisplayProductsGrid.aspx page in the Solution Explorer window and select Build and Browse.

1. Add a Web Form Page to your project named AuthorMaster.aspx.

2. Drag and drop the Authors database table from the Server Explorer window onto the Designer surface.

3. Add an Untyped DataSet to the page.

1. Add a DataGrid control to the page.

2. Right-click the DataGrid, select Property Builder, and click the Columns tab.

3. Uncheck the Create Columns Automatically at Run Time check box.

4. Add a HyperLink Column to the Selected columns panel with the following properties:

   Property	Value
   Header text	Author
   Text field	au_lname
   URL field	au_id
   URL format string	AuthorDetail.aspx?id={0}

5. Double-click the Designer surface and enter the following code for the Page_Load method:

   C#. 

   private void Page_Load(object sender, System.EventArgs e)
   {
     sqlDataAdapter1.Fill( dataSet1 );
     DataGrid1.DataSource = dataSet1;
     DataGrid1.DataBind();
   }
   

   VB.NET. 

   Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
    MyBase.Load
     SqlDataAdapter1.Fill(DataSet1)
     DataGrid1.DataSource = DataSet1
     DataGrid1.DataBind()
   End Sub
   

6. Right-click the AuthorMaster.aspx page in the Solution Explorer window and select Build and Browse.

1. Add a Web Form Page to your project named AuthorDetail.aspx.

2. In the Server Explorer window, drag the Pubs data connection from under the Data Connections tab onto the Designer surface.

3. Add an SqlCommand object to the page.

4. In the Properties window, select the sqlCommand1 object and assign the value sqlConnection1 to its Connection property.

5. In the Properties window, select the sqlCommand1 object and assign the following value to the CommandText property (when the Regenerate Parameters dialog box appears, click Yes):

   Select * from Authors Where au_id=@authorID
   

6. Add three Web Forms Labels to the page. Provide the first Label with an ID of lblFirstName, the second Label with an ID of lblLastName, and the third Label with an ID of lblPhone.

1. Double-click the Designer surface to switch to the Code Editor.

2. Enter the following code for the Page_Load handler:

   C#. 

   private void Page_Load(object sender, System.EventArgs e)
   {
     System.Data.SqlClient.SqlDataReader dtrAuthor;
   
     string AuthorID = Request.QueryString[ "id" ];
     if (AuthorID == null)
       Response.Redirect( "AuthorMaster.aspx" );
   
     sqlCommand1.Parameters["@authorID"].Value=AuthorID;
     sqlConnection1.Open();
     dtrAuthor = sqlCommand1.ExecuteReader();
     if (dtrAuthor.Read())
     {
       lblFirstName.Text = (string)dtrAuthor["au_fname"];
       lblLastName.Text = (string)dtrAuthor["au_lname"];
       lblPhone.Text = (string)dtrAuthor["phone"];
     }
     sqlConnection1.Close();
   }
   

   VB.NET. 

   Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
    MyBase.Load
     Dim dtrAuthor As System.Data.SqlClient.SqlDataReader
     Dim AuthorID As String
   
     AuthorID = Request.QueryString("id")
     If IsNothing(AuthorID) Then
       Response.Redirect("AuthorMaster.aspx")
     End If
   
     SqlCommand1.Parameters("@authorID").Value = AuthorID
     SqlConnection1.Open()
     dtrAuthor = SqlCommand1.ExecuteReader()
     If dtrAuthor.Read() Then
        lblFirstName.Text = dtrAuthor("au_fname")
        lblLastName.Text = dtrAuthor("au_lname")
        lblPhone.Text = dtrAuthor("phone")
     End If
     SqlConnection1.Close()
   End Sub
   

3. Right-click the AuthorMaster.aspx page—not the AuthorDetail.aspx page—in the Solution Explorer window and select Build and Browse.

1. Open the Microsoft SQL Server Service Manager by going to Start, Programs, Microsoft SQL Server, Service Manager.

2. Click the Stop button.

1. Add a Web Form Page to your project named EditGrid.aspx.

2. Drag and drop the Products database table from the Server Explorer window onto the Designer surface.

3. Add an Untyped DataSet to the page.

1. Add a DataGrid control to the page.

2. Right-click the DataGrid, select Property Builder, and click the Columns tab.

3. Uncheck the Create Columns Automatically at Run Time check box.

4. In the Available columns panel, expand Button Column, and add the Edit, Update, Cancel Columns to the Selected columns panel.

5. Enter the following three bound columns:

   Header Text	Data Field	Read Only
   ID	ProductID	Checked
   Name	ProductName	Unchecked
   Price	UnitPrice	Unchecked

6. Click OK to close the Property Builder dialog box.

1. Double-click the Designer surface to switch to the Code Editor.

2. Enter the following code for the Page_Load handler:

   C#. 

   private void Page_Load(object sender, System.EventArgs e)
   {
   if (!Page.IsPostBack)
     BindGrid();
   }
   

   VB.NET. 

   Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
    MyBase.Load
     If Not Page.IsPostBack Then
       BindGrid()
     End If
   End Sub
   

3. Enter the following BindGrid() method below the Page_Load handler:

   C#. 

   void BindGrid()
   {
     sqlDataAdapter1.Fill( dataSet1 );
     DataGrid1.DataSource = dataSet1;
     DataGrid1.DataKeyField = "ProductID";
     DataGrid1.DataBind();
   }
   

   VB.NET. 

   Sub BindGrid()
     SqlDataAdapter1.Fill(DataSet1)
     DataGrid1.DataSource = DataSet1
     DataGrid1.DataKeyField = "ProductID"
     DataGrid1.DataBind()
   End Sub
   

Procedure 13.5. C# Steps

1. Switch back to the Designer by selecting Designer from the View menu.

2. In the Properties window, select the DataGrid and click the Events icon at the top of the Properties window (the icon that looks like a lightning bolt).

3. Double-click the EditCommand event. This will switch you to the Code Editor.

4. Enter the following code for the EditCommand handler:

   private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls
   .DataGridCommandEventArgs e)
   {
     DataGrid1.EditItemIndex = e.Item.ItemIndex;
     BindGrid();
   }
   

Procedure 13.6. VB.NET Steps

1. In the Class Name drop-down list that appears at the top-left of the Code Editor, select DataGrid1.

2. In the Method Name drop-down list that appears at the top-right of the Code Editor, select the EditCommand event. This will add a new EditCommand handler to the Code Editor.

3. Enter the following code for the EditCommand handler:

   Private Sub DataGrid1_EditCommand(ByVal source As Object, ByVal e As System.Web.UI
   .WebControls.DataGridCommandEventArgs) Handles DataGrid1.EditCommand
     DataGrid1.EditItemIndex = e.Item.ItemIndex
     BindGrid()
   End Sub
   

Procedure 13.7. C# Steps

1. Switch back to the Designer by selecting Designer from the View menu.

2. In the Properties window, select the DataGrid and click the Events icon (the lightning bolt) that appears at the top of the Properties window.

3. Double-click next to the CancelCommand event. This will switch you back to the Code Editor.

4. Enter the following code for the CancelCommand event:

   private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls
   .DataGridCommandEventArgs e)
   {
     DataGrid1.EditItemIndex = -1;
     BindGrid();
   }
   

Procedure 13.8. VB.NET Steps

1. In the Class Name drop-down list, select the DataGrid control.

2. In the Method Name drop-down list, select the CancelCommand event. This will add a CancelCommand handler to the Code Editor.

3. Enter the following code for the CancelCommand handler:

   Private Sub DataGrid1_CancelCommand(ByVal source As Object, ByVal e As System.Web.UI
   .WebControls.DataGridCommandEventArgs) Handles DataGrid1.CancelCommand
     DataGrid1.EditItemIndex = -1
     BindGrid()
   End Sub
   

1. Switch back to the Designer by selecting Designer from the View menu.

2. Add a SqlCommand object to the page.

3. In the Properties window, select the SqlCommand object.

4. In the Properties window, double-click next to Connection property to assign sqlConnection1 as the value of the Connection property.

5. In the Properties window, enter the following code for the CommandText property:

   UPDATE Products
   SET ProductName = @ProductName, UnitPrice = @UnitPrice
   WHERE (ProductID = @ProductID)
   

Procedure 13.9. C# Steps

1. In the Properties window, select the DataGrid and click the Events icon (the lightning bolt).

2. Double-click next to the UpdateCommand event. This will switch you back to the Code Editor.

3. Enter the following code for the UpdateCommand handler:

   private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls
   .DataGridCommandEventArgs e)
   {
     // Retrieve TextBox Controls from DataGrid
     TextBox txtProductName = (TextBox)e.Item.Cells[2].Controls[0];
     TextBox txtUnitPrice = (TextBox)e.Item.Cells[3].Controls[0];
   
     // Assign Parameters to SqlCommand
     sqlCommand1.Parameters["@ProductName"].Value= txtProductName.Text;
     sqlCommand1.Parameters["@UnitPrice"].Value = txtUnitPrice.Text;
     sqlCommand1.Parameters["@ProductID"].Value = DataGrid1.DataKeys[ e.Item.ItemIndex ];
   
     // Execute SqlCommand
     sqlConnection1.Open();
     sqlCommand1.ExecuteNonQuery();
   
     // Deselect Row for Editing
     DataGrid1.EditItemIndex = -1;
     BindGrid();
     sqlConnection1.Close();
   }
   

4. Right-click the EditGrid.aspx page in Solution Explorer and select Build and Browse.

Procedure 13.10. VB.NET Steps

1. Double-click the Designer surface to switch back to the Code Editor.

2. Select DataGrid1 from the Class Name drop-down list that appears at the top left of the Code Editor.

3. Select the UpdateCommand event from the Method Name drop-down list that appears at the top right of the Code Editor. This will add an UpdateCommand event handler.

4. Enter the following code for the UpdateCommand handler:

   Private Sub DataGrid1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI
   .WebControls.DataGridCommandEventArgs) Handles DataGrid1.UpdateCommand
     ' Retrieve TextBox Controls from DataGrid
     Dim txtProductName As TextBox
     Dim txtUnitPrice As TextBox
     txtProductName = CType(e.Item.Cells(2).Controls(0), TextBox)
     txtUnitPrice = CType(e.Item.Cells(3).Controls(0), TextBox)
   
     ' Assign Parameters to SqlCommand
     SqlCommand1.Parameters("@ProductName").Value = txtProductName.Text
     SqlCommand1.Parameters("@UnitPrice").Value = txtUnitPrice.Text
     SqlCommand1.Parameters("@ProductID").Value = DataGrid1.DataKeys(e.Item.ItemIndex)
   
     ' Execute SqlCommand
     SqlConnection1.Open()
     SqlCommand1.ExecuteNonQuery()
   
     ' Deselect Row for Editing
     DataGrid1.EditItemIndex = -1
     BindGrid()
     SqlConnection1.Close()
   End Sub
   

5. Right-click the EditGrid.aspx page in the Solution Explorer window and select Build and Browse.

1. Right-click the DataGrid control on the Designer surface, select Property Builder, and click the Columns tab.

2. In the Available Columns panel, expand Button Columns, select the Delete column, and copy the Delete column over to the Selected columns panel.

3. Move the Delete column to the top of the list in the Selected columns panel by clicking the up arrow.

4. Click OK to close the Property Builder dialog box.

1. Add a new SqlCommand object to the page.

2. In the Properties window, select the new SqlCommand.

3. Double-click next to the SqlCommand’s Connection property. This will assign the value sqlConnection1 to the Connection property.

4. Enter the following SQL Delete command for the CommandText property:

   DELETE FROM Products
   WHERE (ProductID = @ProductID)
   

Procedure 13.11. C# Steps

1. In the Properties window, select the DataGrid control and click the Events icon (the lightning bolt).

2. Double-click next to the DeleteCommand event. This will switch you to the Code Editor.

3. Enter the following code for the DeleteCommand handler:

   private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls
   .DataGridCommandEventArgs e)
   {
     sqlCommand2.Parameters[ "@ProductID" ].Value
        = DataGrid1.DataKeys[ e.Item.ItemIndex ];
     sqlConnection1.Open();
     sqlCommand2.ExecuteNonQuery();
     BindGrid();
     sqlConnection1.Close();
   }
   

4. Right-click the EditGrid.aspx page in the Solution Explorer window and select Build and Browse.

Procedure 13.12. VB.NET Steps

1. Double-click the Designer surface to switch to the Code Editor.

2. From the Class Name drop-down list that appears at the top left of the Code Editor, select DataGrid1.

3. From the Method Name drop-down list that appears at the top right of the Code Editor, select DeleteCommand. This will add a DeleteCommand handler to the Code Editor.

4. Enter the following code for the DeleteCommand handler:

   Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI
   .WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand
     SqlCommand2.Parameters("@ProductID").Value = DataGrid1.DataKeys(e.Item.ItemIndex)
     SqlConnection1.Open()
     SqlCommand2.ExecuteNonQuery()
     BindGrid()
     SqlConnection1.Close()
   End Sub
   

5. Right-click the EditGrid.aspx page in the Solution Explorer and select Build and Browse.

1. In the Properties window, select Document.

2. Assign the value True to the smartNavigation property.

1. Add a Web Form Page to your project named EditTemplate.aspx.

2. Drag and drop the Products database table from the Server Explorer window onto the Designer surface.

3. Add an Untyped DataSet to the page.

4. Drag and drop the Categories database table from the Server Explorer window onto the Designer surface.

5. Add a second Untyped DataSet to the page.

1. Add a DataGrid control to the page.

2. Right-click the DataGrid, select Property Builder, and click the Columns tab.

3. Uncheck the Create Columns Automatically at Run Time check box.

4. Add an Edit, Update, Cancel column by expanding Button Column in the Available columns panel, selecting the Edit, Update, Cancel column, and moving it to the Selected columns panel.

5. Add the following two Template Columns to the Selected columns panel:

   • Header text

   • Name

   • Category

6. Click OK to close the Property Builder dialog box.

7. Right-click the DataGrid and select Auto Format. Select the Professional 1 scheme and click OK.

1. Switch to HTML View by clicking the HTML tab at the bottom left of the Designer.

2. Find the DataGrid tag in the HTML source.

3. Inside the DataGrid tag, add the following code to the first TemplateColumn:

   <asp:TemplateColumn HeaderText="Name">
   
   <ItemTemplate>
     <%# DataBinder.Eval( Container, "DataItem.ProductName" )%>
   </ItemTemplate>
   
   <EditItemTemplate>
     <asp:TextBox
       ID="txtProductName"
       Text='<%# DataBinder.Eval( Container, "DataItem.ProductName" )%>'
       runat="server"/>
     <asp:RequiredFieldValidator
       ControlToValidate="txtProductName"
       Text="*"
       Runat="server"/>
   </EditItemTemplate>
   
   </asp:TemplateColumn>
   

4. Inside the DataGrid tag, add the following code to the second TemplateColumn:

   <asp:TemplateColumn HeaderText="Category">
   
   <ItemTemplate>
     <%# ShowCategory( DataBinder.Eval( Container, "DataItem.CategoryID" ) )%>
   </ItemTemplate>
   
   <EditItemTemplate>
     <asp:DropDownList
       id="dropCategory"
       DataSource='<%# dataSet2 %>'
       SelectedIndex='<%# SelectCategory( DataBinder.Eval( Container, "DataItem.CategoryID" )
    )%>'
       DataTextField='CategoryName'
       DataValueField='CategoryID'
       Runat="server" />
   </EditItemTemplate>
   
   </asp:TemplateColumn>
   

1. Switch to the Code Editor by double-clicking the Designer surface.

2. Type the following method (ShowCategory()) into the Code Editor:

   C#. 

   public string ShowCategory(object CategoryID )
   {
     if (CategoryID==DBNull.Value)
       return String.Empty;
     DataRow[] drows =
       dataSet2.Tables[0].Select("CategoryID=" + CategoryID);
     return (string)drows[0]["CategoryName"];
   }
   

   VB.NET. 

   Function ShowCategory(ByVal CategoryID As Object) As String
     Dim drows() As DataRow
   
     If IsDBNull(CategoryID) Then
       Return String.Empty
     End If
     drows = DataSet2.Tables(0).Select("CategoryID=" & CategoryID)
     Return drows(0)("CategoryName")
   End Function
   

3. Type the following method (SelectCategory()) into the Code Editor:

   C#. 

   public int SelectCategory(object CategoryID )
   {
     DataTable dtblCategories = dataSet2.Tables[0];
     for (int i = 0;i < dtblCategories.Rows.Count;i++)
       if ((int)dtblCategories.Rows[i]["CategoryID"] == (int)CategoryID )
         return i;
     return 0;
   }
   

   VB.NET. 

   Function SelectCategory(ByVal CategoryID As Object) As Integer
     Dim i As Integer
     Dim dtblCategories = DataSet2.Tables(0)
     For i = 0 To dtblCategories.Rows.Count - 1
       If dtblCategories.Rows(i)("CategoryID") = CategoryID Then
         Return i
       End If
     Next
     Return 0
   End Function
   

1. Enter the following code for the Page_Load handler:

   C#. 

   private void Page_Load(object sender, System.EventArgs e)
   {
     if (!Page.IsPostBack)
       BindGrid();
   }
   

   VB.NET. 

   Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
    MyBase.Load
     If Not Page.IsPostBack Then
       BindGrid()
     End If
   End Sub
   

2. Enter the following BindGrid() method below the Page_Load handler:

   C#. 

   void BindGrid()
   {
     sqlDataAdapter1.Fill( dataSet1 );
     sqlDataAdapter2.Fill( dataSet2 );
     DataGrid1.DataSource = dataSet1;
     DataGrid1.DataKeyField = "ProductID";
     DataGrid1.DataBind();
   }
   

   VB.NET. 

   Sub BindGrid()
     SqlDataAdapter1.Fill(DataSet1)
     SqlDataAdapter2.Fill(DataSet2)
     DataGrid1.DataSource = DataSet1
     DataGrid1.DataKeyField = "ProductID"
     DataGrid1.DataBind()
   End Sub
   

Procedure 13.13. C# Steps

1. Switch back to the Designer by selecting Designer from the View menu.

2. In the Properties window, select the DataGrid control and click the Events icon (the lightning bolt).

3. Double-click next to the EditCommand event. This will switch you back to the Code Editor.

4. Enter the following code for the EditCommand handler:

   private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls
   .DataGridCommandEventArgs e)
   {
     DataGrid1.EditItemIndex = e.Item.ItemIndex;
     BindGrid();
   }
   

5. Switch back to the Designer by selecting Designer from the View menu.

6. In the Properties window, select the DataGrid control and click the Events icon.

7. Double-click next to the CancelCommand event. This will switch you back to the Code Editor.

8. Enter the following code for the CancelCommand handler:

   private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls
   .DataGridCommandEventArgs e)
   {
     DataGrid1.EditItemIndex = -1;
     BindGrid();
   }
   

Procedure 13.14. VB.NET Steps

1. Select DataGrid1 from the Class Name drop-down list that appears at the top left of the Code Editor.

2. Select EditCommand from the Method Name drop-down list that appears at the top-right of the Code Editor. This will add an EditCommand handler to the Code Editor.

3. Enter the following code for the EditCommand handler:

   Private Sub DataGrid1_EditCommand(ByVal source As Object, ByVal e As System.Web.UI
   .WebControls.DataGridCommandEventArgs) Handles DataGrid1.EditCommand
     DataGrid1.EditItemIndex = e.Item.ItemIndex
     BindGrid()
   End Sub
   

4. Select DataGrid1 from the Class Name drop-down list that appears at the top-left of the Code Editor.

5. Select CancelCommand from the Method Name drop-down list that appears at the top-right of the Code Editor. This will add a CancelCommand handler to the Code Editor.

6. Enter the following code for the CancelCommand handler:

   Private Sub DataGrid1_CancelCommand(ByVal source As Object, ByVal e As System.Web.UI
   .WebControls.DataGridCommandEventArgs) Handles DataGrid1.CancelCommand
     DataGrid1.EditItemIndex = -1
     BindGrid()
   End Sub
   

1. Switch back to the Designer by selecting Designer from the View menu.

2. Drag an SqlCommand object from under the Data tab in the Toolbox onto the Designer surface.

3. In the Properties window, select the SqlCommand object.

4. Double-click next to the Connection property. This will assign sqlConnection1 to the Connection property.

5. Enter the following SQL Update command for the CommandText property:

   UPDATE Products
   SET ProductName = @ProductName, CategoryID = @CategoryID
   WHERE (ProductID = @ProductID)
   

Procedure 13.15. C# Steps

1. In the Properties window, select the DataGrid1 control and click the Events icon (the lightning bolt).

2. Double-click next to the UpdateCommand event. This will switch you to the Code Editor.

3. Enter the following code for the UpdateCommand handler:

   private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls
   .DataGridCommandEventArgs e)
   {
   // Retrieve the Template TextBox Controls
   TextBox txtProductName = (TextBox)e.Item.FindControl( "txtProductName" );
   DropDownList dropCategory = (DropDownList)e.Item.FindControl( "dropCategory" );
   
   // Initialize SqlCommand Parameters
   sqlCommand1.Parameters[ "@ProductName" ].Value = txtProductName.Text;
   sqlCommand1.Parameters["@CategoryID" ].Value = dropCategory.SelectedItem.Value;
   sqlCommand1.Parameters["@ProductID" ].Value = DataGrid1.DataKeys[ e.Item.ItemIndex ];
   
   // Execute SqlCommand
   sqlConnection1.Open();
   sqlCommand1.ExecuteNonQuery();
   
   // Deselect Current Row for Editing
   DataGrid1.EditItemIndex = -1;
   BindGrid();
   sqlConnection1.Close();
   }
   

4. Right-click the EditTemplate.aspx page in the Solution Explorer window and select Build and Browse.

Procedure 13.16. VB.NET Steps

1. Double-click the Designer surface to switch to the Code Editor.

2. Select DataGrid1 from the Class Name drop-down list located at the top-left of the Code Editor.

3. Select UpdateCommand from the Method Name drop-down list located at the top-right of the Code Editor. This will add the UpdateCommand event handler.

4. Enter the following code for the UpdateCommand handler:

   Private Sub DataGrid1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI
   .WebControls.DataGridCommandEventArgs) Handles DataGrid1.UpdateCommand
     ' Retrieve the Template TextBox Controls
     Dim txtProductName As TextBox
     Dim dropCategory As DropDownList
     txtProductName = CType(e.Item.FindControl("txtProductName"), TextBox)
     dropCategory = CType(e.Item.FindControl("dropCategory"), DropDownList)
   
     ' Initialize SqlCommand Parameters
     SqlCommand1.Parameters("@ProductName").Value = txtProductName.Text
     SqlCommand1.Parameters("@CategoryID").Value = dropCategory.SelectedItem.Value
     SqlCommand1.Parameters("@ProductID").Value = DataGrid1.DataKeys(e.Item.ItemIndex)
   
     ' Execute SqlCommand
     SqlConnection1.Open()
     SqlCommand1.ExecuteNonQuery()
   
     ' Deselect Current Row for Editing
     DataGrid1.EditItemIndex = -1
     BindGrid()
     SqlConnection1.Close()
   End Sub
   

5. Right-click the EditTemplate.aspx page in the Solution Explorer window and select Build and Browse.