Inserting a record with the DetailsView control. : DetailsView « Data Binding « ASP.NET Tutorial






<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
  "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <script type="text/javascript">
        function showInsert()
        {
            var divInsert = document.getElementById('divInsert');
            divInsert.style.display = 'block';
        }
    </script>
    <title>Show Insert Mode</title>
</head>
<body>
    <form id="form1" runat="server">
    <div id="divDisplay">
    <asp:GridView
        id="grdProducts"
        DataSourceID="srcProducts"
        Runat="server" />
    <br />
    <a href="JavaScript:showInsert();">Insert Product</a>
    </div>
    <div id="divInsert">
    <h1>Insert Product</h1>
    <asp:DetailsView
        id="dtlProducts"
        DataSourceID="srcProducts"
        AutoGenerateInsertButton="true"
        AutoGenerateRows="false"
        DefaultMode="Insert"
        Runat="server">
        <Fields>
        <asp:BoundField
            DataField="Title"
            HeaderText="Title:" />
        <asp:BoundField
            DataField="Director"
            HeaderText="Director:" />
        <asp:CheckBoxField
            DataField="InStock"
            HeaderText="In Stock:" />
        </Fields>
    </asp:DetailsView>
    </div>

    <asp:SqlDataSource
        id="srcProducts"
        ConnectionString="<%$ ConnectionStrings:Products %>"
        SelectCommand="SELECT Title,Director,InStock FROM Products"
        InsertCommand="INSERT Products (Title,Director,InStock)
            VALUES (@Title,@Director,
        Runat="server" />

    </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.12.DetailsView
19.12.1.Using DetailsView
19.12.2.Link asp:DetaisView with asp:SqlDataSource
19.12.3.Bind a DetailsView control programmatically to a data source
19.12.4.Using BoundFields with the DetailsView control.
19.12.5.Displaying Empty Data with the DetailsView Control
19.12.6.Displaying content when no results are returned.
19.12.7.Paging Through Data with the DetailsView Control
19.12.8.Customizing the Paging Interface
19.12.9.Inserting a record with the DetailsView control.
19.12.10.Format DetailsView