Telerik Forums
UI for ASP.NET AJAX Forum
2 answers
216 views
I am trying to do Insert, Update and delete using the POP Up window. I am doing all my code (Code behind).  The question is when ever the window pops up to add or update it never closes. IT updates the database but never closes. i have press cancel in order to close it.

 <form id="form1" runat="server">
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
        <script type="text/javascript">
            function RowDblClick(sender, eventArgs) {
                sender.get_masterTableView().editItem(eventArgs.get_itemIndexHierarchical());
            }
        </script>
    </telerik:RadCodeBlock>
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
       
    </telerik:RadAjaxManager>
    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server">
    </telerik:RadAjaxLoadingPanel>
    <br />
    <div>
        <asp:Label ID="Label1" runat="server" EnableViewState="False" Font-Bold="True" ForeColor="#FF8080"></asp:Label>
        <asp:Label ID="Label2" runat="server" EnableViewState="False" Font-Bold="True" ForeColor="#00C000"></asp:Label>
    </div>




    <br />
    <telerik:RadGrid ID="RadGrid1" runat="server" Skin="Vista" CssClass="RadGrid" GridLines="None"
        AllowPaging="True" PageSize="5" AllowSorting="True" AutoGenerateColumns="False"   
        ShowStatusBar="true" AllowAutomaticDeletes="True" AllowAutomaticInserts="True"
        AllowAutomaticUpdates="True" OnNeedDataSource="RadGrid1_NeedDataSource" OnUpdateCommand="RadGrid1_UpdateCommand" OnInsertCommand="RadGrid1_InsertCommand" OnDeleteCommand="RadGrid1_DeleteCommand"  
        HorizontalAlign="NotSet" Width="681px">
        <MasterTableView CommandItemDisplay="TopAndBottom"
            DataKeyNames="ID" EditMode="PopUp">
            <Columns>
                <telerik:GridEditCommandColumn>
                </telerik:GridEditCommandColumn>
                <telerik:GridBoundColumn UniqueName="id" HeaderText="id" DataField="id">
                    <HeaderStyle Width="60px"></HeaderStyle>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn UniqueName="Fname" HeaderText="First Name" DataField="Fname">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn UniqueName="Lname" HeaderText="Last Name" DataField="Lname">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn UniqueName="City" HeaderText="City" DataField="City">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn UniqueName="Zip" HeaderText="Zip" DataField="Zip">
                </telerik:GridBoundColumn>
                <telerik:GridButtonColumn CommandName="Delete" Text="Delete" UniqueName="column">
                </telerik:GridButtonColumn>
            </Columns>
            <EditFormSettings InsertCaption="Add new item" CaptionFormatString="Edit ID: {0}"
                CaptionDataField="ID" EditFormType="Template" PopUpSettings-Modal="true">
                <FormTemplate>
                    <table id="Table1" cellspacing="1" cellpadding="1" width="250" border="0">
                        <tr>
                            <td>
                            </td>
                            <td>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                First Name:
                            </td>
                            <td>
                                <asp:TextBox ID="TextBox10" Text='<%# Bind( "Fname") %>' runat="server">
                                </asp:TextBox>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                Last Name:
                            </td>
                            <td>
                                <asp:TextBox ID="TextBox11" Text='<%# Bind( "Lname") %>' runat="server">
                                </asp:TextBox>
                            </td>
                        </tr>
                        
                       
                        <tr>
                            <td>
                                City:
                            </td>
                            <td>
                                <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind( "City") %>'>
                                </asp:TextBox>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                Zip:
                            </td>
                            <td>
                                <asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind( "Zip") %>'>
                                </asp:TextBox>
                            </td>
                        </tr>
                      
                    </table>
                    <table style="width: 100%">
                        <tr>
                            <td align="right" colspan="2">
                                <asp:Button ID="Button1" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'
                                    runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'>
                                </asp:Button>&nbsp;
                                <asp:Button ID="Button2" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancel">
                                </asp:Button>
                            </td>
                        </tr>
                    </table>
                </FormTemplate>
            </EditFormSettings>
        </MasterTableView>
        <ClientSettings>
            <ClientEvents OnRowDblClick="RowDblClick"></ClientEvents>
        </ClientSettings>
    </telerik:RadGrid>


    </form>



using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BusinessLayer;
using Telerik.Web.UI;

namespace Telerik
{
    public partial class Test : System.Web.UI.Page
    {

        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
        {
            RadGrid1.DataSource = NameManager.GetList();



        }
      
    protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e)
    {
        GridEditableItem editedItem = e.Item as GridEditableItem;
        //Get the primary key value using the DataKeyValue.
       string ID = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["ID"].ToString();
        //Access the textbox from the edit form template and store the values in string variables.
        string FirstName = (editedItem.FindControl("TextBox10") as TextBox).Text;
        string LastName = (editedItem.FindControl("TextBox11") as TextBox).Text;
        string City = (editedItem.FindControl("TextBox5") as TextBox).Text;
        string Zip = (editedItem.FindControl("TextBox6") as TextBox).Text;


        var User = new Name();
        User.id = Convert.ToInt32(ID);
        User.Fname = FirstName;
        User.Lname = LastName;
        User.City = City;
        User.Zip = Zip;
        NameManager.NameUpdate(User);

        
       
    }
    protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e)
    {
        GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item;

        //Access the textbox from the edit form template and store the values in string variables.
        string FirstName = (insertedItem.FindControl("TextBox10") as TextBox).Text;
        string LastName = (insertedItem.FindControl("TextBox11") as TextBox).Text;
        string City = (insertedItem.FindControl("TextBox5") as TextBox).Text;
        string Zip = (insertedItem.FindControl("TextBox6") as TextBox).Text;


        var User = new Name();
       // User.id = Convert.ToInt32(ID);
        User.Fname = FirstName;
        User.Lname = LastName;
        User.City = City;
        User.Zip = Zip;
        NameManager.NameInsert(User);



        
     
    }
    protected void RadGrid1_DeleteCommand(object source, GridCommandEventArgs e)
    {
       
        }
    }
}
Rajeev
Top achievements
Rank 1
 answered on 03 Dec 2012
3 answers
169 views
We are using Telerik.Wb.UI rev 2010.2.713.20, VB.NET, and IIS 7.

Following is a "telerik:RadCaptcha" element in one of our web pages:

<telerik:RadCaptcha ID="RadCaptcha1" ImageStorageLocation="Session"
           runat="server" ErrorMessage="Page not valid. The code you entered is not valid."
           ValidationGroup="vgAudio"
           ValidatedTextBoxID="rcTextBox1"
           Display="None">
           <CaptchaImage
                EnableCaptchaAudio="true"
                RenderImageOnly="true"
                ImageCssClass="rcCaptchaImage"
                BackgroundColor="#609f0a"
                TextColor="White"
                BackgroundNoise="None" />
</telerik:RadCaptcha>

We have been noticing that each time the page is refreshed/reloaded, a Captcha Image is added to the Session using a new GUID as the key.  The problem we are running into is that the session object gets very large as crawlers load this page many many time over the life of a single session.  The Session gets so large that we have to run a scheduled task to forcefully abandon the session periodically.

We have used the "CaptchaMaxTimeout" property to set the timeout to just a couple of minutes and observe that Captcha images do not seem to be removed from the cache (Session) when the timeout period expires.

How can I prevent/limit caching of Captcha images to avoid this situation?
Slav
Telerik team
 answered on 03 Dec 2012
2 answers
130 views
I am setting a label DataFormatString for my line series and I noticed that it is not taking effect. The datasource I am providing to the chart contains a score as a double. I wanted to provide the {0:F} formatter so that I do not display unnecessarily long precision. 

With the following markup:
<LabelsAppearance DataFormatString="{0:F}">
    <TextStyle Bold="true" Color="#003366" />
</LabelsAppearance>

If the data is 56.1, the label is 56

With this markup:
<LabelsAppearance>
    <TextStyle Bold="true" Color="#003366" />
</LabelsAppearance>

If the data is 56.1, the label is 56.1

Is my data format string incorrect, or is it just not working?
DuelingCats
Top achievements
Rank 2
 answered on 03 Dec 2012
3 answers
70 views
How can I set values for two handlers in a rad slider... When I move my handlers, the respective value of my handler should be displayed.. Can anyone help me??? I do not need the tool tip sample.. I want to display in two textboxes..
Slav
Telerik team
 answered on 03 Dec 2012
3 answers
181 views
I'm trying to manually insert a row into an SQL table through the RadGrid's insert row function.  My problem is that the InsertCommand event will not fire.  Here's some code:

<telerik:RadGrid ID="grdDesc" runat="server" AutoGenerateColumns="false">
    <MasterTableView CommandItemDisplay="Top" EditMode="InPlace" DataKeyNames="Descrip"
      InsertItemPageIndexAction="ShowItemOnCurrentPage" ShowHeader="false">
        <Columns>
            <telerik:GridEditCommandColumn ButtonType="PushButton" UniqueName="Edit">
            </telerik:GridEditCommandColumn>
            <telerik:GridBoundColumn DataField="Descrip" UniqueName="Descrip">
            </telerik:GridBoundColumn>
        </Columns>
    </MasterTableView>
    <ClientSettings>
        <Scrolling UseStaticHeaders="true" AllowScroll="true" />
    </ClientSettings>
</telerik:RadGrid>
 
<telerik:RadInputManager runat="server" ID="RadInputManager1" Enabled="true">
    <telerik:TextBoxSetting BehaviorID="TextBoxSetting1">
    </telerik:TextBoxSetting>
</telerik:RadInputManager>


Visual Basic code:
Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
    ...
    Dim ctxSql As LINQtoSQLDataContext = New LINQtoSQLDataContext()
 
    If chkDesc.Checked = True Then
        grdDesc.Visible = True
        Dim descrips = From c In ctxSql.COMBOBOXes Where c.fieldname = "DESCRIP" Select New With {c.descrip}
 
        grdDesc.DataSource = descrips
        grdDesc.DataBind()
    Else
        grdDesc.Visible = False
    End If
    ...
End Sub
 
 
Protected Sub grdDesc_ItemCreated(ByVal sender As Object, ByVal e As GridItemEventArgs) Handles grdDesc.ItemCreated
    If TypeOf e.Item Is GridEditableItem AndAlso (e.Item.IsInEditMode) Then
        Dim editableItem As GridEditableItem = DirectCast(e.Item, GridEditableItem)
 
        Dim textBox = (DirectCast(editableItem.EditManager.GetColumnEditor("Descrip"), GridTextBoxColumnEditor)).TextBoxControl
 
        textBox.ID = "TextBox1"
        Dim inputSetting As InputSetting = RadInputManager1.GetSettingByBehaviorID("TextBoxSetting1")
        inputSetting.TargetControls.Add(New TargetInput(textBox.UniqueID, True))
        inputSetting.InitializeOnClient = True
        inputSetting.Validation.IsRequired = True
    End If
End Sub
 
Protected Sub grdDesc_InsertCommand(sender As Object, e As Telerik.Web.UI.GridCommandEventArgs) Handles grdDesc.InsertCommand
    Dim ctxSql As LINQtoSQLDataContext = New LINQtoSQLDataContext()
 
    Dim custFileID = ctxSql.CUSTFILEs.Where(Function(c) c.CUSTNO = cboCustNew.SelectedValue).Single.CUSTFILE
 
    Dim newComboBox As COMBOBOX = New COMBOBOX()
    newComboBox.custfile = custFileID
    newComboBox.department = -1
    newComboBox.fieldname = "DESCRIP"
    newComboBox.descrip = ""
 
    ctxSql.COMBOBOXes.InsertOnSubmit(newComboBox)
End Sub

I can tell you the ItemCreated event DOES fire and runs successfully.  I just don't understand why the InsertCommand event doesn't fire.  If anybody can tell me what I'm missing, it would be appreciated.

Thanks,
Patrick
Jayesh Goyani
Top achievements
Rank 2
 answered on 03 Dec 2012
18 answers
1.1K+ views
Hello!

When I'm exporting to Excel (HTML or ExcelML) and when I'm opening exported file I'm getting this error/notification:

"The file you are trying to open, '[filename]', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"  (Yes | No | Help)

Is there any workaround (without changing registry/excel settings) for this to make excel not showing this question?

Thanks

EDIT: Ok. I've found solution for my problem here:

http://www.grinn.net/blog/dev/2008/06/file-you-are-trying-to-open-is-in.html
Daniel
Telerik team
 answered on 03 Dec 2012
2 answers
104 views



Jayesh Goyani
Top achievements
Rank 2
 answered on 03 Dec 2012
2 answers
72 views
I have a hierarchical grid that I have been implementing security on.

What I have done is limit the user to see only data they are allowed to see. So in the databind I skip over it if the user does not have access to that level of detail.  I would also like to remove the expand if they dont have access to the detailed info. Anyway to do that?
John Giblin
Top achievements
Rank 1
 answered on 03 Dec 2012
4 answers
648 views
Hi there, I have a context menu showing when the radgrid is right clicked which displays options "email user", "email mass users", "email users who have finished".

I have a radgrid which is populated with data which shows whether users have started or not started their courses. I have a column called "HasStarted" which displays false and true depending on whether or not they have started. When I right click on a row which has "HasStarted" as false I want "email user", "email mass users" to appear in the context menu and when I click on a row which has "HasStarted" as true I want "email users who have finished" to only appear in the context menu. The context menu works and the items run the correct cases just not sure how to hide and show certain items depending on the item clicked on. Any help will be appreciated thanks.


James
Top achievements
Rank 1
 answered on 03 Dec 2012
3 answers
56 views
hi,
I'm making some test on your ajax grid and I've found it great but I've found an annoying problem regarding column resize.

This problem is present in your demo as well so you can easly verify it.
Go to http://demos.telerik.com/aspnet-ajax/grid/examples/client/resizing/defaultcs.aspx

Try to resize column by clicking between "Address" and "Postal Code", all columns width are affected by this action and their width change.
Please let me know if there is a way to work around this behaviour.

thanks a lot for your help
Pavlina
Telerik team
 answered on 03 Dec 2012
Narrow your results
Selected tags
Tags
+? more
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?