mandag den 8. juni 2015

Sql select statement where is empty null

  1. <%@ Page Language="C#" AutoEventWireup="true" %>  
  2.   
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
  4. <script runat="server">  
  5.       
  6. </script>  
  7. <html xmlns="http://www.w3.org/1999/xhtml" >  
  8. <head id="Head1" runat="server">  
  9.     <title>Using CancelSelectOnNullParameter property in SqlDataSource in asp.net</title>  
  10. </head>  
  11. <body>  
  12.     <form id="form1" runat="server">  
  13.     <div>  
  14.         <h2 style="color:Navy; font-style:italic;">SqlDataSource Example: using CancelSelectOnNullParameter Property</h2>  
  15.         <asp:SqlDataSource   
  16.             ID="SqlDataSource1"  
  17.             runat="server"  
  18.             ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"  
  19.             SelectCommand="Select CategoryID, CategoryName From Categories"  
  20.             >  
  21.         </asp:SqlDataSource>  
  22.         <asp:DropDownList   
  23.             ID="DropDownList1"  
  24.             runat="server"  
  25.             DataSourceID="SqlDataSource1"  
  26.             DataValueField="CategoryID"  
  27.             DataTextField="CategoryName"  
  28.             AppendDataBoundItems="true"  
  29.             AutoPostBack="true"  
  30.             >  
  31.             <asp:ListItem Text="All" Value=""></asp:ListItem>  
  32.         </asp:DropDownList>  
  33.         <asp:SqlDataSource   
  34.             ID="SqlDataSource2"  
  35.             runat="server"  
  36.             ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"  
  37.             SelectCommand="Select ProductID, ProductName, QuantityPerUnit, UnitPrice From Products Where CategoryID=IsNull(@CategoryID, CategoryID)"  
  38.             SelectCommandType="Text"  
  39.             CancelSelectOnNullParameter="false"  
  40.             >  
  41.             <SelectParameters>  
  42.                 <asp:ControlParameter   
  43.                     Name="CategoryID"   
  44.                     ControlID="DropDownList1"   
  45.                     PropertyName="SelectedValue"  
  46.                     ConvertEmptyStringToNull="true"  
  47.                     />  
  48.             </SelectParameters>  
  49.         </asp:SqlDataSource>  
  50.         <asp:GridView   
  51.             ID="GridView1"  
  52.             runat="server"  
  53.             DataSourceID="SqlDataSource2"  
  54.             AutoGenerateColumns="true"  
  55.             AllowPaging="true"  
  56.             PageSize="10"  
  57.             BorderColor="Snow"  
  58.             Font-Names="Comic Sans MS"  
  59.             Width="650"  
  60.             >  
  61.             <HeaderStyle   
  62.                 BackColor="DarkGoldenrod"   
  63.                 BorderColor="PeachPuff"   
  64.                 ForeColor="Snow"   
  65.                 Height="45"/>  
  66.             <RowStyle   
  67.                 BackColor="Chocolate"   
  68.                 ForeColor="Snow"   
  69.                 Font-Italic="true" />  
  70.             <PagerStyle   
  71.                 Height="45"   
  72.                 HorizontalAlign="Right"   
  73.                 BackColor="OrangeRed"  
  74.                 Font-Bold="true"  
  75.                 Font-Size="X-Large"  
  76.                 ForeColor="Snow"  
  77.                 />  
  78.             <PagerSettings Mode="Numeric" />  
  79.         </asp:GridView>  
  80.     </div>  
  81.     </form>  
  82. </body>  
  83. </html>  

http://asp-net-example.blogspot.in/2009/10/using-cancelselectonnullparameter.html
Indsendt af kl. Ingen kommentarer:
Abonner på: Kommentarer (Atom)