Telerik Forums
UI for ASP.NET AJAX Forum
5 answers
237 views
Hello Telerik team,

I have a requirement where I need to Edit/Update/Delete the items on a radgrid which are populated from a sharepoint list meaning my datasource is sharepoint datatable.I am using Pop up edit form on edit like shown in this http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/popupeditform/defaultcs.aspx and when i click on "edit" I am able to show my present list item values on pop up edit form for that particular item.How do i write the events on "Update" and "Cancel" buttons inside the pop up edit form and how do i grab that particular item and update that item only.

I have one more issue.As shown in the blog mentioned above, I have a add new record.But when i click on that I am not able to show up the new edit pop up form and what kind of event can be written on that edit form to insert the record into the sharepoint list.

I have one more, I have used a rad window on delete which comes by using "Confirmtype"="Radwindow" on the column.How to write the events on that dialog box to delete or cancel the selected item.

Please provide me a sample with the sharepoint list because I saw many samples for sql datasource and none for a sharepoint list.
I greatly appreciate your response.

Thanks
Smith
Tsvetoslav
Telerik team
 answered on 17 Dec 2010
2 answers
156 views
Hi,

I would like to know if is possible to remove the appointment delete icon that is shown when the mouse is moved over an appointment. I've tried using an AppointmentTemplate but no result.

Regards,
john
Top achievements
Rank 1
 answered on 17 Dec 2010
1 answer
53 views
How to set the image in export pdf.
Daniel
Telerik team
 answered on 17 Dec 2010
4 answers
162 views
Is it possible to save the Track Changes result without opening the dialog?  Or even just a way to open the dialog in the background and close it out once the content is rendered an I have grabed the fieldset for the Track Change Content? 

My objective is to present the track changes content outside of the Editor to other users, so they can see what has changed.  I currently save both the initial and final versions to my database right now.  And I can force the content to automatically set and switch out with the following script.  I would just prefer not to have the dialog interfere with the UI when my sole purpose for it's use is just get the content rendered in the track change format, not to inform the users that wrote the content.
function EditorCommand(editor, args) {
                                  
switch (args.get_commandName()) {
 case "TrackChangesDialog":
   var loc = "Pub.aspx";
   var methodName = "GetLastRevContent" + location.search;
   var jsondata = new Object();
   jsondata.contentId = _$currentEdit.attr("id");
   var jsoon = $.toJSON(jsondata);
   $.ajax({
           async: false,
           type: "POST",
           url: loc + "/" + methodName,
           data: jsoon,
           contentType: "application/json; charset=utf-8",
           dataType: "json",
           timeout: _sysEditPubVars.timeoutRate,
           success: function (response) {
               var editor = $find('<%= RadEditor1.ClientID %>');
               var fromServer = jQuery.parseJSON(response.d);
               var currentcontent = editor.get_html(true);
               editor.set_html(fromServer.oldContent);
               editor.set_initialContent();
               editor.set_html(currentcontent);
               },
             });
      break;
  default:
      break;
   }
}
Sean Patterson
Top achievements
Rank 1
 answered on 17 Dec 2010
2 answers
79 views
I am exporting hierarchical rad grid to excel.
After exporting I can not apply normal excel sort on those result as it is giving attached warning.

 
Daniel
Telerik team
 answered on 17 Dec 2010
1 answer
78 views
Blank
Tsvetoslav
Telerik team
 answered on 17 Dec 2010
3 answers
154 views
When filtering, I'd like for the drop down to resize to remove the empty lines as the selections are narrowed down.  So far I haven't found a way to do this.  There doesn't appear to be a client side method or property on the RadComboBox object to do this.  Any ideas?

Thanks
Kalina
Telerik team
 answered on 17 Dec 2010
1 answer
78 views
Hi,
I have a radgrid. In that control I have lot of rows (without paging). So I see only e.g. 20 rows on screen and using scrollbars I move to other records. In code I select e.g. 30. record. Is any way to move scrollbars to that record?
Princy
Top achievements
Rank 2
 answered on 17 Dec 2010
1 answer
106 views
Hello Telerik team,

I have created a combo with tree view using below code.

<div onmousedown="allowCBClose(true);">
                                                    <telerik:RadComboBox Width="200px" DropDownWidth="200px" Height="200px" ID="radcmbWBS"
                                                        Skin="WebBlue" runat="server" OnClientDropDownClosing="OnClientDropDownClosing"
                                                        AllowCustomText="True" EnableLoadOnDemand="True" OnItemsRequested="ItemsRequested"
                                                        OnClientItemsRequested="OnClientItemsRequested" EmptyMessage="~Select WBS Node~"
                                                        OnSelectedIndexChanged="radcmbWBS_SelectedIndexChanged" ErrorMessage="WBS Node Required">
                                                        <ItemTemplate>
                                                            <div onmouseup="allowCBClose(false);">
                                                                <telerik:RadTreeView ID="rtvWBS" runat="server" Height="350" Width="100%" OnClientNodeClicking="nodeClicking"
                                                                    BeforeClientClick="ProcessClientClick">
                                                                </telerik:RadTreeView>
                                                            </div>
                                                        </ItemTemplate>
                                                    </telerik:RadComboBox>
                                                </div>

Tree view nodes are generated from server side code.

I can get the selected tree view node value from.
But my question is how to set the treeview node back to the combo box, when the page is opened for edit ?

Please reply it.
Thanks
Shivan
Shinu
Top achievements
Rank 2
 answered on 17 Dec 2010
7 answers
70 views
Hi,
Is anybody can explain me what's wrong in my code ?

The détailtable is always empty at the first load. If i sort the grid, détailtables are bind.

Thks



<telerik:RadGrid ID="MasterRadGrid" runat="server" AutoGenerateColumns="False" AllowPaging="True"
    AllowSorting="True" GridLines="None" AllowMultiRowSelection="true" DataSourceID="DataSource1"
    CssClass="data-table achat-vente" ClientSettings-AllowExpandCollapse="true">
    <ClientSettings>
        <Scrolling AllowScroll="true" UseStaticHeaders="true" ScrollHeight="590px" />
        <Selecting AllowRowSelect="true" UseClientSelectColumnOnly="true" EnableDragToSelectRows="false" />
        <ClientEvents OnGridCreated="GridCreated" />
    </ClientSettings>
    <HierarchySettings ExpandTooltip="Afficher les détails" CollapseTooltip="Masquer les détails" />
    <SortingSettings SortToolTip="Trier" SortedAscToolTip="Trier" SortedDescToolTip="Trier" />
    <ItemStyle CssClass="row1" />
    <AlternatingItemStyle CssClass="row2" />
    <MasterTableView CellSpacing="1" CssClass="data-table" DataSourceID="DataSource1"
        HierarchyLoadMode="client" DataKeyNames="NOCOMP,CDART" ClientDataKeyNames="NOCOMP,CDART"
        Name="MasterTarif">
        <PagerStyle Mode="NextPrevAndNumeric" PageSizeLabelText="Nombre de lignes par page"
            ShowPagerText="true" FirstPageToolTip="Première page" PrevPagesToolTip="Page précédente"
            NextPagesToolTip="Page suivante" LastPageToolTip="Dernière page" PagerTextFormat="{4} Articles {2} à {3} sur {5}"
            PageButtonCount="5" BackColor="#ABCD55" BorderStyle="None" VerticalAlign="Middle" />
        <DetailTables>
            <telerik:GridTableView Name="DetailsTarif" runat="server" Width="100%" AllowPaging="false"
                AllowSorting="false" CellSpacing="1" CssClass="toggleRow row-open" DataSourceID="DataSource2"
                DataKeyNames="NOCOMP,CDART" ClientDataKeyNames="NOCOMP,CDART" HierarchyLoadMode="client">
                <ItemStyle CssClass="rgRow row_detail" />
                <AlternatingItemStyle CssClass="rgRow row_detail" />
                <ParentTableRelation>
                    <telerik:GridRelationFields DetailKeyField="NOCOMP" MasterKeyField="NOCOMP" />
                    <telerik:GridRelationFields DetailKeyField="CDART" MasterKeyField="CDART" />
                </ParentTableRelation>
                <Columns>
                    <telerik:GridBoundColumn UniqueName="DetailNoComp" DataField="NOCOMP" Visible="false" />
                    <telerik:GridBoundColumn UniqueName="DetailCodeArticle" DataField="CDART" Visible="false" />
                    <telerik:GridBoundColumn HeaderText="Type de remise" DataField="CODEREM">
                        <HeaderStyle CssClass="" Width="60px" />
                    </telerik:GridBoundColumn>
                    <telerik:GridTemplateColumn>
                        <HeaderStyle CssClass="sep no_bg" Width="5px" />
                        <ItemStyle CssClass="sep no_bg" Width="5px" />
                    </telerik:GridTemplateColumn>
                    <telerik:GridBoundColumn HeaderText="Nombre d'unités Centravet" DataField="QTE" UniqueName="QteCentrav">
                        <HeaderStyle CssClass="" Width="150px" />
                    </telerik:GridBoundColumn>
                    <telerik:GridTemplateColumn HeaderText="Marge quantité Centravet">
                        <HeaderStyle CssClass="" Width="150px" />
                        <ItemTemplate>
                            <asp:Label ID="ToggleMargeQuantCentravetLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGE") %>' />
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn HeaderText="Nouvelle marge Centravet">
                        <HeaderStyle CssClass="" Width="150px" />
                        <ItemTemplate>
                            <asp:Label ID="ToggleNvelleMargeCentravetOldLtr" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGENW") %>'
                                Visible="false" />
                            <telerik:RadNumericTextBox ID="ToggleNvelleMargeCentravetTxt" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGENW") %>'
                                Columns="8" Culture="fr-FR" MaxLength="8" MinValue="0" MaxValue="99999.99" NumberFormat-DecimalDigits="2"
                                Width="60px" />
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn>
                        <HeaderStyle CssClass="sep no_bg" Width="5px" />
                        <ItemStyle CssClass="sep no_bg" Width="5px" />
                    </telerik:GridTemplateColumn>
                    <telerik:GridBoundColumn HeaderText="Nombre d'unités Alcyon" DataField="QTE1">
                        <HeaderStyle CssClass="th-detail-Al" Width="150px" />
                    </telerik:GridBoundColumn>
                    <telerik:GridTemplateColumn HeaderText="Marge quantité Alcyon">
                        <HeaderStyle CssClass="th-detail-Al" Width="150px" />
                        <ItemTemplate>
                            <asp:Label ID="ToggleMargeQuantAlcyonLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGE1") %>' />
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn>
                        <HeaderStyle CssClass="sep no_bg" Width="5px" />
                        <ItemStyle CssClass="sep no_bg" Width="5px" />
                    </telerik:GridTemplateColumn>
                    <telerik:GridBoundColumn HeaderText="Nombre d'unités Coveto" DataField="QTE2">
                        <HeaderStyle CssClass="th-detail-Co" Width="150px" />
                    </telerik:GridBoundColumn>
                    <telerik:GridTemplateColumn HeaderText="Marge quantité Coveto">
                        <HeaderStyle CssClass="th-detail-Co" Width="150px" />
                        <ItemTemplate>
                            <asp:Label ID="ToggleMargeQuantCovetoLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGE2") %>' />
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn>
                        <HeaderStyle CssClass="sep no_bg" Width="5px" />
                        <ItemStyle CssClass="sep no_bg" Width="5px" />
                    </telerik:GridTemplateColumn>
                    <telerik:GridBoundColumn HeaderText="Nombre d'unités Central x" DataField="QTE3">
                        <HeaderStyle CssClass="th-detail-Cx" Width="150px" />
                    </telerik:GridBoundColumn>
                    <telerik:GridTemplateColumn HeaderText="Marge quantité Central x">
                        <HeaderStyle CssClass="th-detail-Cx" Width="150px" />
                        <ItemTemplate>
                            <asp:Label ID="ToggleMargeQuantXLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGE3") %>' />
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn>
                        <HeaderStyle CssClass="sep no_bg" Width="5px" />
                        <ItemStyle CssClass="sep no_bg" Width="5px" />
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn HeaderText="BILAN">
                        <HeaderStyle CssClass="" Width="150px" />
                    </telerik:GridTemplateColumn>
                    <%--Colonne supplementaire de taille variable afin d'empêcher que le tableau occupe 100% de la largeur disponible--%>
                    <telerik:GridTemplateColumn>
                        <HeaderStyle CssClass="sep no_bg" />
                        <ItemStyle CssClass="sep no_bg" />
                    </telerik:GridTemplateColumn>
                </Columns>
            </telerik:GridTableView>
        </DetailTables>
        <ExpandCollapseColumn Visible="true" ExpandImageUrl="images/expand.gif" CollapseImageUrl="images/collapse.gif"
            ButtonType="ImageButton" UniqueName="ExpandColumn">
            <HeaderStyle CssClass="th-achat" Width="50px" />
            <ItemStyle CssClass="first" />
        </ExpandCollapseColumn>
        <Columns>
            <telerik:GridTemplateColumn UniqueName="SelectColumn" HeaderText="Sélection">
                <HeaderStyle CssClass="" Width="50px" />
                <ItemTemplate>
                    <asp:CheckBox ID="SelectedChk" runat="server" CausesValidation="true"></asp:CheckBox>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Quantité 12 mois mobiles" SortExpression="QTESTAT">
                <HeaderStyle Width="60px" CssClass="" />
                <ItemTemplate>
                    <asp:Label ID="QuantiteLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"QTESTAT") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="CA mobile Année N" SortExpression="CASTAT">
                <HeaderStyle CssClass="" Width="60px" />
                <ItemTemplate>
                    <asp:Label ID="CaLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"CASTAT") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Marge mobile Année N" SortExpression="MARGSTAT">
                <HeaderStyle CssClass="" Width="60px" />
                <ItemTemplate>
                    <asp:Label ID="MargeLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGSTAT") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="5">
                <HeaderStyle Width="3px" />
                <ItemStyle CssClass="sep no_bg" Width="3px"></ItemStyle>
                <ItemTemplate>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Code article" SortExpression="CDART">
                <HeaderStyle CssClass="" Width="60px" />
                <ItemTemplate>
                    <asp:Label ID="CodeArticleLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"CDART") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridBoundColumn HeaderText="Nom <br/>fournisseur" SortExpression="NOMFOUR"
                DataField="NOMFOUR">
                <HeaderStyle CssClass="" Width="100px" />
            </telerik:GridBoundColumn>
            <telerik:GridTemplateColumn HeaderText="Libellé" SortExpression="LIBRED">
                <HeaderStyle CssClass="" Width="300px" />
                <ItemStyle CssClass="leftalign" />
                <ItemTemplate>
                    <asp:Literal ID="LibelleArticleLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"LIBRED") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="5">
                <HeaderStyle Width="3px" />
                <ItemStyle CssClass="sep no_bg" Width="3px"></ItemStyle>
                <ItemTemplate>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="P.U. Net" SortExpression="PUNETHA">
                <HeaderStyle CssClass="th-achat" Width="45px" />
                <ItemTemplate>
                    <asp:Label ID="PuNetLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"PUNETHA") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="5">
                <HeaderStyle Width="3px" />
                <ItemStyle CssClass="sep no_bg" Width="3px"></ItemStyle>
                <ItemTemplate>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Marge unitaire Centravet" SortExpression="MARGEU">
                <HeaderStyle CssClass="th-vente" Width="70px" />
                <ItemTemplate>
                    <asp:Label ID="MargeUnitCentravetLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGEU") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Nouvelle marge Centravet" SortExpression="MARGENW">
                <HeaderStyle CssClass="th-vente" Width="77px" />
                <ItemTemplate>
                    <asp:Literal ID="NvelleMargeCentravetOldLtr" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGENW") %>'
                        Visible="false" />
                    <telerik:RadNumericTextBox ID="NvelleMargeCentravetTxt" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MARGENW") %>'
                        Culture="fr-FR" MaxLength="8" MinValue="-99999.999" MaxValue="99999.999" NumberFormat-DecimalDigits="3"
                        Width="60px" />
 
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Marge unitaire Alcyon" SortExpression="MACONCUR1">
                <HeaderStyle CssClass="th-detail-Al" Width="62px" />
                <ItemTemplate>
                    <asp:Literal ID="MargeAlcyonLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MACONCUR1") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Marge unitaire Coveto" SortExpression="MACONCUR2">
                <HeaderStyle CssClass="th-detail-Co" Width="62px" />
                <ItemTemplate>
                    <asp:Literal ID="MargeCovetoLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MACONCUR2") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Marge unitaire Central x" SortExpression="MACONCUR3">
                <HeaderStyle CssClass="th-detail-Cx" Width="70px" />
                <ItemTemplate>
                    <asp:Literal ID="MargeXLbl" runat="server" Text='<%# dataBinder.Eval(Container.DataItem,"MACONCUR3") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <%--Colonne supplementaire de taille variable afin d'empêcher que le tableau occupe 100% de la largeur disponible--%>
            <telerik:GridTemplateColumn HeaderText="5">
                <HeaderStyle Width="3px" />
                <ItemStyle CssClass="sep no_bg" Width="3px"></ItemStyle>
                <ItemTemplate>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="BILAN">
                <HeaderStyle CssClass="" Width="70px" />
                <ItemTemplate>
                    <telerik:RadNumericTextBox ID="BilanPrincipal" runat="server" BorderStyle="none"
                        Culture="fr-FR" MaxLength="10" NumberFormat-DecimalDigits="2" Width="80px" BackColor="Transparent"   EnabledStyle-HorizontalAlign="Center" ReadOnly="True" />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>
 
 
    <asp:SqlDataSource ID="DataSource1" runat="server" ConnectionString="......."
    ProviderName="System.Data.OleDb" SelectCommand="SELECT NOCOMP, CDART, LIBRED, LIBLONG, GTIN, LIBFAM, NOMFOUR, QTESTAT, CASTAT, MARGSTAT, QTESTATP, CASTATP,
    MARGSTATP, PUNETHA, PHACST, PUVTE, PUVTENW, MARGEU, MARGENW, PUCONCUR1, MACONCUR1, PUCONCUR2, MACONCUR2, PUCONCUR3, MACONCUR3
    FROM TARIVETTST.COMPARTI WHERE NOCOMP=?">
    <SelectParameters>
        <asp:Parameter Name="NOCOMP" />
    </SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="DataSource2" runat="server" ConnectionString="....."
    ProviderName="System.Data.OleDb" SelectCommand="select NOCOMP, CDART, CODEREM, QTE, MARGE, PXREV, TAUX, MARGENW, PXREVNW, QTE1, MARGE1, PXREV1, QTE2, MARGE2, PXREV2,
    QTE3, MARGE3, PXREV3, DATDEB, DATFIN from TARIVETTST.COMPREM WHERE nocomp=? AND cdart=?" >
    <SelectParameters>
        <asp:SessionParameter Name="NOCOMP" SessionField="NOCOMP" Type="String" />
        <asp:SessionParameter Name="CDART" SessionField="CDART" Type="String" />
    </SelectParameters>
</asp:SqlDataSource>
Tsvetoslav
Telerik team
 answered on 17 Dec 2010
Narrow your results
Selected tags
Tags
+? more
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?