Displaying Empty Data 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">
    <title>Show Empty Data Text</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>

    <asp:DetailsView
        id="dtlProducts"
        DataSourceID="srcProducts"
        EmptyDataText="<b>No Matching Record!</b>"
        Runat="server" />

    <asp:SqlDataSource
        id="srcProducts"
        ConnectionString="<%$ ConnectionStrings:Products %>"
        SelectCommand="SELECT Id,Title,Director,InStock FROM Products
            WHERE Id=-1"
        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.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