Editing Database Data : ListView « Data Binding « ASP.NET Tutorial






  1. ASP.NET Tutorial
  2. Data Binding
  3. ListView
<%@ Page Language="C#" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<style type="text/css">

    .product
    {
       border: solid 1px black;
       padding:5px;
       margin:3px;
    }

    .edit
    {
        background-color:lightyellow;
    }

</style>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Edit ListView</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>

        <asp:ListView
            ID="lstProducts"
            DataSourceId="srcProducts"
            DataKeyNames="Id"
            runat="server">
            <LayoutTemplate>
                <asp:Placeholder
                    id="itemPlaceholder"
                    runat="server" />
            </LayoutTemplate>
            <ItemTemplate>
                <div class="product">
                <strong><%# Eval("Title") %></strong>
                <br />
                <em>Directed by <%# Eval("Director") %></em>
                <br />
                <asp:LinkButton
                    id="lnkEdit"
                    Text="{Edit}"
                    CommandName="Edit"
                    Runat="server" />
                <asp:LinkButton
                    id="lnkDelete"
                    Text="{Delete}"
                    CommandName="Delete"
                    OnClientClick="return confirm('Delete this product?')"
                    Runat="server" />
                </div>
            </ItemTemplate>
            <EditItemTemplate>
                <div class="product edit">
                <asp:Label
                    id="lblTitle"
                    Text="Title:"
                    AssociatedControlID="txtTitle"
                    Runat="server" />
                <br />
                <asp:TextBox
                    id="txtTitle"
                    Text='<%# Bind("Title") %>'
                    Runat="server" />

                <br /><br />

                <asp:Label
                    id="lblDirector"
                    Text="Director:"
                    AssociatedControlID="txtDirector"
                    Runat="server" />
                <br />
                <asp:TextBox
                    id="txtDirector"
                    Text='<%# Bind("Director") %>'
                    Runat="server" />

                <br /><br />
                <asp:LinkButton
                    id="lnkUpdate"
                    Text="Save"
                    CommandName="Update"
                    Runat="server" />
                <asp:LinkButton
                    id="lnkCancel"
                    Text="Cancel"
                    CommandName="Cancel"
                    Runat="server" />
                </div>
            </EditItemTemplate>
        </asp:ListView>

        <asp:SqlDataSource
            id="srcProducts"
            SelectCommand="SELECT Id, Title, Director FROM Product"
            UpdateCommand="Update Product SET Title=@Title, Director=@Director
                WHERE Id=@Id"
            DeleteCommand="Delete Product WHERE Id=@Id"
            ConnectionString='<%$ ConnectionStrings:con %>'
            Runat="server" />

    </div>
    </form>
</body>
</html>

File: Web.config

<configuration>
  <connectionStrings>
    <add name="Products" 
         connectionString="Data Source=.\SQLEXPRESS;
         AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" />
  </connectionStrings>
</configuration>








19.21.ListView
19.21.1.Using the LayoutTemplate and ItemTemplate
19.21.2.Use a ListView control to render an HTML table.
19.21.3.Displaying a photo gallery with a ListView control.
19.21.4.Selecting a Row
19.21.5.Sorting data with the ListView control.
19.21.6.Editing Database Data
19.21.7.Inserting new records with the ListView control.
19.21.8.Using a DataPager control with the ListView control.
19.21.9.Creating a Custom User Interface for Paging