ASPX Code
VB Code
in this code im working on edited item only the data item always not visible
i face a probem when delete item from Grid every thing user added will be deleted because of rebind
how can i update all items in session data source when delete an item ?
THXX
<telerik:RadGrid ID="rgReceiptDTL" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AutoGenerateColumns="False" AllowMultiRowEdit="true" MasterTableView-EditMode="EditForms" Height="300px" MasterTableView-Dir="<%$ Resources:SystemResource, HTMLDirectionality %>" Width="98%" GroupPanelPosition="Top" DataSourceID="SDSReceiptDTL"> <MasterTableView CommandItemDisplay="None" DataKeyNames="IDNo" GridLines="None" HorizontalAlign="NotSet" NoMasterRecordsText="<%$ Resources:Grid , NoMasterRecordsText %>" TableLayout="Fixed" Width="100%" DataSourceID="SDSReceiptDTL"> <CommandItemSettings ExportToPdfText="Export to Pdf" /> <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column" Visible="True"> </RowIndicatorColumn> <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column" Visible="True"> </ExpandCollapseColumn> <HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center" Wrap="True" /> <Columns> <telerik:GridTemplateColumn EditFormHeaderTextFormat="" DataField="ItemNo" meta:resourcekey="ItemNo" UniqueName="ItemNo"> <HeaderStyle Width="85" /> <ItemTemplate> <telerik:RadTextBox SkinID="Medium" Text='<%#Eval("ItemName")%>' runat="server" ID="rtbItemName"> </telerik:RadTextBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn meta:resourcekey="ItemName"> <HeaderStyle Width="130" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn meta:resourcekey="UnitPrice" DataField="UnitPrice"> <HeaderStyle Width="130" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn meta:resourcekey="PurchDate" DataField="PurchDate"> <HeaderStyle Width="130" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn meta:resourcekey="DepreciateRatio" DataField="DepreciateRatio"> <HeaderStyle Width="130" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn meta:resourcekey="originalFactorNo" DataField="originalFactorNo"> <HeaderStyle Width="130" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="Qty" meta:resourcekey="Qty" UniqueName="Qty"> <HeaderStyle Width="130" /> </telerik:GridTemplateColumn> <%-- <telerik:GridTemplateColumn DataField="Total" meta:resourcekey="Total" UniqueName="Total"> </telerik:GridTemplateColumn>--%> <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmDialogType="RadWindow" ConfirmText="<%$ Resources:Grid ,ConfirmDelete %>" ConfirmTitle="<%$ Resources:Grid ,Delete %>" FilterImageUrl="~\Design\TelerikSkins\Grid\Filter.gif" ImageUrl="~\Design\TelerikSkins\Grid\Delete.gif" SortAscImageUrl="~\Design\TelerikSkins\Grid\SortAsc.gif" SortDescImageUrl="~\Design\TelerikSkins\Grid\SortDesc.gif" Text="<%$ Resources:Grid ,Delete %>" UniqueName="column1"> <HeaderStyle Width="50px" /> <ItemStyle Width="50px" /> </telerik:GridButtonColumn> </Columns> <EditFormSettings EditFormType="Template"> <FormTemplate> <table style="width: 100%;"> <tr> <td style="width: 85px"> <asp:Label runat="server" ID="lblItemNo" Text='<%#Eval("ItemNo")%>'></asp:Label> </td> <td style="width: 130px"> <telerik:RadTextBox SkinID="Medium" Text='<%#Eval("ItemName")%>' AutoPostBack="true" OnTextChanged="rtbItemName_TextChanged" runat="server" ID="rtbItemName"> </telerik:RadTextBox></td> <td style="width: 130px"> <asp:Label runat="server" ID="lblUnitPrice" Text='<%#Eval("UnitPrice")%>'></asp:Label></td> <td style="width: 130px"> <telerik:RadDatePicker SkinID="Medium" DbSelectedDate='<%#Eval("PurchDate")%>' runat="server" ID="rdpPurchDate"> </telerik:RadDatePicker> </td> <td style="width: 130px"> <telerik:RadNumericTextBox runat="server" DbValue='<%#Eval("DepreciateRatio")%>' ID="rntbDepreciateRatio" SkinID="NumberMedium"> </telerik:RadNumericTextBox></td> <td style="width: 130px"> <telerik:RadTextBox SkinID="Medium" runat="server" ID="rtboriginalFactorNo"></telerik:RadTextBox></td> <td style="width: 130px"> <telerik:RadNumericTextBox runat="server" ID="rntbQTY" DbValue='<%#Eval("Qty")%>' MaxValue='<%#Eval("Qty")%>' SkinID="NumberMedium"> </telerik:RadNumericTextBox> </td> <td style="width: 50px;"> <asp:ImageButton runat="server" ID="btnDelete" ToolTip="Delete" CommandName="Delete" ImageUrl="~\Design\TelerikSkins\Grid\Delete.gif" /> </td> </tr> </table> </FormTemplate> </EditFormSettings> </MasterTableView> <ClientSettings> <Scrolling AllowScroll="True" SaveScrollPosition="False" ScrollHeight="200px" UseStaticHeaders="True" /> </ClientSettings></telerik:RadGrid><cc1:SessionDataSource ID="SDSReceiptDTL" runat="server" ClearSessionOnInitialLoad="True" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:ApplicationServices %>" SelectCommand="EXEC [Inv_ReceiptDtlSP] 'rtvLPODTL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,@LPONO,@LPOYear" UpdateCommand="EXEC [Inv_ReceiptDtlSP] 'Save'" DeleteCommand="EXEC [Inv_ReceiptDtlSP] 'Delete'" InsertCommand="EXEC [Inv_ReceiptDtlSP] 'Save'" PrimaryKeyFields="IDNo" SessionKey="System.Web.UI.Page_SDSReceiptDTL"> <SelectParameters> <asp:ControlParameter ControlID="hdnLPONO" Name="LPONO" PropertyName="Value" /> <asp:ControlParameter ControlID="hdnLPOYear" Name="LPOYear" PropertyName="Value" /> </SelectParameters></cc1:SessionDataSource><asp:HiddenField runat="server" ID="hdnLPONO" /><asp:HiddenField runat="server" ID="hdnLPOYear" />VB Code
Private Sub rgReceiptDTL_ItemCommand(sender As Object, e As GridCommandEventArgs) Handles rgReceiptDTL.ItemCommand If e.CommandName = RadGrid.DeleteCommandName Then End IfEnd SubPrivate Sub rgReceiptDTL_ItemDataBound(sender As Object, e As GridItemEventArgs) Handles rgReceiptDTL.ItemDataBound rgReceiptDTL.EditIndexes.Add(e.Item.ItemIndex) e.Item.Edit = TrueEnd SubProtected Sub rgReceiptDTL_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles rgReceiptDTL.PreRender If (rgReceiptDTL.EditItems.Count > 0) Then For Each item As GridDataItem In rgReceiptDTL.MasterTableView.Items item.Visible = False Next End IfEnd Subin this code im working on edited item only the data item always not visible
i face a probem when delete item from Grid every thing user added will be deleted because of rebind
how can i update all items in session data source when delete an item ?
THXX