Telerik Forums
UI for ASP.NET AJAX Forum
14 answers
626 views
Can I format number when export to excelML in radgrid? please tell me.

thank you telerik team.
Princy
Top achievements
Rank 2
 answered on 06 Nov 2013
5 answers
66 views
I'd been experiencing problems in IE8 when using multiple file selection, selecting >1 file in browser dialog and then immediately cancelling either uploadING files or files pending TO BE uploaded.  IE would throw an exception detailed below which would then break client side scripting.  The silverlight plugin is being used by IE.

After a lot of diagnosing I identified it to due to a possible bug caused by using multiple file selection with the UploadedFilesRendering="BelowFileInput" option on the control.

I managed to replicate this issue by testing the multiple selection example which initially had no issues cancelling files.  Then when the UploadedFilesRendering="BelowFileInput" option is added cancels are broken as described (attached broken example for reference).

Please advise if there is any workaround for this issue as I still require the layout to be such that the uploaded files are listed below the file input.  Thanks in advance.

IE exception:
Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; GTB7.5; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; InfoPath.3; .NET4.0E)
Timestamp: Tue, 15 Oct 2013 14:18:33 UTC


Message: System.NullReferenceException: Object reference not set to an instance of an object.
   at System.Windows.Browser.ManagedObjectInfo.Invoke(ManagedObject obj, InvokeType invokeType, String memberName, ScriptParam[] args)
   at System.Windows.Hosting.ManagedHost.InvokeScriptableMember(IntPtr pHandle, Int32 nMemberID, Int32 nInvokeType, Int32 nArgCount, ScriptParam[] pArgs, ScriptParam& pResult, ExceptionInfo& pExcepInfo)
Line: 12625
Char: 1
Code: 0
URI: http://localhost:56236/RadControls_AspNetAjax/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=ctl00_QsfScriptManager_TSM&compress=1&_TSM_CombinedScripts_=%3b%3bSystem.Web.Extensions%2c+Version%3d4.0.0.0%2c+Culture%3dneutral%2c+PublicKeyToken%3d31bf3856ad364e35%3aen-US%3ac9cbdec3-c810-4e87-846c-fb25a7c08002%3aea597d4b%3ab25378d2%3bTelerik.Web.UI%3aen-US%3a4401a8f1-5215-4b97-a426-3601ce0fa0ff%3a16e4e7cd%3af7645509%3b%7c%7c%3a2de754c%3a3ae6d49e%3a368ab121%3a38dcf56c%3a812a75b1%3a845d48ec%3bTelerik.Web.UI%2c+Version%3d2013.2.717.45%2c+Culture%3dneutral%2c+PublicKeyToken%3d121fae78165ba3d4%3aen-US%3a4401a8f1-5215-4b97-a426-3601ce0fa0ff%3a86526ba7%3a874f8ea2%3aa1a4383a%3a24ee1bba%3a1e771326%3aeaae47ab%3a7165f74%3a2003d0b8%3af46195d3%3ae524c98b%3a628ebdd0%3aed16cbdc%3a19620875%3a3f6e8f3f%3a68f76a79%3a52af31a4%3a2a2fc429%3ae330518b%3a8e6f0d33%3a6a6d718d%3aa7e79140
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
 
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
 
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
 
    <telerik:RadProgressManager runat="server" ID="RadProgressManager1" />
 
    <div class="qsf-demo-canvas">
        <%-- For the purpose of this demo the files are discarded.
             In order to store the uploaded files permanently set the TargetFolder property to a valid location. --%>
        <telerik:RadAsyncUpload runat="server" ID="AsyncUpload1" MultipleFileSelection="Automatic" UploadedFilesRendering="BelowFileInput" />
 
        <telerik:RadProgressArea runat="server" ID="RadProgressArea1" />
    </div>
 
</asp:Content>

Hristo Valyavicharski
Telerik team
 answered on 06 Nov 2013
1 answer
64 views
Hi,

before the DropdownTree comes up, we used RadComboBox with embedded RadTreeView in the ItemTemplate.
In the Databindings of the RadTreeView there where some nice settings like this:

<DataBindings>
<telerik:RadTreeNodeBinding CheckedField="isChecked" Expanded="True" CheckableField="isSelectable" />
 </DataBindings>


Would be nice to have this settings in the DropdownTree too.

Kind Regards

Thomas
Kate
Telerik team
 answered on 06 Nov 2013
2 answers
716 views
The rows in my grid need to be updated with the value of a checkbox. The rad dropdown gets a value, then based off of that value, the checkbox gets an assigned value of 'active'(checked) or 'not active'(unchecked). When the user clicks on 'Save', each checked box will then take the ID and associate it to the ID of the dropdown list. Debugging stops at the GridCommandItem line and throws the error `Index was outside the bounds of the array.` Can someone please help me out here? I don't work with arrays much so I don't know how to fix this.

<telerik:RadDropDownList ID="MarketDropDownList" runat="server" DefaultMessage="--Select Market--" Width="200px" DataSourceID="ddlDataSource" DataTextField="MarketName" DataValueField="MarketID" AutoPostBack="true" OnSelectedIndexChanged="MarketDropDownList_SelectedIndexChanged">
</telerik:RadDropDownList>
 
<telerik:RadGrid ID="radProductsGrid" runat="server" AllowPaging="True"
                AllowSorting="True" AutoGenerateColumns="False" GridLines="None"
                OnNeedDataSource="radProductsGrid_NeedDataSource"
                OnSortCommand="radProductsGrid_SortCommand" PageSize="100" CellSpacing="0">
  <MasterTableView AllowMultiColumnSorting="false"
                    AllowNaturalSort="false" AllowSorting="true" AutoGenerateColumns="false"
                    Width="100%">
 
                    <CommandItemTemplate>
                        <telerik:RadComboBox ID="RadComboBox1"  DataTextField="ProductID" DataValueField="ProductID" runat="server"
                        </telerik:RadComboBox>
                    </CommandItemTemplate>
  
                    <Columns>
                        <telerik:GridTemplateColumn AllowFiltering="true" HeaderText="Product in Market"
                            ReadOnly="true" UniqueName="TemplateColumnCheckBox">
                            <HeaderTemplate>
                                <asp:CheckBox ID="selectAllCheckboxes" runat="server"
                                    onClick="javascript:SelectDeselectAllCheckboxes(this);" />
                            </HeaderTemplate>
                            <ItemTemplate>
                                <asp:CheckBox ID="ProductInMarketCheckBox" runat="server" />
                                <asp:HiddenField runat="server" ID="ProductID" Value="ProductID" />
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
 
                        <telerik:GridBoundColumn AllowFiltering="true" DataField="ItemNumber"
                            HeaderText="Item Number" ReadOnly="true" SortExpression="ItemNumber"
                            UniqueName="ItemNumber">
                        </telerik:GridBoundColumn>
 
                        <telerik:GridBoundColumn AllowFiltering="true" DataField="ProductName"
                            HeaderText="Product Name" ReadOnly="true" SortExpression="ProductName"
                            UniqueName="ProductName">
                        </telerik:GridBoundColumn>
 
                        <telerik:GridBoundColumn AllowFiltering="true" DataField="CategoryName"
                            HeaderText="Category Name" ReadOnly="true" SortExpression="CategoryName"
                            UniqueName="CategoryName">
                        </telerik:GridBoundColumn>
 
                    </Columns>
  </MasterTableView>
</telerik:RadGrid>
<asp:Button ID="btnAddProductToMarket" runat="server" border="0" Text="Save" ToolTip="Select Checkbox and Add Product to Market" OnClick="btnAddProductToMarket_Click" />


protected void btnAddProductToMarket_Click(object sender, EventArgs e)
        {
            int[] myArray = new int[0];
            try
            {
                GridCommandItem cmdItem = (GridCommandItem)radProductsGrid.MasterTableView.GetItems(GridItemType.CommandItem)[0];
                RadComboBox combo = (RadComboBox)cmdItem.FindControl("RadComboBox1");
                string strtxt = combo.Text;
                foreach (GridDataItem items in radProductsGrid.Items)
                {
                    if (((CheckBox)items["TemplateColumnCheckBox"].FindControl("ProductInMarketCheckBox")).Checked)
                    {
                        HiddenField ProductID = null;
                        ProductID = (HiddenField)items.FindControl("ProductID");
                        Array.Resize(ref myArray, myArray.Length + 1);
                        myArray[myArray.Length - 1] = new int();
                        myArray[myArray.Length - 1] = int.Parse(ProductID.Value);
                        //update query
                        String ConnString = ConfigurationManager.ConnectionStrings["DBConnectingString"].ConnectionString;
                        SqlConnection conn = new SqlConnection(ConnString);
                        String query = @"UPDATE vPanel_MarketMappings SET ProductID = @ProductID, MarketID = @MarketID";
                        using (SqlCommand cmd = new SqlCommand(query,conn))
                        {
                            cmd.Parameters.AddWithValue("@ProductID", ProductID);
                            cmd.Parameters.AddWithValue("@MarketID", (CheckBox)items.FindControl("ProductInMarketCheckBox"));
                            conn.Open();
                            cmd.ExecuteNonQuery();
                            conn.Close();
                        }
                    }
                }
            }
            catch ( Exception ex )
            {
                LogException( Logging.PageType.ProductManage, Logging.MessageType.Exception, ex.ToString() );
                UIUtils.ShowMessageToUser( "OnErrorMesg", this.Page );
            }
        }
Konstantin Dikov
Telerik team
 answered on 06 Nov 2013
4 answers
960 views
Dear All,

In my application i want to add validation in insert and Update for some fields. Please let me know how to add validations in the grid. Also I have found the following code in the internet which is not working for me.
<telerik:GridBoundColumn DataField="ShipName" HeaderText="ShipName" UniqueName="ShipName">
    <ColumnValidationSettings EnableRequiredFieldValidation="true" EnableModelErrorMessageValidation="true">
        <RequiredFieldValidator ForeColor="Red" ErrorMessage="This field is required"></RequiredFieldValidator>
        <ModelErrorMessage BackColor="Red" />
    </ColumnValidationSettings>
</telerik:GridBoundColumn>


In the above code snippet i am getting an error that the ColumnValidationSettings is not supported. Please help me.
Jayesh Goyani
Top achievements
Rank 2
 answered on 06 Nov 2013
1 answer
122 views

Hi:

I am trying to emulate a given Excel pivot table with the
RadPivotGrid control. This pivot table has a calculated field used on the ‘∑ Values’ section with a ‘SUM’ aggregate function. I haven’t found a way to correctly set the PivotGridAggregateField tag. The formula for the calculated field is to divide other two fields, ex. field1/field2. What happens is that for each row Excel do: sum(field1) / sum(field2).

I am using ASP.NET 4.5, Windows 8, Internet Explorer 10.0.9200.16721, Telerik v.2013.2.717.45, C#.

The provided help will be appreciated.

Thanks!

Jose

 

 

 

Antonio Stoilkov
Telerik team
 answered on 06 Nov 2013
4 answers
248 views
Hello,

There is an issue with Radgrid excel exporting.

I have followed this example exactly http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/excelmlexport/defaultcs.aspx
except i make a call to the database on the code-behind rather than using a sqldatasource.

but on ExcelMLExportRowCreated i try to get a CellElement by cell name but it always comes back as null. i disabled autocreating columns because i create my own on the aspx page and i set a HeaderText, DataField, and UniqueName for each one. The datafield and UniqueName are the same and i use that when i call GetCellByName. Why is this not working?
What am i missing?

Please reply/fix asap.

Thanks.
Kostadin
Telerik team
 answered on 06 Nov 2013
5 answers
710 views
I have scenarios like : 
function hello() {
if(confirm("hello"))
alert("yes");
else
alert("no");
}

I wanted to confirm this confirm to radconfirm. so I wrote a code like : 
function hello(){
     showconfirm();
      if (test) {
       alert("yes");//Here I might use some local variables
      }
      else
        alert("Cancelled");//Here I might use some local variables
    }
 
  function showconfirm() {
    radconfirm("Hello", confirmCallbackFunction);
  }
  function confirmCallbackFunction(arg) {
    test = arg;
  }

As radconfirm is non-blocking so an alert with "Cancelled" is always prompted without waiting for the value set from the radconfirm.. I can't do all the works in confirmCallbackFunction function because I will have some local variables in hello() function. In this case how can I use blocking radcofirm ?

I mean , I want to block the further code processing until a button is clicked from the confirm. I want the further codes to be processed after clicking one button in confirm. Thanks in advance for your help.
Shinu
Top achievements
Rank 2
 answered on 06 Nov 2013
9 answers
67 views
When inserting flash or media in IE8, its adding two attributes (i.e. originalAttribute and originalPath) twice into the embed element, which is creating problem in rending the content. This error will occur when disabling EditorFilters.ConvertToXhtml filter. Is there any workaround for this problem?

FYI here is the generated markup:

<OBJECT classid=clsid:D27CDB6E-AE6D-11cf-96B8-444553540000 width=150 height=150>

<param name="Movie" value="/admin/static/qa3/usermedia/FrogLifeCycle.swf"/>
<param name="play" value="true"/>
<param name="quality" value="high"/>
<param name="wmode" value="transparent"/>
<param name="loop" value="false"/>
<param name="menu" value="false"/><embed src="/usermedia/FrogLifeCycle.swf" originalAttribute="src" originalPath="/usermedia/FrogLifeCycle.swf" originalAttribute="src" originalPath="/usermedia/FrogLifeCycle.swf" width="150" height="150" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" quality="high" wmode="transparent" loop="false" menu="false"></embed></OBJECT>


Thanks
Ianko
Telerik team
 answered on 06 Nov 2013
1 answer
73 views
Hello,

I saw that in Radcontrols for Winforms there is something called "Excel-like filtering". I really like it and I was wondering if it is possible to create filtering similar to "Excel-like filtering" in web application using existing components or maybe telerik is planning to create component like that. 

Regards,
Kuba.
Princy
Top achievements
Rank 2
 answered on 06 Nov 2013
Narrow your results
Selected tags
Tags
+? more
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?