radgrid master-detail with full editing

5 posts, 0 answers
  1. Erik
    Erik avatar
    314 posts
    Member since:
    Feb 2008

    Posted 05 Nov 2008 Link to this post

    Hi all,

    I have a grid with a sub grid. All works wel, except the detail grid will not insert, update or delete. I can select edit, I'm getting a popup edit, but when I click update, the record is not being updated. No errors. The event "ItemCommand" triggers, and thats it! nothing else, no other events, not from the grid as the datasource.

    I've tried (among other 1000 things) to use the detail datasource on a single grid, and there are no problems.

    In the example:
    http://demos.telerik.com/aspnet/prometheus/Grid/Examples/DataEditing/ThreeLevel/DefaultVB.aspx


    it seems a piece of cake... I've copied all the properties edc.. It is costing mne hours and still nothing...

    do I need to set other properties? Is detail editing not supported this way?
  2. Kevin Babcock
    Kevin Babcock avatar
    189 posts
    Member since:
    Mar 2007

    Posted 05 Nov 2008 Link to this post

    Hello Proovit,

    Would you mind posting your code here so that I can get a better idea of what you might be doing wrong?

    Thanks,
    Kevin Babcock
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Princy
    Princy avatar
    17421 posts
    Member since:
    Mar 2007

    Posted 05 Nov 2008 Link to this post

    Hello Proovit,

    Have you set the AllowAutomaticUpdates to true for the DetailTable. If not, try setting it to true and see if it works.
    aspx:
    <telerik:RadGrid ID="RadGrid1" AutoGenerateColumns="false" runat="server">              
      <MasterTableView EditMode="EditForms" Name="Master">       
       <DetailTables> 
        <telerik:GridTableView AllowAutomaticUpdates="true" Name="Detail" DataSourceID="SqlDataSource1" runat="server" > 
         <Columns> 
          ...... 

    Thanks
    Princy.
  5. Erik
    Erik avatar
    314 posts
    Member since:
    Feb 2008

    Posted 06 Nov 2008 Link to this post

    Hello Kevin & Princy,

    Thanks for your responces. Yes, i used "AllowAutomaticUpdates" aswel as "AllowAutomaticDeleted" and "AllowAutomaticInserts" both on the master as the detail.

    Here is the code:

    1 <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default7.aspx.vb" Inherits="Default7" %> 
    2  
    3 <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> 
    4  
    5 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
    6  
    7 <html xmlns="http://www.w3.org/1999/xhtml">  
    8     <head runat="server">  
    9         <title>Untitled Page</title> 
    10     </head> 
    11     <body> 
    12         <form id="form1" runat="server">  
    13             <div> 
    14                 <telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager> 
    15       
    16         <telerik:RadGrid ID="RadGrid_Release" runat="server" AutoGenerateColumns="False"   
    17             DataSourceID="SqlDataSource_Release" GridLines="None" Skin="Office2007">  
    18             <MasterTableView DataKeyNames="Releasenummer" DataSourceID="SqlDataSource_Release" EditMode="PopUp" CommandItemDisplay="TopAndBottom" Name="Master" 
    19                              CommandItemSettings-AddNewRecordText="New Release" AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticUpdates="true" > 
    20                 <RowIndicatorColumn> 
    21                     <HeaderStyle Width="20px"></HeaderStyle> 
    22                 </RowIndicatorColumn> 
    23  
    24                 <ExpandCollapseColumn> 
    25                     <HeaderStyle Width="20px"></HeaderStyle> 
    26                 </ExpandCollapseColumn> 
    27                   
    28                 <DetailTables> 
    29                     <telerik:GridTableView DataSourceID="SqlDataSource_Stem" DataKeyNames="Stemaanvraagnummer" Caption="Stem for this release" 
    30                         Name="Detail_Stem" CommandItemDisplay="TopAndBottom" EditMode="PopUp" CommandItemSettings-AddNewRecordText="New Stem"   
    31                         AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticUpdates="true" ShowFooter="true" > 
    32                         <ParentTableRelation> 
    33                             <telerik:GridRelationFields DetailKeyField="Releasenummer" MasterKeyField="Releasenummer" /> 
    34                         </ParentTableRelation> 
    35                         <RowIndicatorColumn> 
    36                             <HeaderStyle Width="20px"></HeaderStyle> 
    37                         </RowIndicatorColumn> 
    38  
    39                         <ExpandCollapseColumn> 
    40                             <HeaderStyle Width="20px"></HeaderStyle> 
    41                         </ExpandCollapseColumn> 
    42                           
    43                         <Columns> 
    44                             <telerik:GridEditCommandColumn ButtonType="ImageButton"></telerik:GridEditCommandColumn> 
    45                             <telerik:GridButtonColumn CommandName="Delete" Text="Delete" ButtonType="ImageButton"></telerik:GridButtonColumn> 
    46  
    47                             <telerik:GridBoundColumn DataField="Status" HeaderText="Status" SortExpression="Status" UniqueName="Status" HeaderStyle-Width="40px">  
    48                             </telerik:GridBoundColumn> 
    49                               
    50                             <telerik:GridBoundColumn DataField="Tons" DataType="System.Int32" DataFormatString="{0:N0}" HeaderText="Tons" SortExpression="Tons"   
    51                                 UniqueName="Tons" HeaderStyle-HorizontalAlign="Right" ItemStyle-HorizontalAlign="Right" Aggregate="Sum" > 
    52                             </telerik:GridBoundColumn> 
    53  
    54                             <telerik:GridBoundColumn DataField="Klantreferentie1" HeaderText="Ref. 1" SortExpression="Klantreferentie1" UniqueName="Klantreferentie1"></telerik:GridBoundColumn> 
    55                             <telerik:GridBoundColumn DataField="Klantreferentie2" HeaderText="Ref. 2" SortExpression="Klantreferentie2" UniqueName="Klantreferentie2"></telerik:GridBoundColumn> 
    56                             <telerik:GridBoundColumn DataField="Klantreferentie3" HeaderText="Ref. 3" SortExpression="Klantreferentie3" UniqueName="Klantreferentie3"></telerik:GridBoundColumn> 
    57  
    58                             <telerik:GridBoundColumn DataField="Stemaanvraagnummer" DataType="System.Int32" HeaderText="{ID}" SortExpression="Stemaanvraagnummer"   
    59                                 UniqueName="Stemaanvraagnummer" HeaderStyle-Width="40px" HeaderStyle-ForeColor="Red" ItemStyle-ForeColor="Red">  
    60                             </telerik:GridBoundColumn> 
    61                             <telerik:GridBoundColumn DataField="Releasenummer" DataType="System.Int32" HeaderText="{ReID}" SortExpression="Releasenummer"   
    62                                 UniqueName="Releasenummer" HeaderStyle-Width="40px" HeaderStyle-ForeColor="Red" ItemStyle-ForeColor="Red">  
    63                             </telerik:GridBoundColumn> 
    64                         </Columns> 
    65                         <CommandItemSettings /> 
    66                   
    67                         <EditFormSettings EditFormType="Template" CaptionFormatString="Stem Entry" > 
    68                             <PopUpSettings Modal="true" ScrollBars="Auto" Height="400px" Width="800px" /> 
    69                             <EditColumn UniqueName="EditCommandColumn1"></EditColumn> 
    70  
    71                             <FormStyle BackColor="#ECFED8" /> 
    72                             <FormTemplate> 
    73                                 <table id="Table1" cellspacing="1" cellpadding="1" width="90%" border="0">  
    74                                     <tr> 
    75                                         <td></td>  
    76                                         <td></td>  
    77                                         <td></td>  
    78                                         <td></td>  
    79                                         <td></td>  
    80                                         <td></td>  
    81                                     </tr> 
    82                                     <tr> 
    83                                         <td><asp:Label ID="lbl_Ton" runat="server" Text="Tons" AssociatedControlID="txt_Tons" /></td><td>:</td> 
    84                                         <td> 
    85                                             <telerik:RadNumericTextBox ID="txt_Tons" runat="server" Type="Number" MaxValue="99999999" MinValue="0" MaxLength="8" ShowSpinButtons="True" NumberFormat-DecimalDigits="0" Skin="Office2007" DbValue='<%# Bind("Tons") %>'></telerik:RadNumericTextBox> 
    86                                         </td> 
    87                                         <td></td>  
    88                                         <td></td>  
    89                                         <td style="text-align:right; "><%#Eval("Stemaanvraagnummer")%>/<%#Eval("Releasenummer")%></td>  
    90                                     </tr> 
    91  
    92                                     <tr> 
    93                                         <td><asp:Label ID="lbl_Grade" runat="server" Text="Grade" AssociatedControlID="ddl_Grade" /></td><td>:</td> 
    94                                         <td> 
    95                                             <telerik:RadComboBox ID="ddl_Grade" Runat="server" AutoCompleteSeparator="|" 
    96                                                 DataSourceID="SqlDataSource_PartijLading" DataTextField="lading_soort_Desc" 
    97                                                 DataValueField="LADINGNUMMER" DropDownWidth="200px" 
    98                                                 EmptyMessage="(select)" EnableVirtualScrolling="True" 
    99                                                 Filter="Contains" NoWrap="True" Skin="Office2007" AppendDataBoundItems="true" 
    100                                                 SortCaseSensitive="False" SelectedValue='<%# Bind("Ladingnummer") %>' > 
    101                                                 <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
    102                                                 <Items> 
    103                                                     <telerik:RadComboBoxItem Text="(select)" Value="<%# DBNull.Value %>" /> 
    104                                                 </Items> 
    105                                             </telerik:RadComboBox> 
    106                                         </td> 
    107                                     </tr> 
    108                                       
    109                                     <tr> 
    110                                         <td><asp:Label ID="lbl_Operator" runat="server" Text="operator" AssociatedControlID="ddl_Agent" /></td><td>:</td> 
    111                                         <td> 
    112                                             <telerik:RadComboBox ID="ddl_Agent" Runat="server" AutoCompleteSeparator="|" 
    113                                                 DataSourceID="SqlDataSource_Agent1" DataTextField="Naam" 
    114                                                 DataValueField="FIRMA_ID" DropDownWidth="200px" 
    115                                                 EmptyMessage="<No agents available>" EnableVirtualScrolling="True" 
    116                                                 Filter="Contains" NoWrap="True" Skin="Office2007" AppendDataBoundItems="true" 
    117                                                 SortCaseSensitive="False" SelectedValue='<%# Bind("Agent") %>' > 
    118                                                 <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
    119                                                 <Items> 
    120                                                     <telerik:RadComboBoxItem Text="(select)" Value="<%# DBNull.Value %>" /> 
    121                                                     <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="NNB" /> 
    122                                                     <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="GEEN" /> 
    123                                                 </Items> 
    124                                             </telerik:RadComboBox> 
    125                                         </td> 
    126                                         <td><asp:Label ID="lbl_Klantreferentie1" runat="server" Text="Reference 1" AssociatedControlID="txt_Klantreferentie1" /></td><td>:</td> 
    127                                         <td><asp:TextBox ID="txt_Klantreferentie1" Text='<%# Bind("Klantreferentie1") %>' MaxLength="50" runat="server" /></td>  
    128                                     </tr> 
    129                                       
    130  
    131                                     <tr> 
    132                                         <td><asp:Label ID="lbl_IJker" runat="server" Text="gauger" AssociatedControlID="ddl_IJker" /></td><td>:</td> 
    133                                         <td> 
    134                                             <telerik:RadComboBox ID="ddl_IJker" Runat="server" AutoCompleteSeparator="|"   
    135                                                 DataSourceID="SqlDataSource_Agent3" DataTextField="Naam"   
    136                                                 DataValueField="FIRMA_ID" DropDownWidth="200px"   
    137                                                 EmptyMessage="<No agents available>" EnableVirtualScrolling="True"   
    138                                                 Filter="Contains" NoWrap="True" Skin="Office2007" AppendDataBoundItems="true"   
    139                                                 SortCaseSensitive="False" SelectedValue='<%# Bind("IJker") %>' > 
    140                                                 <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
    141                                                 <Items> 
    142                                                     <telerik:RadComboBoxItem Text="(select)" Value="<%# DBNull.Value %>" /> 
    143                                                     <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="NNB" /> 
    144                                                     <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="GEEN" /> 
    145                                                 </Items> 
    146                                             </telerik:RadComboBox> 
    147                                         </td> 
    148                                         <td><asp:Label ID="lbl_Klantreferentie2" runat="server" Text="Reference 2" AssociatedControlID="txt_Klantreferentie2" /></td><td>:</td> 
    149                                         <td><asp:TextBox ID="txt_Klantreferentie2" Text='<%# Bind("Klantreferentie2") %>' MaxLength="50" runat="server" /></td>  
    150                                     </tr> 
    151                                     <tr> 
    152                                         <td><asp:Label ID="lbl_Monsteraar" runat="server" Text="sampler" AssociatedControlID="ddl_Monsteraar" /></td><td>:</td> 
    153                                         <td> 
    154                                             <telerik:RadComboBox ID="ddl_Monsteraar" Runat="server" AutoCompleteSeparator="|"   
    155                                                 DataSourceID="SqlDataSource_Agent4" DataTextField="Naam"   
    156                                                 DataValueField="FIRMA_ID" DropDownWidth="200px"   
    157                                                 EmptyMessage="<No agents available>" EnableVirtualScrolling="True"   
    158                                                 Filter="Contains" NoWrap="True" Skin="Office2007" AppendDataBoundItems="true"   
    159                                                 SortCaseSensitive="False" SelectedValue='<%# Bind("Monsteraar") %>' > 
    160                                                 <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
    161                                                 <Items> 
    162                                                     <telerik:RadComboBoxItem Text="(select)" Value="<%# DBNull.Value %>" /> 
    163                                                     <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="NNB" /> 
    164                                                     <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="GEEN" /> 
    165                                                 </Items> 
    166                                             </telerik:RadComboBox> 
    167                                         </td> 
    168                                         <td><asp:Label ID="lbl_Klantreferentie3" runat="server" Text="Reference 3" AssociatedControlID="txt_Klantreferentie3" /></td><td>:</td> 
    169                                         <td><asp:TextBox ID="txt_Klantreferentie3" Text='<%# Bind("Klantreferentie3") %>' MaxLength="50" runat="server" /></td>  
    170                                     </tr> 
    171  
    172                                     <tr> 
    173                                         <td><asp:Label ID="lbl_Remarks" runat="server" Text="Remarks" AssociatedControlID="txt_Remarks" /></td><td>:</td> 
    174                                         <td><asp:TextBox ID="txt_Remarks" Text='<%# Bind("Opmerking_agent") %>' MaxLength="50" Columns="25" runat="server" /></td>  
    175                                     </tr> 
    176                                       
    177                                     <tr> 
    178                                         <td colspan="6">  
    179                                             <img src="spacer.gif" alt="" style="width:1px; height:5px; border:0; display:block; " /> 
    180                                             <img id="Img1" src="~/APP_Images/HdrGradientUnderline.png" runat="server" style="height:1px; display:block; " alt="" /> 
    181                                             <img src="spacer.gif" alt="" style="width:1px; height:5px; border:0; display:block; " /> 
    182                                             <asp:LinkButton ID="Button1" style="white-space:nowrap;" Text='<%# IIf(Container.GetType.ToString = "Telerik.Web.UI.GridEditFormItem", "<img src=""APP_Images/update.gif"" alt=""Update Release"" style=""border:0"" />&nbsp;Update Release", "<img src=""APP_Images/update.gif"" alt=""Update Release"" style=""border:0"" />&nbsp;Add Release") %>' runat="server" CommandName='<%# IIf(Container.GetType.ToString = "Telerik.Web.UI.GridEditFormItem", "Update", "PerformInsert") %>' /> 
    183                                             &nbsp;  
    184                                             <asp:LinkButton ID="Button2" Text='<img src="APP_Images/cancel.gif" alt="Cancel Update" style="border:0" />&nbsp;Cancel' runat="server" CausesValidation="False" CommandName="Cancel" /> 
    185                                         </td> 
    186                                     </tr> 
    187                                       
    188                                         <tr style="background-color:Red; Display:block">  
    189                                             <td colspan="6">  
    190                                                 <asp:Label ID="lbl_Releasenummer" runat="server" Text='<%# Bind("Releasenummer") %>' /><br /> 
    191                                                 <asp:Label ID="lbl_Partijnummer" runat="server" Text='<%# Bind("Stemaanvraagnummer") %>' /><br /> 
    192                                                 <asp:Label ID="lbl_Mutatiecode" runat="server" Text='<%# Bind("Mutatiecode") %>' /><br /> 
    193                                                 <asp:Label ID="lbl_Status" runat="server" Text='<%# Bind("Status") %>' /><br /> 
    194                                             </td> 
    195                                         </tr> 
    196                                       
    197                                 </table> 
    198                             </FormTemplate> 
    199                         </EditFormSettings> 
    200                   
    201                           
    202                     </telerik:GridTableView>   
    203                   
    204                 </DetailTables>   
    205  
    206                   
    207                 <Columns> 
    208                     <telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderStyle-Width="10px"></telerik:GridEditCommandColumn> 
    209                     <telerik:GridButtonColumn CommandName="Delete" Text="Delete" UniqueName="column" ButtonType="ImageButton" HeaderStyle-Width="10px"></telerik:GridButtonColumn> 
    210                     <telerik:GridBoundColumn DataField="Status" HeaderText="Status" SortExpression="Status" UniqueName="Status"   
    211                                              ItemStyle-VerticalAlign="Top" HeaderStyle-Width="40px">  
    212                     </telerik:GridBoundColumn> 
    213                     <telerik:GridBoundColumn DataField="Bestemming" HeaderText="Destination" SortExpression="Bestemming" UniqueName="Bestemming"   
    214                                              ItemStyle-VerticalAlign="Top" HeaderStyle-Width="120px">  
    215                     </telerik:GridBoundColumn> 
    216                     <telerik:GridTemplateColumn DataField="Periode_start" HeaderText="Period" SortExpression="Periode_start" DataType="System.DateTime" UniqueName="Periode_start" 
    217                                                 HeaderStyle-Width="100px">  
    218                         <ItemTemplate> 
    219                             <asp:Label ID="PeriodS" runat="server" Text='<%# Eval("Periode_start", "{0:yyyy/MM/dd  HH:mm}") %>'></asp:Label><br /> 
    220                             <asp:Label ID="PeriodE" runat="server" Text='<%# Eval("Periode_eind", "{0:yyyy/MM/dd  HH:mm}") %>'></asp:Label> 
    221                         </ItemTemplate> 
    222                     </telerik:GridTemplateColumn> 
    223                     <telerik:GridTemplateColumn DataField="Released_tons" HeaderText="Released_tons" SortExpression="Released_tons"  DataType="System.Int32" UniqueName="Released_tons"   
    224                                                 ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="100px">  
    225                         <ItemTemplate> 
    226                             <asp:Label ID="ReleasedT" runat="server" Text='<%# Eval("Released_tons", "{0:N0}") %>'></asp:Label><br /> 
    227                             <asp:Label ID="ReleasedD" runat="server" Text='<%# Eval("Release_datum", "{0:yyyy/MM/dd  HH:mm}") %>'></asp:Label> 
    228                         </ItemTemplate> 
    229                     </telerik:GridTemplateColumn> 
    230  
    231                     <telerik:GridTemplateColumn HeaderText="Information" UniqueName="Information1" HeaderStyle-Width="150px">  
    232                         <ItemTemplate>                              
    233                             <div> 
    234                                 <div style="float:left; white-space:nowrap; ">  
    235                                     <span>Operator:</span><br /> 
    236                                     <span>Reference 1:</span> 
    237                                 </div> 
    238                                 <div style="float:left; white-space:nowrap; ">  
    239                                     <asp:Label ID="Label7" runat="server" Text='<%# Eval("Agent_Desc") %>'></asp:Label><br /> 
    240                                     <asp:Label ID="Label8" runat="server" Text='<%# Eval("Klantreferentie1") %>'></asp:Label> 
    241                                 </div>                              
    242                             </div>                              
    243                         </ItemTemplate> 
    244                     </telerik:GridTemplateColumn> 
    245                     <telerik:GridTemplateColumn HeaderText="" UniqueName="Information2" HeaderStyle-Width="150px">  
    246                         <ItemTemplate>                              
    247                             <div> 
    248                                 <div style="float:left; white-space:nowrap; ">  
    249                                     <span>Gauger:</span><br /> 
    250                                     <span>Reference 2:</span> 
    251                                 </div> 
    252                                 <div style="float:left; white-space:nowrap; ">  
    253                                     <asp:Label ID="Label9" runat="server" Text='<%# Eval("IJker_Desc") %>'></asp:Label><br /> 
    254                                     <asp:Label ID="Label10" runat="server" Text='<%# Eval("Klantreferentie2") %>'></asp:Label> 
    255                                 </div> 
    256                             </div>                              
    257                         </ItemTemplate> 
    258                     </telerik:GridTemplateColumn> 
    259                     <telerik:GridTemplateColumn HeaderText="" UniqueName="Information3" HeaderStyle-Width="150px">  
    260                         <ItemTemplate> 
    261                                 <div style="float:left; white-space:nowrap; ">  
    262                                     <span>Sampler:</span><br /> 
    263                                     <span>Reference 3:</span> 
    264                                 </div> 
    265                                 <div style="float:left; white-space:nowrap; ">  
    266                                     <asp:Label ID="Label11" runat="server" Text='<%# Eval("Monsteraar_Desc") %>'></asp:Label><br /> 
    267                                     <asp:Label ID="Label12" runat="server" Text='<%# Eval("Klantreferentie3") %>'></asp:Label> 
    268                                 </div>                              
    269                             </div>                              
    270                         </ItemTemplate> 
    271                     </telerik:GridTemplateColumn> 
    272                     <telerik:GridTemplateColumn HeaderText="EMO" UniqueName="Information4">  
    273                         <ItemTemplate> 
    274                                 <div style="float:left; white-space:nowrap; ">  
    275                                     <span>Start:</span><br /> 
    276                                     <span>Status:</span> 
    277                                 </div> 
    278                                 <div style="float:left; white-space:nowrap; ">  
    279                                     <asp:Label ID="lbl_EMO_Start" runat="server" Text="2008-00-00 Spil III"></asp:Label><br /> 
    280                                     <asp:Label ID="lbl_EMO_Status" runat="server" Text="[TODO]"></asp:Label> 
    281                                 </div>                              
    282                             </div>                              
    283                         </ItemTemplate> 
    284                     </telerik:GridTemplateColumn> 
    285  
    286                     <telerik:GridBoundColumn DataField="Releasenummer" HeaderText="{ReID}" SortExpression="Releasenummer" UniqueName="Releasenummer"   
    287                                              ItemStyle-VerticalAlign="Top" HeaderStyle-Width="40px" HeaderStyle-ForeColor="Red" ItemStyle-ForeColor="Red">  
    288                     </telerik:GridBoundColumn> 
    289                 </Columns> 
    290                   
    291                 <EditFormSettings EditFormType="Template" CaptionFormatString="Release" > 
    292                     <PopUpSettings Modal="true" ScrollBars="Auto" Height="400px" Width="800px" /> 
    293                     <EditColumn UniqueName="EditCommandColumn1"></EditColumn> 
    294  
    295                     <FormStyle BackColor="#ECFED8" /> 
    296                     <FormTemplate> 
    297                         <table id="Table1" cellspacing="1" cellpadding="1" width="90%" border="0">  
    298                             <tr> 
    299                                 <td></td>  
    300                                 <td></td>  
    301                                 <td></td>  
    302                                 <td></td>  
    303                                 <td></td>  
    304                                 <td></td>  
    305                             </tr> 
    306                             <tr> 
    307                                 <td><asp:Label ID="lbl_Ton" runat="server" Text="Tons" AssociatedControlID="txt_Tons" /></td><td>:</td> 
    308                                 <td> 
    309                                     <telerik:RadNumericTextBox ID="txt_Tons" runat="server" Type="Number" MaxValue="99999999" MinValue="0" MaxLength="8" ShowSpinButtons="True" NumberFormat-DecimalDigits="0" Skin="Office2007" DbValue='<%# Bind("Released_tons") %>'></telerik:RadNumericTextBox> 
    310                                 </td> 
    311                                 <td></td>  
    312                                 <td></td>  
    313                                 <td style="text-align:right; "><%# Eval("Releasenummer") %>/<%#Eval("Partijnummer")%></td>  
    314                             </tr> 
    315                               
    316                             <tr> 
    317                                 <td><asp:Label ID="lbl_Period" runat="server" Text="Period" AssociatedControlID="rdtp_PeriodStart" /></td><td>:</td> 
    318                                 <td> 
    319                                     <telerik:RadDateTimePicker ID="rdtp_PeriodStart" runat="server" SelectedDate='<%#Bind("Periode_start")%>' Skin="Office2007" TimeView-EndTime="23:01:00" TimeView-StartTime="07:00:00" TimeView-Interval="08:00:00" TimeView-Columns="1" ></telerik:RadDateTimePicker> 
    320                                 </td> 
    321                                 <td><asp:Label ID="lbl_PeriodEnd" runat="server" Text="until" AssociatedControlID="rdtp_PeriodEnd" /></td><td>:</td> 
    322                                 <td> 
    323                                     <telerik:RadDateTimePicker ID="rdtp_PeriodEnd" runat="server" SelectedDate='<%#Bind("Periode_eind")%>' Skin="Office2007" TimeView-EndTime="23:01:00" TimeView-StartTime="07:00:00" TimeView-Interval="08:00:00" TimeView-Columns="1" ></telerik:RadDateTimePicker> 
    324                                 </td> 
    325                             </tr> 
    326  
    327                             <tr> 
    328                                 <td><asp:Label ID="lbl_Destination" runat="server" Text="Destination" AssociatedControlID="txt_Destination" /></td><td>:</td> 
    329                                 <td><asp:TextBox ID="txt_Destination" Text='<%# Bind("Bestemming") %>' MaxLength="50" runat="server" /></td>  
    330                                 <td><asp:Label ID="lbl_ReleaseDate" runat="server" Text="Release date" /></td><td>:</td> 
    331                                 <td><asp:Label ID="txt_ReleaseDate" runat="server" Text='<%# Bind("Release_datum") %>' /></td>  
    332                             </tr> 
    333                               
    334                             <tr> 
    335                                 <td><asp:Label ID="lbl_Operator" runat="server" Text="operator" AssociatedControlID="ddl_Agent" /></td><td>:</td> 
    336                                 <td> 
    337                                     <telerik:RadComboBox ID="ddl_Agent" Runat="server" AutoCompleteSeparator="|" 
    338                                         DataSourceID="SqlDataSource_Agent1" DataTextField="Naam" 
    339                                         DataValueField="FIRMA_ID" DropDownWidth="200px" 
    340                                         EmptyMessage="<No agents available>" EnableVirtualScrolling="True" 
    341                                         Filter="Contains" NoWrap="True" Skin="Office2007" AppendDataBoundItems="true" 
    342                                         SortCaseSensitive="False" SelectedValue='<%# Bind("Agent") %>' > 
    343                                         <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
    344                                         <Items> 
    345                                             <telerik:RadComboBoxItem Text="(select)" Value="<%# DBNull.Value %>" /> 
    346                                             <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="NNB" /> 
    347                                             <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="GEEN" /> 
    348                                         </Items> 
    349                                     </telerik:RadComboBox> 
    350                                 </td> 
    351                                 <td><asp:Label ID="lbl_Klantreferentie1" runat="server" Text="Reference 1" AssociatedControlID="txt_Klantreferentie1" /></td><td>:</td> 
    352                                 <td><asp:TextBox ID="txt_Klantreferentie1" Text='<%# Bind("Klantreferentie1") %>' MaxLength="50" runat="server" /></td>  
    353                             </tr> 
    354                               
    355  
    356                             <tr> 
    357                                 <td><asp:Label ID="lbl_IJker" runat="server" Text="gauger" AssociatedControlID="ddl_IJker" /></td><td>:</td> 
    358                                 <td> 
    359                                     <telerik:RadComboBox ID="ddl_IJker" Runat="server" AutoCompleteSeparator="|"   
    360                                         DataSourceID="SqlDataSource_Agent3" DataTextField="Naam"   
    361                                         DataValueField="FIRMA_ID" DropDownWidth="200px"   
    362                                         EmptyMessage="<No agents available>" EnableVirtualScrolling="True"   
    363                                         Filter="Contains" NoWrap="True" Skin="Office2007" AppendDataBoundItems="true"   
    364                                         SortCaseSensitive="False" SelectedValue='<%# Bind("IJker") %>' > 
    365                                         <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
    366                                         <Items> 
    367                                             <telerik:RadComboBoxItem Text="(select)" Value="<%# DBNull.Value %>" /> 
    368                                             <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="NNB" /> 
    369                                             <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="GEEN" /> 
    370                                         </Items> 
    371                                     </telerik:RadComboBox> 
    372                                 </td> 
    373                                 <td><asp:Label ID="lbl_Klantreferentie2" runat="server" Text="Reference 2" AssociatedControlID="txt_Klantreferentie2" /></td><td>:</td> 
    374                                 <td><asp:TextBox ID="txt_Klantreferentie2" Text='<%# Bind("Klantreferentie2") %>' MaxLength="50" runat="server" /></td>  
    375                             </tr> 
    376                             <tr> 
    377                                 <td><asp:Label ID="lbl_Monsteraar" runat="server" Text="sampler" AssociatedControlID="ddl_Monsteraar" /></td><td>:</td> 
    378                                 <td> 
    379                                     <telerik:RadComboBox ID="ddl_Monsteraar" Runat="server" AutoCompleteSeparator="|"   
    380                                         DataSourceID="SqlDataSource_Agent4" DataTextField="Naam"   
    381                                         DataValueField="FIRMA_ID" DropDownWidth="200px"   
    382                                         EmptyMessage="<No agents available>" EnableVirtualScrolling="True"   
    383                                         Filter="Contains" NoWrap="True" Skin="Office2007" AppendDataBoundItems="true"   
    384                                         SortCaseSensitive="False" SelectedValue='<%# Bind("Monsteraar") %>' > 
    385                                         <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
    386                                         <Items> 
    387                                             <telerik:RadComboBoxItem Text="(select)" Value="<%# DBNull.Value %>" /> 
    388                                             <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="NNB" /> 
    389                                             <telerik:RadComboBoxItem Text="(Not Yet Known)" Value="GEEN" /> 
    390                                         </Items> 
    391                                     </telerik:RadComboBox> 
    392                                 </td> 
    393                                 <td><asp:Label ID="lbl_Klantreferentie3" runat="server" Text="Reference 3" AssociatedControlID="txt_Klantreferentie3" /></td><td>:</td> 
    394                                 <td><asp:TextBox ID="txt_Klantreferentie3" Text='<%# Bind("Klantreferentie3") %>' MaxLength="50" runat="server" /></td>  
    395                             </tr> 
    396                               
    397                             <tr> 
    398                                 <td colspan="6">  
    399                                     <img src="spacer.gif" alt="" style="width:1px; height:5px; border:0; display:block; " /> 
    400                                     <img id="Img1" src="~/APP_Images/HdrGradientUnderline.png" runat="server" style="height:1px; display:block; " alt="" /> 
    401                                     <img src="spacer.gif" alt="" style="width:1px; height:5px; border:0; display:block; " /> 
    402                                     <asp:LinkButton ID="Button1" style="white-space:nowrap;" Text='<%# IIf(Container.GetType.ToString = "Telerik.Web.UI.GridEditFormItem", "<img src=""APP_Images/update.gif"" alt=""Update Release"" style=""border:0"" />&nbsp;Update Release", "<img src=""APP_Images/update.gif"" alt=""Update Release"" style=""border:0"" />&nbsp;Add Release") %>' runat="server" CommandName='<%# IIf(Container.GetType.ToString = "Telerik.Web.UI.GridEditFormItem", "Update", "PerformInsert") %>' /> 
    403                                     &nbsp;  
    404                                     <asp:LinkButton ID="Button2" Text='<img src="APP_Images/cancel.gif" alt="Cancel Update" style="border:0" />&nbsp;Cancel' runat="server" CausesValidation="False" CommandName="Cancel" /> 
    405                                 </td> 
    406                             </tr> 
    407                               
    408                                 <tr style="background-color:Red; Display:block">  
    409                                     <td colspan="6">  
    410                                         <asp:Label ID="lbl_Releasenummer" runat="server" Text='<%# Bind("Releasenummer") %>' /><br /> 
    411                                         <asp:Label ID="lbl_Partijnummer" runat="server" Text='<%# Bind("Partijnummer") %>' /><br /> 
    412                                         <asp:Label ID="lbl_Mutatiecode" runat="server" Text='<%# Bind("Mutatiecode") %>' /><br /> 
    413                                         <asp:Label ID="lbl_Status" runat="server" Text='<%# Bind("Status") %>' /><br /> 
    414                                     </td> 
    415                                 </tr> 
    416                               
    417                         </table> 
    418                     </FormTemplate> 
    419                 </EditFormSettings> 
    420             </MasterTableView> 
    421  
    422             <ClientSettings> 
    423                 <Selecting AllowRowSelect="True" /> 
    424             </ClientSettings> 
    425  
    426         </telerik:RadGrid> 
    427       
    428       
    429     </div> 
    430       
    431     <asp:SqlDataSource ID="SqlDataSource_Release" runat="server" ConnectionString="<%$ ConnectionStrings:EMO_SCDB %>"   
    432         DeleteCommand="UPDATE [INT_SNS_RELEASE] SET [Status] = 'X' WHERE [Releasenummer] = @Releasenummer" 
    433         InsertCommand="INSERT INTO [INT_SNS_RELEASE] ([Partijnummer], [Mutatiecode], [Status], [Agent], [Monsteraar], [IJker], [Bestemming], [Periode_start], [Periode_eind], [Release_datum], [Klantreferentie1], [Klantreferentie2], [Klantreferentie3]) VALUES (@Partijnummer, @Mutatiecode, @Status, @Agent, @Monsteraar, @IJker, @Bestemming, @Periode_start, @Periode_eind, @Release_datum, @Klantreferentie1, @Klantreferentie2, @Klantreferentie3)" 
    434         UpdateCommand="UPDATE [INT_SNS_RELEASE] SET [Partijnummer] = @Partijnummer, [Mutatiecode] = @Mutatiecode, [Status] = @Status, [Agent] = @Agent, [Monsteraar] = @Monsteraar, [IJker] = @IJker, [Bestemming] = @Bestemming, [Periode_start] = @Periode_start, [Periode_eind] = @Periode_eind, [Release_datum] = @Release_datum, [Klantreferentie1] = @Klantreferentie1, [Klantreferentie2] = @Klantreferentie2, [Klantreferentie3] = @Klantreferentie3 WHERE [Releasenummer] = @Releasenummer"        
    435         SelectCommand="SELECT INT_SNS_RELEASE.Releasenummer, INT_SNS_RELEASE.Partijnummer, INT_SNS_RELEASE.Mutatiecode, INT_SNS_RELEASE.Status,   
    436                               INT_SNS_RELEASE.Agent, INT_SNS_RELEASE.Monsteraar, INT_SNS_RELEASE.IJker, INT_SNS_RELEASE.Bestemming,   
    437                               INT_SNS_RELEASE.Periode_start, INT_SNS_RELEASE.Periode_eind, INT_SNS_RELEASE.Released_tons, INT_SNS_RELEASE.Release_datum,   
    438                               INT_SNS_RELEASE.Klantreferentie1, INT_SNS_RELEASE.Klantreferentie2, INT_SNS_RELEASE.Klantreferentie3,   
    439                               dbo.ProperCase(DB_RELATIE_1.FIRMANAAM) AS Agent_Desc, dbo.ProperCase(DB_RELATIE_2.FIRMANAAM) AS Monsteraar_Desc,   
    440                               dbo.ProperCase(DB_RELATIE_3.FIRMANAAM) AS IJker_Desc,  
    441                               (CASE WHEN IsNull(PA.TON_VOORRAAD, 0) = 0 THEN .PA.TON_VOORRAAD_PLAN ELSE PA.TON_VOORRAAD END) AS VOORRAAD  
    442                        FROM   DB_RELATIE AS DB_RELATIE_2 RIGHT OUTER JOIN INT_SNS_RELEASE LEFT OUTER JOIN  
    443                               (SELECT DB_PARTIJ.PARTIJNUMMER, Sum(DB_VOORRAAD.TON_VOORRAAD) AS TON_VOORRAAD, Sum(DB_VOORRAAD.TON_VOORRAAD_PLAN) AS TON_VOORRAAD_PLAN, Sum(DB_VOORRAAD.TON_VOORRAAD_FIXED) AS TON_VOORRAAD_FIXED  
    444                                FROM DB_PARTIJ LEFT OUTER JOIN DB_VOORRAAD ON DB_PARTIJ.LADINGNUMMER = DB_VOORRAAD.LADINGNUMMER  
    445                                GROUP BY Partijnummer  
    446                               ) AS PA ON INT_SNS_RELEASE.Partijnummer = PA.PARTIJNUMMER LEFT OUTER JOIN  
    447                               DB_RELATIE AS DB_RELATIE_3 ON INT_SNS_RELEASE.IJker = DB_RELATIE_3.FIRMA_ID ON   
    448                               DB_RELATIE_2.FIRMA_ID = INT_SNS_RELEASE.Monsteraar LEFT OUTER JOIN  
    449                               DB_RELATIE AS DB_RELATIE_1 ON INT_SNS_RELEASE.Agent = DB_RELATIE_1.FIRMA_ID  
    450                        WHERE  (INT_SNS_RELEASE.Klant = @Current_ClientID)   
    451                           AND ((INT_SNS_RELEASE.Agent = @Current_GradeOperator) OR (1 = @Current_UseGradeOperatorFilter))  
    452                           AND (INT_SNS_RELEASE.Partijnummer = @Current_PartijNummer)  
    453                       "> 
    454         <SelectParameters> 
    455             <asp:SessionParameter SessionField="EMOServiceNET\Current\Client_ID"                    Name="Current_ClientID"  /> 
    456             <asp:SessionParameter SessionField="EMOServiceNET\Current\Login_ID"                     Name="Current_ShipOperator"  /> 
    457             <asp:SessionParameter SessionField="EMOServiceNET\Current\LoginRollUseAgentInSelect"    Name="Current_UseShipOperatorFilter"  /> 
    458             <asp:SessionParameter SessionField="EMOServiceNET\Current\Login_ID"                     Name="Current_GradeOperator"  /> 
    459             <asp:SessionParameter SessionField="EMOServiceNET\Current\LoginRollUseAgentInSelect"    Name="Current_UseGradeOperatorFilter"  /> 
    460             <asp:SessionParameter SessionField="EMOServiceNET\Current\Partij_ID"                    Name="Current_PartijNummer"  /> 
    461         </SelectParameters> 
    462         <UpdateParameters> 
    463             <asp:Parameter Name="Releasenummer" Type="Int32" /> 
    464             <asp:Parameter Name="Partijnummer" Type="Int32" /> 
    465             <asp:Parameter Name="Mutatiecode" Type="String" /> 
    466             <asp:Parameter Name="Status" Type="String" /> 
    467             <asp:Parameter Name="Agent" Type="String" /> 
    468             <asp:Parameter Name="Monsteraar" Type="String" /> 
    469             <asp:Parameter Name="IJker" Type="String" /> 
    470             <asp:Parameter Name="Bestemming" Type="String" /> 
    471             <asp:Parameter Name="Periode_start" Type="DateTime" /> 
    472             <asp:Parameter Name="Periode_eind" Type="DateTime" /> 
    473             <asp:Parameter Name="Release_datum" Type="DateTime" /> 
    474             <asp:Parameter Name="Klantreferentie1" Type="String" /> 
    475             <asp:Parameter Name="Klantreferentie2" Type="String" /> 
    476             <asp:Parameter Name="Klantreferentie3" Type="String" /> 
    477         </UpdateParameters> 
    478         <InsertParameters> 
    479             <asp:Parameter Name="Releasenummer" Type="Int32" /> 
    480             <asp:Parameter Name="Partijnummer" Type="Int32" /> 
    481             <asp:Parameter Name="Mutatiecode" Type="String" /> 
    482             <asp:Parameter Name="Status" Type="String" /> 
    483             <asp:Parameter Name="Agent" Type="String" /> 
    484             <asp:Parameter Name="Monsteraar" Type="String" /> 
    485             <asp:Parameter Name="IJker" Type="String" /> 
    486             <asp:Parameter Name="Bestemming" Type="String" /> 
    487             <asp:Parameter Name="Periode_start" Type="DateTime" /> 
    488             <asp:Parameter Name="Periode_eind" Type="DateTime" /> 
    489             <asp:Parameter Name="Release_datum" Type="DateTime" /> 
    490             <asp:Parameter Name="Klantreferentie1" Type="String" /> 
    491             <asp:Parameter Name="Klantreferentie2" Type="String" /> 
    492             <asp:Parameter Name="Klantreferentie3" Type="String" /> 
    493         </InsertParameters> 
    494     </asp:SqlDataSource> 
    495  
    496     <asp:SqlDataSource ID="SqlDataSource_Stem" runat="server" ConnectionString="<%$ ConnectionStrings:EMO_SCDB %>"   
    497         DeleteCommand="UPDATE [INT_SNS_STEMAANVRAAG] SET [Status] = 'X' WHERE [Stemaanvraagnummer] = @Stemaanvraagnummer"   
    498         InsertCommand="INSERT INTO [INT_SNS_STEMAANVRAAG] ([Releasenummer], [Ladingnummer], [Status], [Agent], [Monsteraar], [IJker], [Opmerking_agent], [Opmerking_EMO], [Tons], [Mutatiecode], [Klantreferentie1], [Klantreferentie2], [Klantreferentie3]) VALUES (@Releasenummer, @Ladingnummer, @Status, @Agent, @Monsteraar, @IJker, @Opmerking_agent, @Opmerking_EMO, @Tons, @Mutatiecode, @Klantreferentie1, @Klantreferentie2, @Klantreferentie3)"   
    499         SelectCommand="SELECT [Stemaanvraagnummer], [Releasenummer], [Ladingnummer], [Status], [Agent], [Monsteraar], [IJker], [Opmerking_agent], [Opmerking_EMO], [Tons], [Mutatiecode], [Klantreferentie1], [Klantreferentie2], [Klantreferentie3] FROM [INT_SNS_STEMAANVRAAG] WHERE [Releasenummer] = @Releasenummer"   
    500         UpdateCommand="UPDATE [INT_SNS_STEMAANVRAAG] SET [Releasenummer] = @Releasenummer, [Ladingnummer] = @Ladingnummer, [Status] = @Status, [Agent] = @Agent, [Monsteraar] = @Monsteraar, [IJker] = @IJker, [Opmerking_agent] = @Opmerking_agent, [Opmerking_EMO] = @Opmerking_EMO, [Tons] = @Tons, [Mutatiecode] = @Mutatiecode, [Klantreferentie1] = @Klantreferentie1, [Klantreferentie2] = @Klantreferentie2, [Klantreferentie3] = @Klantreferentie3 WHERE [Stemaanvraagnummer] = @Stemaanvraagnummer" 
    501         > 
    502         <SelectParameters> 
    503             <asp:SessionParameter Name="Releasenummer" SessionField="Releasenummer" /> 
    504         </SelectParameters> 
    505         <DeleteParameters> 
    506             <asp:Parameter Name="Stemaanvraagnummer" Type="Int32" /> 
    507         </DeleteParameters> 
    508         <UpdateParameters> 
    509             <asp:Parameter Name="Releasenummer" Type="Int32" /> 
    510             <asp:Parameter Name="Ladingnummer" Type="Int32" /> 
    511             <asp:Parameter Name="Status" Type="String" /> 
    512             <asp:Parameter Name="Agent" Type="String" /> 
    513             <asp:Parameter Name="Monsteraar" Type="String" /> 
    514             <asp:Parameter Name="IJker" Type="String" /> 
    515             <asp:Parameter Name="Opmerking_agent" Type="String" /> 
    516             <asp:Parameter Name="Opmerking_EMO" Type="String" /> 
    517             <asp:Parameter Name="Tons" Type="Int32" /> 
    518             <asp:Parameter Name="Mutatiecode" Type="String" /> 
    519             <asp:Parameter Name="Klantreferentie1" Type="String" /> 
    520             <asp:Parameter Name="Klantreferentie2" Type="String" /> 
    521             <asp:Parameter Name="Klantreferentie3" Type="String" /> 
    522             <asp:Parameter Name="Stemaanvraagnummer" Type="Int32" /> 
    523         </UpdateParameters> 
    524         <InsertParameters> 
    525             <asp:Parameter Name="Releasenummer" Type="Int32" /> 
    526             <asp:Parameter Name="Ladingnummer" Type="Int32" /> 
    527             <asp:Parameter Name="Status" Type="String" /> 
    528             <asp:Parameter Name="Agent" Type="String" /> 
    529             <asp:Parameter Name="Monsteraar" Type="String" /> 
    530             <asp:Parameter Name="IJker" Type="String" /> 
    531             <asp:Parameter Name="Opmerking_agent" Type="String" /> 
    532             <asp:Parameter Name="Opmerking_EMO" Type="String" /> 
    533             <asp:Parameter Name="Tons" Type="Int32" /> 
    534             <asp:Parameter Name="Mutatiecode" Type="String" /> 
    535             <asp:Parameter Name="Klantreferentie1" Type="String" /> 
    536             <asp:Parameter Name="Klantreferentie2" Type="String" /> 
    537             <asp:Parameter Name="Klantreferentie3" Type="String" /> 
    538         </InsertParameters> 
    539     </asp:SqlDataSource> 
    540  
    541     <asp:SqlDataSource ID="SqlDataSource_PartijLading" runat="server" ConnectionString="<%$ ConnectionStrings:EMO_SCDB %>"   
    542         SelectCommand="SELECT DB_PARTIJ.LADINGNUMMER, DB_PARTIJ.LADING_SOORT, dbo.ProperCase(DB_PARTIJ.LADING_SOORT) + ' (' + RTrim(Convert(char, (CASE WHEN IsNull(DB_VOORRAAD.TON_VOORRAAD, 0) = 0 THEN IsNull(TON_VOORRAAD_PLAN, 0) ELSE DB_VOORRAAD.TON_VOORRAAD END))) + ')' AS lading_soort_Desc,  
    543                               CASE WHEN IsNull(DB_VOORRAAD.TON_VOORRAAD, 0) = 0 THEN IsNull(TON_VOORRAAD_PLAN, 0) ELSE DB_VOORRAAD.TON_VOORRAAD END AS VR  
    544                        FROM   DB_PARTIJ LEFT OUTER JOIN DB_VOORRAAD ON DB_PARTIJ.LADINGNUMMER = DB_VOORRAAD.LADINGNUMMER  
    545                        WHERE  (DB_PARTIJ.KLANT_ID = @Current_ClientID)   
    546                           AND ((DB_PARTIJ.AGENT_ID = @Current_GradeOperator) OR (1=@Current_UseGradeOperatorFilter))   
    547                           AND (DB_PARTIJ.PARTIJNUMMER = @Current_PartijNummer)  
    548                       "> 
    549         <SelectParameters> 
    550             <asp:SessionParameter SessionField="EMOServiceNET\Current\Client_ID"                    Name="Current_ClientID"  /> 
    551             <asp:SessionParameter SessionField="EMOServiceNET\Current\Login_ID"                     Name="Current_ShipOperator"  /> 
    552             <asp:SessionParameter SessionField="EMOServiceNET\Current\LoginRollUseAgentInSelect"    Name="Current_UseShipOperatorFilter"  /> 
    553             <asp:SessionParameter SessionField="EMOServiceNET\Current\Login_ID"                     Name="Current_GradeOperator"  /> 
    554             <asp:SessionParameter SessionField="EMOServiceNET\Current\LoginRollUseAgentInSelect"    Name="Current_UseGradeOperatorFilter"  /> 
    555             <asp:SessionParameter SessionField="EMOServiceNET\Current\Partij_ID"                    Name="Current_PartijNummer"  /> 
    556         </SelectParameters>          
    557     </asp:SqlDataSource> 
    558       
    559     <asp:SqlDataSource ID="SqlDataSource_Agent1" runat="server" ConnectionString="<%$ ConnectionStrings:EMO_SCDB %>"                                  
    560         SelectCommand="SELECT RTrim(FIRMA_ID) As FIRMA_ID, dbo.ProperCase(FIRMANAAM) As Naam  FROM DB_Relatie WHERE LTRIM(FIRMANAAM) <> '' AND agent_firma = 'J' Order By FIRMANAAM">  
    561     </asp:SqlDataSource> 
    562     <asp:SqlDataSource ID="SqlDataSource_Agent2" runat="server" ConnectionString="<%$ ConnectionStrings:EMO_SCDB %>"                                  
    563         SelectCommand="SELECT RTrim(FIRMA_ID) As FIRMA_ID, dbo.ProperCase(FIRMANAAM) As Naam  FROM DB_Relatie WHERE LTRIM(FIRMANAAM) <> '' AND agent_firma = 'J' Order By FIRMANAAM">  
    564     </asp:SqlDataSource> 
    565     <asp:SqlDataSource ID="SqlDataSource_Agent3" runat="server" ConnectionString="<%$ ConnectionStrings:EMO_SCDB %>"                                  
    566         SelectCommand="SELECT RTrim(FIRMA_ID) As FIRMA_ID, dbo.ProperCase(FIRMANAAM) As Naam  FROM DB_Relatie WHERE LTRIM(FIRMANAAM) <> '' AND agent_firma = 'J' Order By FIRMANAAM">  
    567     </asp:SqlDataSource> 
    568     <asp:SqlDataSource ID="SqlDataSource_Agent4" runat="server" ConnectionString="<%$ ConnectionStrings:EMO_SCDB %>"                                  
    569         SelectCommand="SELECT RTrim(FIRMA_ID) As FIRMA_ID, dbo.ProperCase(FIRMANAAM) As Naam  FROM DB_Relatie WHERE LTRIM(FIRMANAAM) <> '' AND agent_firma = 'J' Order By FIRMANAAM">  
    570     </asp:SqlDataSource> 
    571       
    572     </div> 
    573     </form> 
    574 </body> 
    575 </html> 
    576  

    hope you can provide me with a solution...
  6. Erik
    Erik avatar
    314 posts
    Member since:
    Feb 2008
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017