Telerik Forums
UI for ASP.NET AJAX Forum
7 answers
310 views
Hello there,

I followed your selfreferencing hierarchy sample and ran into the following error:

System.Data.SyntaxErrorException: Syntax error in Lookup expression: Expecting keyword 'Parent' followed by a single column argument with possible relation qualifier: Parent[(<relation_name>)].<column_name>.

I set the EnableLinqExpressions to false, but that didn't help. Tried using different datasource implementation, but no help either.

Then I tried changing my Columnname in my objectdatasource (and corresponding MSSQL server table column) to MyParent instead of Parent. And then the problem went away.

So probably the grid is not accepting a parent - child relation defined with a column named Parent referencing the Keycolumn.

Using 2009, 3, 1314, 35 build.


Yeroon
Top achievements
Rank 2
 answered on 22 Mar 2010
3 answers
119 views
Hi ,
We are using RadControls_for_ASP.NET_AJAX_2010_1_309_dev in our site. In RadGrid control we are using MultiRowSelect property and also using context menue with it. If one row is selected and on other row if we right click , then second row also get selected. We want to deselect first row and select second row on right click.
May be we are trying to deselect any number of selected rows (could be 1 or more), on right click out side of that selection group. Can you please help us that how we can resolve this problem.

Regards,
Zeeshan
Princy
Top achievements
Rank 2
 answered on 22 Mar 2010
6 answers
224 views
I am wondering if Telerik (or someone else) has any recommendations for Http Compression modules that work with ASP.NET AJAX & Telerik controls. I've tried a few (Blowery, mbCompression), and usually ran into issues when it came to AJAX usage. Unfortunately, I am running IIS6 for the foreseeable future so using IIS7's compression is not an option. Any suggestions for a module are greatly appreciated.

Thanks!
BaiH
Top achievements
Rank 1
 answered on 22 Mar 2010
6 answers
236 views
Hi,

this is shanker am doing one project .My requirement is Radgridview one column is always in edit true It's ok fine ,It's working But when ever am change page index that  edit mode is false .how to keep edit is true always how to solve that 

This is my code 

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                 int? faciltyid = LogonDetails.Instance.sys_lclvar_default_facility_id;
                 Session["Facility_Id"] = faciltyid;
                 ExamName.DataSource = classmarksheetmanager.sch_view_exam_schedule_date(faciltyid);
                 ExamName.DataBind();
                 Class1.DataSource=studentremarks.sch_view_class_lookup(faciltyid);
                 Class1.DataBind();

                 for (int i = 0; i < mark_sheet.PageSize; i++)
                     {
                         mark_sheet.EditIndexes.Add(i);
                     }
                
            }
            
        }
        protected override int GetScreenId()
        {
            return Screens.classmarksheet;
        }

        protected void Page_PreRender(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                foreach (Telerik.WebControls.GridDataItem item in mark_sheet.Items)
                {
                   
                        item.Edit = true;
                  
                  
                }
                
            }
        }
        

        protected void mark_sheet_ItemCommand(object source, Telerik.WebControls.GridCommandEventArgs e)
        {
            if (e.CommandName == Telerik.WebControls.RadGrid.UpdateEditedCommandName)
            {
                XElement root=new XElement("mark_sheet");
                long IDNO = 1;
                for (int i = 0; mark_sheet.Items.Count > i; i++)
                {
                    int? class_student_id = int.Parse(mark_sheet.Items[i].OwnerTableView.DataKeyValues[i]["class_student_id"].ToString());
                    TextBox txtsocre = ((TextBox)mark_sheet.Items[i].Cells[5].Controls[0]) as TextBox;
                    if (txtsocre.Text != "")
                    {
                        XElement field = new XElement("csid", class_student_id);
                        XElement table = new XElement("id", IDNO);
                        XElement sorcexml = new XElement("score", txtsocre.Text);
                        table.Add(field);
                        root.Add(table);
                        (root.LastNode as XElement).Add(sorcexml);
                        IDNO++;
                        
                       
                    }
                }
                try
                {

                    string status_text = String.Empty;
                    bool res = classmarksheetmanager.sch_sproc_dml_sch_exam_result_upd(out status_text, root as XElement, Exam_Schedule_Date.SelectedValue.GetInteger());
                    if (res)
                    {
                        DisplayMessage(false, "Record updated");
                       Getdata();
                    }
                    else
                    {

                        DisplayMessage(true, "Can't update Record. Reason: " + status_text);
                    }
                }
                catch (Exception ex)
                {

                    DisplayMessage(true, "Record cannot be updated. Reason: " + ex.Message);
                }
            }
        }

        protected void Class1_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
        {
            int? faciltyid = LogonDetails.Instance.sys_lclvar_default_facility_id;
            SubjectRadcom.DataSource = classmarksheetmanager.sch_view_class_subject_lookup(Class1.SelectedValue.GetInteger(), faciltyid);
            SubjectRadcom.DataBind();
        }

        protected void Exam_Schedule_Date_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
        {
            Getdata();
        }

        protected void SubjectRadcom_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
        {
            Exam_Schedule_Date.DataSource = classmarksheetmanager.sch_view_exam_start_date_lookup(ExamName.SelectedValue.GetInteger(), Class1.SelectedValue.GetInteger(), SubjectRadcom.SelectedValue.GetInteger());
            Exam_Schedule_Date.DataBind();
        }

        public void Getdata()
        {
            mark_sheet.DataSource = classmarksheetmanager.sch_view_exam_mark_list(Exam_Schedule_Date.SelectedValue.GetInteger());
            mark_sheet.DataBind();
        }

        protected void mark_sheet_PageIndexChanged(object source, Telerik.WebControls.GridPageChangedEventArgs e)
        {
                mark_sheet.CurrentPageIndex = e.NewPageIndex;
             
                Getdata();
               
        }
How to solve that please replay


thanks and regards
shanker.B
shanker bangari
Top achievements
Rank 1
 answered on 22 Mar 2010
3 answers
154 views
Hello ,

i would like to know how to validate RadFileUpload which is inside the FormTemplate of EditFormSettings in rad grid .

i wonder if this could be possible and i was not able to find any similar post of my kind of issue.

i would like to know the client side validation and server side validation of it .

i have pasted the code which am using right now ,  you can see for the control ID -  RUPhoto

please advise your ideas.

<telerik:RadGrid ID="RadGridHodesTeam" runat="server" GridLines="None" AllowPaging="true" 
                    EnableEmbeddedSkins="false" PageSize="4" OnNeedDataSource="RadGridHodesTeam_NeedDataSource" 
                    Skin="Office2007" OnPreRender="RadGridHodesTeam_PreRender" OnInsertCommand="RadGridHodesTeam_InsertCommand"
                    <PagerStyle Mode="NextPrevAndNumeric" /> 
                    <MasterTableView TableLayout="Auto" DataKeyNames="ID,Name,Title,OfficePhone,Extension,SecondPhone,Extension1,Fax,Email" 
                        CommandItemDisplay="TopAndBottom" ShowHeader="false"
                        <ItemTemplate> 
                            <%# (((GridItem)Container).ItemIndex != 0)? "</td></tr></table>" : "" %> 
                            <asp:Panel ID="ItemContainer" CssClass='<%# (((GridItem)Container).ItemType == GridItemType.Item)? "item" : "alternatingItem" %>' 
                                runat="server" Height="200px"
                                <div class="itempadding"
                                    <table> 
                                        <tr visible="false" style="display: none;"
                                            <td> 
                                                <b>Id:</b></td
                                            <td> 
                                                <%#Eval("ID")%> 
                                            </td> 
                                        </tr> 
                                        <tr> 
                                            <td> 
                                                <b>Name:</b></td
                                            <td> 
                                                <%#Eval("Name")%> 
                                            </td> 
                                        </tr> 
                                        <tr> 
                                            <td> 
                                                <b>Title:</b></td
                                            <td> 
                                                <%# Eval("Title")%> 
                                            </td> 
                                        </tr> 
                                        <tr> 
                                            <td> 
                                                <b>Phone:</b></td
                                            <td> 
                                                <%# Eval("OfficePhone")%> 
                                            </td> 
                                        </tr> 
                                        <tr visible="false" style="display: none;"
                                            <td> 
                                                <b>Extension:</b></td
                                            <td> 
                                                <%# Eval("Extension")%> 
                                            </td> 
                                        </tr> 
                                        <tr> 
                                            <td> 
                                                <b>Mobile:</b></td
                                            <td> 
                                                <%# Eval("SecondPhone")%> 
                                            </td> 
                                        </tr> 
                                        <tr visible="false" style="display: none;"
                                            <td> 
                                                <b>Extension:</b></td
                                            <td> 
                                                <%# Eval("Extension1")%> 
                                            </td> 
                                        </tr> 
                                        <tr> 
                                            <td> 
                                                <b>Fax:</b></td
                                            <td> 
                                                <%# Eval("Fax")%> 
                                            </td> 
                                        </tr> 
                                        <tr> 
                                            <td> 
                                                <b>EMail:</b></td
                                            <td> 
                                                <%# Eval("Email")%> 
                                            </td> 
                                        </tr> 
                                    </table> 
                                    <table id="Table1" style="height: 25px; display: block;" runat="server"
                                        <tr id="trBtns"
                                            <td align="center"
                                                <href="#" onclick="openRadWindow('<%#DataBinder.Eval(Container.DataItem,"ID")%>');return false;"
                                                    Edit </a> 
                                            </td> 
                                            <td align="center"
                                                <href="#" onclick="openRadWindow1('<%#DataBinder.Eval(Container.DataItem,"ID")%>');return false;"
                                                    Delete </a> 
                                            </td> 
                                        </tr> 
                                    </table> 
                                </div> 
                            </asp:Panel> 
                        </ItemTemplate> 
                        <EditFormSettings EditFormType="Template"
                            <FormTemplate> 
                                <div style="width: 100%"
                                    <table align="center"
                                        <tr> 
                                            <td> 
                                                Name: 
                                            </td> 
                                            <td> 
                                                <telerik:RadTextBox ID="RadtxtName" runat="server"
                                                </telerik:RadTextBox> 
                                                <asp:RequiredFieldValidator ID="rfvtxtName" ControlToValidate="RadtxtName" runat="server" 
                                                    Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator></td
                                        </tr> 
                                        <tr> 
                                            <td> 
                                                Title: 
                                            </td> 
                                            <td> 
                                                <telerik:RadTextBox ID="RadTxtTitle" runat="server"
                                                </telerik:RadTextBox> 
                                                <asp:RequiredFieldValidator ID="rfvRadTxtTitle" ControlToValidate="RadTxtTitle" runat="server" 
                                                    Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator></td
                                        </tr> 
                                        <tr style="width: 200px;"
                                            <td> 
                                                Phone: 
                                            </td> 
                                            <td class="recordsfields"
                                                <telerik:RadTextBox ID="RadTxtOfficePhone" runat="server"
                                                </telerik:RadTextBox> 
                                                <asp:RequiredFieldValidator ID="rfvRadTxtOfficePhone" CssClass="padding10px" ControlToValidate="RadTxtOfficePhone" 
                                                    runat="server" Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator> 
                                                <asp:RegularExpressionValidator ID="revRadTxtOfficePhone" runat="server" ErrorMessage="Number Is Not Valid!!" 
                                                    Display="Dynamic" CssClass="padding10px" ControlToValidate="RadTxtOfficePhone" 
                                                    ValidationExpression="^[0-9-+]*$"></asp:RegularExpressionValidator></td
                                        </tr> 
                                        <tr visible="false" style="display: none;"
                                            <td> 
                                                Extension: 
                                            </td> 
                                            <td> 
                                                <telerik:RadTextBox ID="RadTxtOfficeExt" runat="server"
                                                </telerik:RadTextBox> 
                                                <asp:RegularExpressionValidator ID="revRadTxtOfficeExt" runat="server" ErrorMessage="Number Only !!" 
                                                    ControlToValidate="RadTxtOfficeExt" ValidationExpression="^\d+$"></asp:RegularExpressionValidator> 
                                                <%--<asp:RequiredFieldValidator ID="rfvRadTxtOfficeExt" ControlToValidate="RadTxtOfficeExt" 
                                                        runat="server" Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator>--%> 
                                            </td> 
                                        </tr> 
                                        <tr> 
                                            <td> 
                                                Mobile: 
                                            </td> 
                                            <td class="recordsfields"
                                                <telerik:RadTextBox ID="RadTxtSecondPhone" runat="server"
                                                </telerik:RadTextBox> 
                                                <%--<asp:RequiredFieldValidator ID="rfvRadTxtSecondPhone" ControlToValidate="RadTxtSecondPhone" 
                                                        runat="server" Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator>--%> 
                                                <asp:RegularExpressionValidator ID="revRadTxtSecondPhone" runat="server" ErrorMessage="Number Is Not Valid !!" 
                                                    CssClass="padding10px" ControlToValidate="RadTxtSecondPhone" ValidationExpression="^[0-9-+]*$"></asp:RegularExpressionValidator></td
                                        </tr> 
                                        <tr visible="false" style="display: none;"
                                            <td> 
                                                Extension: 
                                            </td> 
                                            <td> 
                                                <telerik:RadTextBox ID="RadTxtSecondExtension" runat="server"
                                                </telerik:RadTextBox> 
                                                <asp:RegularExpressionValidator ID="revRadTxtSecondExtension" runat="server" ErrorMessage=" Number Only !!" 
                                                    ControlToValidate="RadTxtSecondExtension" ValidationExpression="^\d+$"></asp:RegularExpressionValidator> 
                                                <%--<asp:RequiredFieldValidator ID="rfvRadTxtExtension" ControlToValidate="RadTxtSecondExtension" 
                                                        runat="server" Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator>--%> 
                                            </td> 
                                        </tr> 
                                        <tr> 
                                            <td> 
                                                Fax: 
                                            </td> 
                                            <td> 
                                                <telerik:RadTextBox ID="RadTxtFax" runat="server"
                                                </telerik:RadTextBox> 
                                                <%--<asp:RequiredFieldValidator ID="rfvRadTxtFax" ControlToValidate="RadTxtFax" runat="server" 
                                                    Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator>--%> 
                                                <asp:RegularExpressionValidator ID="revRadTxtFax" runat="server" ErrorMessage="Invalid Format" 
                                                    Display="Dynamic" ControlToValidate="RadTxtFax" ValidationExpression="^[0-9-+]*$"></asp:RegularExpressionValidator> 
                                            </td> 
                                        </tr> 
                                        <tr> 
                                            <td> 
                                                EMail: 
                                            </td> 
                                            <td> 
                                                <telerik:RadTextBox ID="RadTxtEmail" runat="server"
                                                </telerik:RadTextBox> 
                                                <asp:RequiredFieldValidator ID="rfvRadTxtEmail" ControlToValidate="RadTxtEmail" runat="server" 
                                                    Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator> 
                                                <asp:RegularExpressionValidator ID="revRadTxtEmail" runat="server" ErrorMessage="Email Not Valid!" 
                                                    Display="Dynamic" ControlToValidate="RadTxtEmail" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator></td
                                        </tr> 
                                        <tr> 
                                            <td> 
                                                Photo: 
                                            </td> 
                                            <td> 
                                                <telerik:RadUpload ID="RUPhoto" runat="server" ControlObjectsVisibility="None" AllowedFileExtensions=".jpg,.jpeg" 
                                                    Skin="Office2007"
                                                </telerik:RadUpload> 
                                                <br /> 
                                                <%--<asp:Label ID="lblerr" runat="server" Text="Invalid File" Visible="false" ></asp:Label>--%> 
                                                Image size should be 145 x 55 px 
                                            </td> 
                                        </tr> 
                                        <tr> 
                                            <td> 
                                                Team Member URL: 
                                            </td> 
                                            <td> 
                                                <telerik:RadTextBox ID="RadTxtTeamMember" runat="server"
                                                </telerik:RadTextBox> 
                                                <asp:RegularExpressionValidator ID="RevRadTxtTeamMember" runat="server" ErrorMessage="URL Invalid" 
                                                    ControlToValidate="RadTxtTeamMember" ValidationExpression="^(ht|f)tp(s?)\:\/\/(([a-zA-Z0-9\-\._]+(\.[a-zA-Z0-9\-\._]+)+)|localhost)(\/?)([a-zA-Z0-9\-\.\?\,\'\/\\\+&amp;%\$#_]*)?([\d\w\.\/\%\+\-\=\&amp;\?\:\\\&quot;\'\,\|\~\;]*)$"
                                                </asp:RegularExpressionValidator> 
                                            </td> 
                                        </tr> 
                                        <tr> 
                                            <td> 
                                            </td> 
                                            <td> 
                                                <asp:Button ID="btnUpdate" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>' 
                                                    runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'
                                                </asp:Button> 
                                                <asp:Button ID="BtnCancel" runat="server" Text="Cancel" CausesValidation="false" 
                                                    CommandName="Cancel" /></td
                                        </tr> 
                                    </table> 
                                </div> 
                            </FormTemplate> 
                        </EditFormSettings> 
                    </MasterTableView> 
                    <GroupingSettings CaseSensitive="false" /> 
                </telerik:RadGrid> 


Thanks in Advance ,

Ashok.C
Princy
Top achievements
Rank 2
 answered on 22 Mar 2010
3 answers
262 views

How to Add new Record(And Put it in Edit Mode) in GridTableView inside RadGrid Programatically

I did Add Empty Row in Grid but I am not able set it's edit index to put it in edit mode.

I use below statement.
RadGrid.EditIndexes.ChildIndexes(0,0).Add(0)

Princy
Top achievements
Rank 2
 answered on 22 Mar 2010
1 answer
73 views
Hi,

Does CDN support needs the .NET 3.5 SP1 ?

Our hosting server seems to not have SP1 installed and we got this error wich we doesn't have in DEV environment with SP1 :

Erreur du serveur dans l'application '/'.

Impossible de charger le type 'System.Web.UI.ScriptReferenceBase' à partir de l'assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.

Description : Une exception non gérée s'est produite au moment de l'exécution de la demande Web actuelle. Contrôlez la trace de la pile pour plus d'informations sur l'erreur et son origine dans le code.

Détails de l'exception: System.TypeLoadException: Impossible de charger le type 'System.Web.UI.ScriptReferenceBase' à partir de l'assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.

Erreur source:

Une exception non gérée s'est produite lors de l'exécution de la demande Web actuelle. Les informations relatives à l'origine et l'emplacement de l'exception peuvent être identifiées en utilisant la trace de la pile d'exception ci-dessous.

Trace de la pile:

[TypeLoadException: Impossible de charger le type 'System.Web.UI.ScriptReferenceBase' à partir de l'assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.]
   Telerik.Web.UI.TelerikCdnService.ResolveScriptReference(ScriptReference script) +0
   Telerik.Web.UI.RadScriptManager.OnResolveScriptReference(ScriptReferenceEventArgs e) +92
   System.Web.UI.ScriptManager.RegisterScripts() +173
   System.Web.UI.ScriptManager.OnPagePreRenderComplete(Object sender, EventArgs e) +107
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.Page.OnPreRenderComplete(EventArgs e) +8698462
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1029


Thanks for your answers.
Mab

Mab CV
Top achievements
Rank 1
 answered on 21 Mar 2010
6 answers
154 views
Hi ,

How is it possible on client side dynamically change rotator content ? 

for example, when user clicks a button, I want to make an AJAX call to a web service ,and bind a results to rotator . 

Thanks 
MOD MOD
Top achievements
Rank 1
 answered on 20 Mar 2010
2 answers
115 views
HI,

I have used telerik treeview control.
Tree view is dynamically created, which depend on database values.
I have set multiselect property to "false".
Its working fine with single Tree view but when I display  more than one instance of tree view multiple selection is possible which is confusing to the user.I want only single node to  be clicked by the user.
I have attached image showing multiple selection.
I want one node to be selected at a time.
How can I achieve this ? Please suggest me.
 
Thanks.
Rahul Khinvasara
Top achievements
Rank 1
 answered on 20 Mar 2010
1 answer
110 views
I'm not sure if this is a bug as I didn't have time to properly investigate.  I used the upgrade wizard to download the latest version (q1 2010).  It found the new version, downloaded, and extracted.  The problem was Q1 2010 wasn't listed as one of the version choices to upgrade to.  If you don't want to download it again, the files are downloaded and extracted to %appdata%\Telerik\Updates.  I just hit browse in the select version screen.  The upgrade wizard has always worked better for me (seems to manage the vs toolbox better) so I was glad to get this working.  Hope this helps others.
Erjan Gavalji
Telerik team
 answered on 20 Mar 2010
Narrow your results
Selected tags
Tags
+? more
Top users last month
Hiba
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Rakhee
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Hiba
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Rakhee
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?