Telerik Forums
UI for ASP.NET AJAX Forum
7 answers
237 views
Hi, we have a large dataset of nearly 200 columns by 250 rows. On screen, the grid presentation is normal with a row-per-record as it should be. However, when exported to Excel and opened in Excel 2008, each record shows in two rows with one row being blank. This results in a row count that is 2x what it should be.

When selecting an individual data item in the resulting excel file, two cells are selected.

The data does not appear to be grouped, at least as far as Excel is concerned.

We have attempted a variety of 'tricks' in Excel to remove the extra rows, but none are perfect and some result in lost data.

Is the issue (2 rows in excel) known and if so, how can we resolve this so that ideally, the excel file appears as it does on screen? We are using .net 2 framework and telerik 2010 Q1 (2010.1.309.20) for this application. Thanks.

Daniel
Telerik team
 answered on 17 Feb 2011
9 answers
162 views
I have a hierarchy grid with master and detail grid. I need to be able to insert and update the detail grid. There are 2 checkboxes that if one is checked then the other one should not be checked. How do I validate or make this happen? Please help.
Thanks!
illumination
Top achievements
Rank 2
 answered on 17 Feb 2011
0 answers
74 views
EDITED: Nevermind. Programmer error.
Lorne
Top achievements
Rank 1
 asked on 17 Feb 2011
3 answers
154 views
I just deployed my web app and I am getting javascript errors, when I run it in VS .NET 2010 and on my local machine's IIS it's fine but when I deploy it to our test server I get this error.

"Webpage error details

Message: 'Sys' is undefined
Line: 79
Char: 1
Code: 0

Message: 'Sys' is undefined
Line: 201
Char: 1
Code: 0

"

the offending line is:

<script type="text/javascript">
//<![CDATA[
Sys.WebForms.PageRequestManager._initialize('RadScriptManager1', 'form1', ['trgSpeakersPanel','','trgSponsorsPanel','','tRadAjaxManager1SU',''], [], [], 90, '');
//]]>
</script>

I have searched this topic with no fixes working yet I do know there are legacy apps running on this that use an older version of Telerik controls. I am using VS.NET 2010 and .net framework 4.0.

Thanks
Clark
Top achievements
Rank 1
 answered on 17 Feb 2011
3 answers
331 views
Hi all,

I'd like to display a hierarchical grid - Master/Detail (or parent/child if you will).  I've created a dataset that contains the parent and child records. My dataset only returns columns I want to display...in other words, I don't want to "hard-code" columns in the HTML markup  or in the code behind. I also DON"T want to use any object datasource controls (ie: SQLDataSourceControl). Simply, I want to bind and display whatever data is in the dataset directly to the grid control.

Can you please provide me with the grid HTML and code that will allow me to bind this dataset to a grid?

        public static DataSet GetHierarchicalDataSet()
        {
                DataTable parentTable = GetParentData();  //retrieves parent data from database
                parentTable.TableName = "Parent";
                DataTable childTable = GetChildData();  //retrieves child data from database
                childTable.TableName = "Child"

                DataSet ds = new DataSet();
                ds.Tables.Add(parentTable.Copy());
                ds.Tables.Add(childTable.Copy());

                DataColumn parentColumn = ds.Tables["Parent"].Columns["ParentID"];
                DataColumn childColumn = ds.Tables["Child"].Columns["ParentID"];
                DataRelation relationship = new DataRelation("ParentChild", parentColumn, childColumn);
                ds.Relations.Add(relationship);

                return ds;
        } 





K
Top achievements
Rank 1
 answered on 17 Feb 2011
5 answers
191 views
I have a tabstrip control with 5 tabs and one multiview.

When I execute the client side js to enable and select a specific tab, the view gets selected fine, but the tab header doesn't get selected. During debugging, I have verified that the text coming back is "Sec Ins". I have also verified by the attachment, that before the "tab.enable()" was hit the "enabled" property was "false". After passing that code to enable the tab, you can see it says it's "enabled". Another attachment is how the screen looks after the js funtion is completed as I have explained above. I have also tried the findTabByValue method getting the same results.

How can I enable & select the tab header to correspond to the selected view?

Here is my html: Notice the bolding...
<code>
<telerik:RadTabStrip ID="tsPatientDemographics" runat="server" AutoPostBack="false"
                                                                                    ScrollButtonsPosition="Right" MultiPageID="RadMultiPage1" BackColor="Gray" CausesValidation="False"
                                                                                    Align="Left" Width="100%">
                                                                                    <Tabs>
                                                                                        <telerik:RadTab Text="P<u>a</u>tient" AccessKey="A" Width="60px">
                                                                                        </telerik:RadTab>
                                                                                        <telerik:RadTab Text="G<u>u</u>arantor" AccessKey="U" Width="80px">
                                                                                        </telerik:RadTab>
                                                                                        <telerik:RadTab Text="<u>P</u>ri Ins" AccessKey="P" Width="60px">
                                                                                        </telerik:RadTab>
                                                                                        <telerik:RadTab Text="<u>S</u>ec Ins" AccessKey="S" Value="Sec Ins" Width="60px"
                                                                                            Enabled="false">
                                                                                        </telerik:RadTab>
                                                                                        <telerik:RadTab Text="<u>T</u>er Ins" AccessKey="T" Value="Ter Ins" Width="70px"
                                                                                            Enabled="false">
                                                                                        </telerik:RadTab>
                                                                                    </Tabs>
                                                                                </telerik:RadTabStrip>
                                                                                <telerik:RadMultiPage ID="RadMultiPage1" runat="server" SelectedIndex="0" ScrollBars="None">
                                                                                    <telerik:RadPageView ID="RadPatientInfoView" runat="server" Width="100%" BackColor="LightGray">
                                                                                        <table width="100%" bgcolor="#F6F6F6" cellpadding="0" cellspacing="0">

</code>

Here is my js:
<code>
function selectSecTab() {
                var tabStrip = $find("<%= tsPatientDemographics.ClientID %>");
                var tab = tabStrip.findTabByText("Sec Ins");
                tab.enable();
                tab.select();
               
            }

</code>
Bill
Top achievements
Rank 2
 answered on 17 Feb 2011
2 answers
164 views
I followed the samples of show/hide column using client event, however I get js runtime error on the line "var a=this.get_columns()[b].Display=a" that says "get_column()[...] is null or not an object", i am pretty sure that I passed the right index. Any ideas?

Thanks a lot!

Shannon
Shannnon
Top achievements
Rank 1
 answered on 17 Feb 2011
2 answers
168 views
I have a web form which saves a record to the database via server-side code, but then upon postback, I want to show the RadWindow i created.  I dont want the radwindow to show initially when the page loads.  Its only when the user clicks the Save button on the form, which runs server-side code, but then I need to invoke the RadWindow to show.  How do I do this? 
Dan
Top achievements
Rank 1
 answered on 17 Feb 2011
2 answers
135 views
I've modified an existing (working) ASP webpage by adding auto spellcheck per the example code.  There are two text boxes, one of which is seldom used, so I'd rather spell check them seperately (rather than use ControlsToCheck and getting both at the same time). 

Specifically, I've added two RadSpell controls:

<telerik:RadSpell id="RadSpellRepairOnly" runat="server" controltocheck="RepairTextBox" buttontype="None" IsClientID="true" />
<telerik:RadSpell id="RadSpellInstructionsOnly" runat="server" controltocheck="InstructionsTextBox" buttontype="None" IsClientID="true" />

...two scripts:

function spellCheckRepair() {
GetRadSpell(
'<%= RadSpellRepairOnly.ClientID %>').startSpellCheck();
}

 function spellCheckInstructions() {
GetRadSpell(
'<%= RadSpellInstructionsOnly.ClientID %>').startSpellCheck();
}

 


...and modified the two textboxes accordingly:

<asp:TextBox ID="RepairTextBox" runat="server" Rows="12" Width="100%" TextMode="MultiLine" BorderColor="White" onblur="javascript: spellCheckRepair();"></asp:TextBox>

 <asp:TextBox ID="InstructionsTextBox" runat="server" Rows="6" Width="100%" TextMode="MultiLine" BorderColor="White" onblur="javascript: spellCheckInstructions();"></asp:TextBox>

 


This works, but if I jump between the text boxes more than once I get an 'out of stack space' exception and execution is halted.  Is this not a supported configuration?

 

 

 

Henry
Top achievements
Rank 1
 answered on 17 Feb 2011
3 answers
138 views
When the cursor hovers over the scheduler, how can I control how many rows are highlighted? 

In my scheduler each appt is fixed at 30 minutes in code, and the MinutesPerRow property is set to 30.  Prior to inserting an appt when I hover over the scheduler two rows highlight instead of just the single row where the appt will go.

Thanks
Mark
Peter
Telerik team
 answered on 17 Feb 2011
Narrow your results
Selected tags
Tags
+? more
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?