Data in the file exported to excel is incorrect plz help me

After hours of research, I have figured out my own solution to some issues I reported earlier. So to summarize all my issues and solutions:

I experienced two major BINDING issues with fields under <EditFormSettings EditFormType="Template"><FormTemplate>:

1. DropDownList - Setting the SelectedValue property to <%# Bind("security_webpage_id") %> caused an error when clicking on the Add New Record button. The error was 'ddlWebPages' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value.

Fix: I added a blank listitem. My Dropdown tag looked like this after fix:

<asp:DropDownList ID="ddlWebPages" DataSourceID='sqlDataSourceWebpages'
                                               AppendDataBoundItems="True" DataTextField="webpage_name" DataValueField="ID"
                                               SelectedValue='<%# Bind("security_webpage_id") %>' runat="server"> 
                                      <asp:ListItem Text=" " Value=""></asp:ListItem>
                                          
</asp:DropDownList>
 
2. Checkbox - I had three checkboxes that received an error when I clicked on the Add New Record button.
The error was "Specified cast is not valid".

Fix: I created a User Control for the CheckBox and handled the passing of null value to the Checked property which is what was happening when the Add New Record button was clicked. Below is my code for the code behind and markup of the checkbox control.

Code-Behind:



Mark-up:


Registering User Control in markup file that contains the standard Checkbox;

Your Checkbox and/or Drop Down List will look like this now under the FormTemplate:

Hopefully this will help someone else not have to go through days of pain that I did over there two issues

Hi,

I get this error since I started to use Telerik controls a couple hours ago.

 JavaScript runtime error: Unable to get property 'UI' of undefined or null reference

The exception occurs on the following line:

   

One my page I use Ajax for the modal popups and update panels.
I did as people suggested in other posts, and used the design to register Telerik in the web.config as follow:


On my page I register the scriptmanager like this:
           
So now I am at a loss about what to do to make this work, and in a hurry to get things working because of deadlines.

I'm using the EditMode="PopUp" and I have script that will center the popup window over the visible portion of the screen.  Except there's a hitch: I'm not explicitly setting the height of my popup but my script relies on knowing the height of the popup object.  How can I get the height if I don't explicitly set it?

No matter how I try I always end up with the first item in args.get_item below, in my example below one of the images should be hidden on row 4, but instead it hides it on row 1 no matter what I try, the data_item seem to be correct, item or findelement does not and I´m guessing I´m finding the element to hide in the wrong manner, any tips?

Hi,

I am trying to insert and edit items in a RadGrid bound to an object datasource that is contained in a Web User Control.

I have an RadAjaxManagerProxy in the Web User Control to handle the AjaxRequests and we populate the data with objects in a collection class. The RadAjaxManagerProxy is configured so the ID of the RadGrid is set as the AjaxControlID and the ID of the RadGrid is also the AjaxUpdatedControl ControlID.


One of the columns in the RadGrid control is a GridDropDownColumn which is bound to an XmlDataSource.

I have a CommandItemTemplate which has one button in it that is used to add a new record to the underlying data object and the RadGrid.


I've followed all of the examples I can find related to inserting/updating/deleting items from the RadGrid control. I get the Edit Form to appear with the correct data if I use the Automatic Form, but if I use a FormTemplate to design my own form, I cannot set the SelectedValue property for the DropDownList. I receive an error saying that this property cannot be set declaratively. The example in the set of demos shows this property being set to the bound value in the column.

Using the Form Template that I designed, I process insert and update operations in the ItemCommand event handler. Here, I first test for the CommandName property. If it is equal to RadGrid.PerformInsertCommandName, I process it as an Insert. If it is a RadGrid.UpdateCommandName, then I process it as an Update:

 

When I click the Save button on an Inserted Item, the DropDownList always shows the SelectedIndex = 0 instead of whatever selection is made. The TextBox control shows the Text property to be empty.

 

When I click the Save button on an Updated item, the DropDownList always shows the SelectedIndex to be whatever corresponds with the previous value of that property of the object. The TextBox control always shows the origjnal value for the associated property of the object.

 

I've also tried the Automatic EditForms and have also had no luck.  In the InsertCommand event handler, I have tried two approaches:

and also this approach:

Neither approach has produced values from the EditForm for me. In both cases, I can get the name of the field, but not the value (in other words, I can find the column names but not the updated values).

I'm thinking this is an Ajax-related issue, but am unsure as to what is really going on here. I have placed a watch on the e.item object as it comes into the event handlers, but there are no values in the property reflecting the changes made on the EditForm. I see the controls, but not the associated values.

Any ideas would be very helpful at this point.

Thanks,

Charlie

Hello,

I have this grid structure, in which the field is in the PlaceHolder only have to show the insertion of a new record.

<EditFormSettings EditFormType="Template">
                <EditColumn ButtonType="ImageButton" />
                <FormTemplate>
                    <table>
                        <tr>
                            <td>Nombre de usuario: </td>
                            <td>
                                <asp:TextBox ID="login" runat="server" Text='<%# Bind("Login") %>' />
                            </td>
                        </tr>
                        <asp:PlaceHolder ID="phInsert" runat="server">
                            <tr>
                                <td>Contraseña: </td>
                                <td>
                                    <asp:TextBox ID="password" runat="server" Text='<%# Bind("Password") %>' />
                                </td>
                            </tr>
                        </asp:PlaceHolder>
                        </tr>
                    </table>
                </FormTemplate>
            </EditFormSettings>

In code -behind I have the following:

protected void RadGridUserAccount_ItemCommand(object sender, GridCommandEventArgs e)
        {
            RadGrid grid = sender as RadGrid;

            if (e.CommandName == "InitInsert")
            {
                //var gridEditFormItem = e.Item as GridEditFormItem ?? ((GridDataItem)(e.Item)).EditFormItem;
                GridItem cmdItem = grid.MasterTableView.GetItems(GridItemType.CommandItem)[0];
                //GridEditFormItem editform = (GridEditFormItem)((Telerik.Web.UI.GridDataItem)(e.Item)).EditFormItem;
                PlaceHolder insert = cmdItem.FindControl("phInsert") as PlaceHolder;
                //GridEditFormItem gridEditFormItem = (GridEditFormItem)e.Item;

                //PlaceHolder insert = (PlaceHolder)gridEditFormItem.FindControl("phInsert");
               
                insert.Visible = true;
            }
        }

This code is not working for me, always return NullReferenceException.

Would appreciate help as I have tried in many ways and I always get the same exception.

Hi,

I am trying the new media player because we are interesting by Youtube Playlist functionnality.

I've just tried the example code but it doesn't work here.

When I look why it doesn't work, I can find this :

Aucune connexion n’a pu être établie car l’ordinateur cible l’a expressément refusée 216.58.211.78:443
   à System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)

It's french but as you can guess, it just says that it cannot connect to the playlist (I've just copy-paste the demo code).

Have you any idea ?

Thanks in advance.

Hi,

I have met issues for binding RadTextBox as TreeListTemplateColumn.
1. Which sever side event can be triggered when text box value changed?
2. How to auto select current tree list row as well when the text box is focused?
3. This tree list is in the radwizard as one step. Every time I have to press enter key to fire RadTextBoxSN_TextChanged, ance once it fired, the page will automatically move to next wizard step. I wrote the manual next button event for wizard and no idea how this happened. Please help.

<telerik:TreeListTemplateColumn HeaderStyle-Width="170px" DataField="LotSerialNumber" UniqueName="LotSerialNumber" HeaderText="Lot/Serial Number">
                                                    <ItemTemplate>
                                                        <div style="text-wrap: none; word-break: keep-all; table-layout: fixed">
                                                            <telerik:RadTextBox ID="RadTextBoxSN" runat="server" OnTextChanged="RadTextBoxSN_TextChanged" ToolTip='<%# Eval("TXN_ID")%>' Text='<%# Eval("LotSerialNumber")%>' Width="125px">
                                                            </telerik:RadTextBox>
                                                            <asp:LinkButton ID="btnSearch" runat="server">
                                                    <img style="border: 0px; vertical-align: bottom" src="~/../Images/search.gif" />
                                                            </asp:LinkButton>
                                                            <asp:LinkButton ID="btnValid" runat="server" Visible="false" Enabled="false">
                                                    <img id="ImgValid" style="border: 0px; vertical-align: bottom" src="~/../Images/success.gif" />
                                                            </asp:LinkButton>
                                                            <asp:LinkButton ID="btnInvalid" runat="server" Visible="false" Enabled="false">
                                                    <img id="ImgInvalid" style="border: 0px; vertical-align: bottom" src="~/../Images/error.gif" />
                                                            </asp:LinkButton>
                                                        </div>
                                                    </ItemTemplate>
                                                </telerik:TreeListTemplateColumn>

When entering text into the AutoComplete control configured for token input type when the 12th character is entered the X button displays overlaying the last few characters entered.  Upon entering additional characters the text will shift to the left and the first few character are shifted outside the token and are not visible. Is there anyway to increase the size of the token so this does not happen? 

See attached screen shots.