Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 25th, 2012  |  syntax: None  |  size: 1.83 KB  |  hits: 13  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. ASP.NET Gridview - On load the first row is missing
  2. <cc1:myGridview ID="mgvTESTs" runat="server" AutoGenerateColumns="False"
  3.     DataSourceID="odsTESTs" >
  4.     <Columns>
  5.         <asp:TemplateField HeaderText="USER" SortExpression="USER">
  6.             <ItemTemplate>
  7.                 <div class="zeile BtnZeile">
  8.                     <asp:Label ID="lUSER" runat="server" />
  9.                 </div>
  10.             </ItemTemplate>
  11.         </asp:TemplateField>
  12.         <asp:TemplateField HeaderText="TEST" SortExpression="TEST">
  13.             <ItemTemplate>
  14.                 <asp:Label ID="lTEST" runat="server" Text='<%# Bind("TEST") %>' />
  15.             </ItemTemplate>
  16.         </asp:TemplateField>
  17.         <asp:TemplateField HeaderText="Bid" SortExpression="BID">
  18.             <ItemTemplate>
  19.                 <asp:Label ID="lBID" runat="server" Text='<%# Bind("BID") %>' />
  20.             </ItemTemplate>
  21.         </asp:TemplateField>
  22.         <asp:TemplateField HeaderText="DATER" SortExpression="DATER">
  23.             <ItemTemplate>
  24.                 <asp:Label ID="lDATER" runat="server" Text='<%# Bind("DATER") %>' />
  25.             </ItemTemplate>
  26.         </asp:TemplateField>
  27.         <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" SortExpression="ID"
  28.             Visible="False" />
  29.     </Columns>
  30. </cc1:myGridview>
  31. <asp:ObjectDataSource ID="odsTESTs" runat="server" SelectMethod="SQLSelectQuery"
  32.     TypeName="ObjectDataSource_DataBoundControl">
  33.     <SelectParameters>
  34.         <asp:Parameter Name="SqlCommand" DefaultValue="Select ID,
  35.     TEST,
  36.     BID,
  37.     DATER
  38. FROM
  39.     ABC_TESTs
  40. WHERE DATER >= '@param1' AND  DATER < '@param2'
  41. ORDER BY DATER DESC" />
  42.  <asp:SessionParameter Name="param1" Type="String" DefaultValue="01-01-2011"/>
  43.         <asp:SessionParameter Name="param2" Type="String" DefaultValue="01-01-2011"/>
  44.     </SelectParameters>
  45. </asp:ObjectDataSource>