Telerik Forums
UI for ASP.NET AJAX Forum
or
Ask question
All Questions
Unanswered
Answered
110,746 questions
4 answers
96 views
Release Date Q2 2012 SP1
Hi, I HAD problems with Hotfix Q2 703.

In your opinion, the release 2012 Q2 SP1 rolls before August ?

Thanks,
Marco
General Discussions
Vessy
Telerik team
 answered on 18 Sep 2012
35 answers
1.8K+ views
Popup window Location?
How is the popup window location determined when editmode is set to popup?  And how can it be changed? 

I've created a simple page with a radgrid using editmode=popup.. The simple page works fine and the popup displays up near the top when edit/insert are clicked.  We moved the code to another page the uses radtabs and put the code under on of the tabs.  When clicking edit the popup edit form displays  but it must be scrolled to.  When clicking insert the popup edit form doesn't even appear.  The grid is using an EditTemplate.  Any ideas how why this is occurring and what can be done to remedy the situation?

I've looked at the documentation and searched on popup location but didn't come up with anything.  Thanks
Grid
Rob
Top achievements
Rank 1
 answered on 18 Sep 2012
1 answer
51 views
Rad Grid

Hai,

        I have used telerik controls in my Application.I have added Reference to the Dll Telerik.Web.UI.dll.I have added Prefix in Webconfig.

<add tagPrefix="telerik" namespace="Telerik.Web.UI" assembly="Telerik.Web.UI, Version=2009.3.1103.35, Culture=neutral,PublicKeyToken=121fae78165ba3d4"/>

I got the error "Unable to Create Designer Telerik.web.UI".When i searched in net,I found that i need to add Telerik.web.design.dll File.

Iam using VS 2008.Anyone pls tell me how to solve this problem?I didnt get telerik.web.design dll.is there any other way to solve this problem.Thanks in Advance

Grid
Eyup
Telerik team
 answered on 18 Sep 2012
1 answer
34 views
Rad Grid

Hai,

        I have used telerik controls in my Application.I have added Reference to the Dll Telerik.Web.UI.dll.I have added Prefix in Webconfig.

<add tagPrefix="telerik" namespace="Telerik.Web.UI" assembly="Telerik.Web.UI, Version=2009.3.1103.35, Culture=neutral,PublicKeyToken=121fae78165ba3d4"/>

I got the error "Unable to Create Designer Telerik.web.UI".When i searched in net,I found that i need to add Telerik.web.design.dll File.

Iam using VS 2008.Anyone pls tell me how to solve this problem?I didnt get telerik.web.design dll.is there any other way to solve this problem.Thanks in Advance

Grid
Eyup
Telerik team
 answered on 18 Sep 2012
6 answers
82 views
Date showing twice
I have an issue with the RadScheduler and November 4th is showing up twice in the Month View.  Any ideas why something like this would happen?

Chris
Scheduler
Plamen
Telerik team
 answered on 18 Sep 2012
1 answer
222 views
I just upgraded to version 2012.2.815.35 [this version seems missing from your version drop-down above]. Here's the error I'm getting as soon as I tries accessing a page after the upgrade. How do I re

UniqueName cannot contain spaces

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: UniqueName cannot contain spaces

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ArgumentException: UniqueName cannot contain spaces]
   Telerik.Web.UI.GridColumn.set_UniqueName(String value) +124
   UserControls_ucMatrixGrid.CreateDataTable(Int32 QuestionId) +3837
   Survey_Edit.CreateTelerikGridProgram(ReorderListItemEventArgs e, Int32 QuestionId, String ControlType) +205
   Survey_Edit.ReorderList1_ItemDataBound(Object sender, ReorderListItemEventArgs e) +1725

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +1255
   System.Delegate.DynamicInvokeImpl(Object[] args) +115
   AjaxControlToolkit.ReorderList.Invoke(Object key, EventArgs e) +114
   AjaxControlToolkit.ReorderList.CreateItem(Int32 index, Boolean dataBind, Object dataItem, ListItemType itemType, Boolean hasDragHandle) +505
   AjaxControlToolkit.ReorderList.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) +626
   System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +72
   AjaxControlToolkit.ReorderList.PerformDataBinding(IEnumerable data) +33
   System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +147
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +261
   Survey_Edit.BindData_Question(String s, Int32 rebind, Int32 pagenum) +4836
   Survey_Edit.Page_Load(Object sender, EventArgs e) +21777
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +42
   System.Web.UI.Control.OnLoad(EventArgs e) +132
   System.Web.UI.Control.LoadRecursive() +66
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428

Version Information: Microsoft .NET Framework Version:2.0.50727.3634; ASP.NET Version:2.0.50727.3634 
Editor
Pavlina
Telerik team
 answered on 18 Sep 2012
1 answer
122 views
RadAjaxManager ResponseScripts are empty after a PostBack()
Hi,

I've a page which contains a panel with a button to show/hide another panel and proceed to their update in the same time. I use RadAjaxManagerProxy and AjaxSetting to do that.

When I click the first time on the button, the update works fine with loading panel, etc... and after that the button just do a show/hide interaction with JQuery function that I add in ResponseScripts of the RadAjaxManager of the Page.

Since that all work fine. But when in the header of my masterpage I click on a button and it invokes a PostBack, the responseScripts of the RadAjaxManager is empty and my JQuery interaction doesn't work.

I've check the collection of ResponseScripts before and after and I think postback clear it. Can you help me please ?
Ajax
Maria Ilieva
Telerik team
 answered on 18 Sep 2012
1 answer
80 views
RadFormDecorator Help
I have a couple of questions concerning the RadFormDecorator control.
1. how does the browser read and render the the skins for radcontrols.
2. where css generated or is the styles embedded into the page.
3. can the skins be made public accessible.

the reason that I am doing this is because i am trying to make a email and print friendly version of a page that is using radcontrols
ScriptManager and StyleSheetManager
Marin Bratanov
Telerik team
 answered on 18 Sep 2012
1 answer
273 views
javascript doesn't work after postback in ajax
Hi telerik team

i'm trying to select date from jquery calendar. i can select calendar on first time after that
i have action to postback page and i go to select calendar again it's not work.

how can i do ? help me pls 

This Code Under RadAjaxLoadingPanel ,RadAjaxManager ,RadScriptManager

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">   
    <link type="text/css" href="../Styles/ui-lightness/jquery-ui-1.8.10.custom.css" rel="stylesheet" />
    <style type="text/css">
        .demoHeaders { margin-top: 2em; }
        #dialog_link {padding: .4em 1em .4em 20px;text-decoration: none;position: relative;}
        #dialog_link span.ui-icon {margin: 0 5px 0 0;position: absolute;left: .2em;top: 50%;margin-top: -8px;}
        ul#icons {margin: 0; padding: 0;}
        ul#icons li {margin: 2px; position: relative; padding: 4px 0; cursor: pointer; float: left;  list-style: none;}
        ul#icons span.ui-icon {float: left; margin: 0 4px;}
        ul.test {list-style:none; line-height:30px;}
    </style>
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
 
   <telerik:RadCodeBlock id="RadCodeBlock1" runat="server">
      <script type="text/javascript">
          function openPopup(typeofv) {
              //alert(obj.name);
              var pageURL = "ItemMaster_Search.aspx?typeofv=" + typeofv;
              var w = 750;
              var h = 600;
              var left = (screen.width / 2) - (w / 2);
              var top = (screen.height / 2) - (h / 2);
              window.open(pageURL, '', 'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=no, copyhistory=no, width=' + w + ', height=' + h + ', top=' + top + ', left=' + left);
 
              //var value = obj.value;
              //window.open('ItemMaster_Search.aspx?txtName=' + value, null, 'height=600,width=750,status=yes,toolbar=no,menubar=no,location=no');
              return false;
          }
       </script>
     
        <script type="text/javascript" src="../js/jquery-1.4.4.min.js"></script>
        <script type="text/javascript" src="../js/jquery-ui-1.8.10.offset.datepicker.min.js"></script>
        <script type="text/javascript">
           
            $(function () {
                var d = new Date();
                var toDay = d.getDate() + '/' + (d.getMonth() + 1) + '/' + (d.getFullYear() + 543);
                // กรณีต้องการใส่ปฏิทินลงไปมากกว่า 1 อันต่อหน้า ก็ให้มาเพิ่ม Code ที่บรรทัดด้านล่างด้วยครับ (1 ชุด = 1 ปฏิทิน)
                $("#MainContent_from_DT").datepicker({ changeMonth: true, changeYear: true, dateFormat: 'dd/mm/yy', isBuddhist: true, defaultDate: toDay, dayNames: ['อาทิตย์', 'จันทร์', 'อังคาร', 'พุธ', 'พฤหัสบดี', 'ศุกร์', 'เสาร์'],
                    dayNamesMin: ['อา.', 'จ.', 'อ.', 'พ.', 'พฤ.', 'ศ.', 'ส.'],
                    monthNames: ['มกราคม', 'กุมภาพันธ์', 'มีนาคม', 'เมษายน', 'พฤษภาคม', 'มิถุนายน', 'กรกฎาคม', 'สิงหาคม', 'กันยายน', 'ตุลาคม', 'พฤศจิกายน', 'ธันวาคม'],
                    monthNamesShort: ['ม.ค.', 'ก.พ.', 'มี.ค.', 'เม.ย.', 'พ.ค.', 'มิ.ย.', 'ก.ค.', 'ส.ค.', 'ก.ย.', 'ต.ค.', 'พ.ย.', 'ธ.ค.']
                });
 
                $("#MainContent_To_DT").datepicker({ changeMonth: true, changeYear: true, dateFormat: 'dd/mm/yy', isBuddhist: true, defaultDate: toDay, dayNames: ['อาทิตย์', 'จันทร์', 'อังคาร', 'พุธ', 'พฤหัสบดี', 'ศุกร์', 'เสาร์'],
                    dayNamesMin: ['อา.', 'จ.', 'อ.', 'พ.', 'พฤ.', 'ศ.', 'ส.'],
                    monthNames: ['มกราคม', 'กุมภาพันธ์', 'มีนาคม', 'เมษายน', 'พฤษภาคม', 'มิถุนายน', 'กรกฎาคม', 'สิงหาคม', 'กันยายน', 'ตุลาคม', 'พฤศจิกายน', 'ธันวาคม'],
                    monthNamesShort: ['ม.ค.', 'ก.พ.', 'มี.ค.', 'เม.ย.', 'พ.ค.', 'มิ.ย.', 'ก.ค.', 'ส.ค.', 'ก.ย.', 'ต.ค.', 'พ.ย.', 'ธ.ค.']
                });        
 
            });
        </script>
    </telerik:RadCodeBlock>           
  
      <div>
          <table cellpadding="0" cellspacing="0"  class="tablemain" border="0">
              <tr>
                  <td class="td4Colhead">
                เริ่มวันที่ <span class="spanvalidate">*</span> </td>
                  <td class="td4Colinput">
                 <asp:TextBox ID="from_DT" runat="server" CssClass="textboxclass50"  MaxLength="10" ReadOnly="true"></asp:TextBox>
                      
                <asp:RequiredFieldValidator
                    ID="RequiredFieldValidator1" runat="server" ControlToValidate="from_DT"
                    CssClass="validater" ErrorMessage="เริ่มวันที่">*</asp:RequiredFieldValidator>
                 
                 
                  </td>
                  <td class="td4Colhead">
                ถึงวันที่   </td>
                  <td class="td4Colinput">
                     <asp:TextBox ID="To_DT" runat="server" CssClass="textboxclass50"  MaxLength="10" ReadOnly="true"></asp:TextBox>                    
                  </td>
              </tr>
                 
          </table>
 
      </div>
      <br /> 
</asp:Content>
Ajax
Vasil
Telerik team
 answered on 18 Sep 2012
1 answer
121 views
Problem with Copy and Paste when using GridNumericColumn instead of GridBoundColumn
I am using the Copy and Paste example mentioned in this thread (and in other copy and paste threads). The only thing that I change is to set AutoGenerateColumns="False" and list down the columns. Everything works like the original example.

Code that works:
ASPX
<telerik:RadCodeBlock ID="rcb1" runat="server">
    <script type="text/javascript">
         
        // ***** Begin Paste from Excel scripts.
        var lastFocused;
 
        function pasteFromExcel() {
            if (!lastFocused) return;
            var clipData = window.clipboardData.getData('Text');
            var crlf = String.fromCharCode(13) + String.fromCharCode(10);
            var table = clipData.split(crlf);
            for (var tRow = 0; tRow < table.length - 1; tRow++)
                table[tRow] = table[tRow].split(String.fromCharCode(9));
            Array.remove(table, table[table.length - 1]);
            fillTable(table);
        }
 
        function fillTable(table) {
            var pCell = lastFocused.parentNode;
            var pRow = pCell.parentNode;
            var pBody = pRow.parentNode;
            var maxRows = pBody.rows.length;
            var maxCols = pRow.cells.length;
 
            hasChanges = true;
            for (var row = 0; row < table.length; row++) {
                for (var col = 0; col < table[row].length; col++) {
                    var cCellIndex = pCell.cellIndex + col;
                    var cRowIndex = pRow.sectionRowIndex + row;
 
                    if (cRowIndex < maxRows && cCellIndex < maxCols) {
                        var cCell = pBody.rows[cRowIndex].cells[cCellIndex];
                        var pInput = cCell.getElementsByTagName("input")[0];
 
                        pInput.style.backgroundColor = "#F7FAFF";
                        pInput.value = table[row][col];
                    }
                }
            }
        }
 
        function gridFocus(e) {
            e = e || window.event;
            var target = e.target || e.srcElement;
            if (target.tagName.toLowerCase() == "input" && target.type.toLowerCase() == "text")
                lastFocused = target;
        }
 
        function clearCells(sender) {
            var radGrid = $get('<%= RadGrid1.ClientID %>');
            var inputs = radGrid.getElementsByTagName("input");
            for (var el = 0; el < inputs.length; el++) {
                if (inputs[el].type == "text") {
                    inputs[el].value = "";
                    inputs[el].style.backgroundColor = "";
                }
            }
        }
        // ***** End Paste from Excel scripts.
 
 
    </script>
 
</telerik:RadCodeBlock>
<div>
    <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server">
        <telerik:RadGrid ID="RadGrid1" runat="server" AllowMultiRowEdit="true" DataSourceID="SqlDataSource1"
            onclick="gridFocus(event)" Width="830px" ShowHeader="true" Skin="Office2007" OnColumnCreated="RadGrid1_ColumnCreated"
            AllowAutomaticUpdates="true" OnItemUpdated="RadGrid1_ItemUpdated" AutoGenerateColumns="False">
            <MasterTableView EditMode="InPlace" CommandItemDisplay="Top" TableLayout="Fixed">
                <CommandItemTemplate>
                    <div style="float: left">
                        <input type="button" value="Paste from Excel" onclick="pasteFromExcel()" />
                        <input type="button" value="Clear cells" onclick="clearCells()" />
                    </div>
                    <div style="float: right">
                        <asp:Button ID="UpdateEditedButton" CommandName="UpdateEdited" Text="Update edited items"
                            runat="server" />
                    </div>
                </CommandItemTemplate>
                <Columns>
                    <telerik:GridBoundColumn DataField="ID" DataType="System.Int32"
                        HeaderText="ID" UniqueName="ID" Visible="true" ReadOnly="True">
                        <HeaderStyle HorizontalAlign="Center" />
                        <ItemStyle HorizontalAlign="Left" />
                    </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Column1"
                            HeaderText="Column1"
                            UniqueName="Column1" Visible="true">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Column2"
                            HeaderText="Column2"
                            UniqueName="Column2" Visible="true">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Column3"
                            HeaderText="Column3"
                            UniqueName="Column3" Visible="true">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Column4"
                            HeaderText="Column4"
                            UniqueName="Column4" Visible="true">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Column5"
                            HeaderText="Column5"
                            UniqueName="Column5" Visible="true">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Column6"
                            HeaderText="Column6"
                            UniqueName="Column6" Visible="true">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Column7"
                            HeaderText="Column7"
                            UniqueName="Column7" Visible="true">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Column8"
                            HeaderText="Column8"
                            UniqueName="Column8" Visible="true">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Column9"
                            HeaderText="Column9"
                            UniqueName="Column9" Visible="true">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Column10"
                            HeaderText="Column10"
                            UniqueName="Column10" Visible="true">
                        </telerik:GridBoundColumn>
                    </Columns>
            </MasterTableView>
        </telerik:RadGrid>
    </telerik:RadAjaxPanel>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString1 %>"
        DeleteCommand="DELETE FROM [EmptyTable] WHERE [ID] = @ID" InsertCommand="INSERT INTO [EmptyTable] ([ID], [Column1], [Column2], [Column3], [Column4], [Column5], [Column6], [Column7], [Column8], [Column9], [Column10]) VALUES (@ID, @Column1, @Column2, @Column3, @Column4, @Column5, @Column6, @Column7, @Column8, @Column9, @Column10)"
        SelectCommand="SELECT * FROM [EmptyTable]" UpdateCommand="UPDATE [EmptyTable] SET [Column1] = @Column1, [Column2] = @Column2, [Column3] = @Column3, [Column4] = @Column4, [Column5] = @Column5, [Column6] = @Column6, [Column7] = @Column7, [Column8] = @Column8, [Column9] = @Column9, [Column10] = @Column10 WHERE [ID] = @ID">
        <DeleteParameters>
            <asp:Parameter Name="ID" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="Column1" Type="String" />
            <asp:Parameter Name="Column2" Type="String" />
            <asp:Parameter Name="Column3" Type="String" />
            <asp:Parameter Name="Column4" Type="String" />
            <asp:Parameter Name="Column5" Type="String" />
            <asp:Parameter Name="Column6" Type="String" />
            <asp:Parameter Name="Column7" Type="String" />
            <asp:Parameter Name="Column8" Type="String" />
            <asp:Parameter Name="Column9" Type="String" />
            <asp:Parameter Name="Column10" Type="String" />
            <asp:Parameter Name="ID" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="ID" Type="Int32" />
            <asp:Parameter Name="Column1" Type="String" />
            <asp:Parameter Name="Column2" Type="String" />
            <asp:Parameter Name="Column3" Type="String" />
            <asp:Parameter Name="Column4" Type="String" />
            <asp:Parameter Name="Column5" Type="String" />
            <asp:Parameter Name="Column6" Type="String" />
            <asp:Parameter Name="Column7" Type="String" />
            <asp:Parameter Name="Column8" Type="String" />
            <asp:Parameter Name="Column9" Type="String" />
            <asp:Parameter Name="Column10" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
</div>

.CS
protected void Page_Load(object sender, EventArgs e)
{
                for (int i = 0; i < RadGrid1.PageSize; i++)
                    RadGrid1.EditIndexes.Add(i);           
}
 
protected void RadGrid1_ColumnCreated(object sender, GridColumnCreatedEventArgs e)
{
     
    if (e.Column is GridBoundColumn)
        e.Column.Visible = (e.Column as GridBoundColumn).DataField != "ID";
     
}
 
protected void RadGrid1_ItemUpdated(object source, GridUpdatedEventArgs e)
{
    e.KeepInEditMode = true;
}

Now when I change the columns in the grid from GridBoundColumn to GridNumericColumn, here's what I find out:

1. There is an extra <span> element in the GridNumericColumn so I had to update function fillTable to go to an extra parentNode. The data is pasted on the correct cells but if you click on those cells, it removes the pasted data and reverts to the original data.

2. The edit cells changed from an inset border and each cell is slightly indented to a thin solid border where the first column is slightly indented and all succeeding columns mis-aligned. I can deal with the border style, I need to know how to remove the slight indent in the first column or at least make it look like the GridBoundColumn example.

    <telerik:RadCodeBlock ID="rcb1" runat="server">
        <script type="text/javascript">
             
            // ***** Begin Paste from Excel scripts.
            var lastFocused;
 
            function pasteFromExcel() {
                if (!lastFocused) return;
                var clipData = window.clipboardData.getData('Text');
                var crlf = String.fromCharCode(13) + String.fromCharCode(10);
                var table = clipData.split(crlf);
                for (var tRow = 0; tRow < table.length - 1; tRow++)
                    table[tRow] = table[tRow].split(String.fromCharCode(9));
                Array.remove(table, table[table.length - 1]);
                fillTable(table);
            }
 
            function fillTable(table) {
 
//Changed this line to the 2 lines below.
//                var pCell = lastFocused.parentNode;
 
                var pSpan = lastFocused.parentNode;
                var pCell = pSpan.parentNode;
 
                var pRow = pCell.parentNode;
                var pBody = pRow.parentNode;
                var maxRows = pBody.rows.length;
                var maxCols = pRow.cells.length;
 
                hasChanges = true;
                for (var row = 0; row < table.length; row++) {
                    for (var col = 0; col < table[row].length; col++) {
                        var cCellIndex = pCell.cellIndex + col;
                        var cRowIndex = pRow.sectionRowIndex + row;
 
                        if (cRowIndex < maxRows && cCellIndex < maxCols) {
                            var cCell = pBody.rows[cRowIndex].cells[cCellIndex];
                            var pInput = cCell.getElementsByTagName("input")[0];
 
                            pInput.style.backgroundColor = "#F7FAFF";
                            pInput.value = table[row][col];
                        }
                    }
                }
            }
 
            function gridFocus(e) {
                e = e || window.event;
                var target = e.target || e.srcElement;
                if (target.tagName.toLowerCase() == "input" && target.type.toLowerCase() == "text")
                    lastFocused = target;
            }
 
            function clearCells(sender) {
                var radGrid = $get('<%= RadGrid1.ClientID %>');
                var inputs = radGrid.getElementsByTagName("input");
                for (var el = 0; el < inputs.length; el++) {
                    if (inputs[el].type == "text") {
                        inputs[el].value = "";
                        inputs[el].style.backgroundColor = "";
                    }
                }
            }
            // ***** End Paste from Excel scripts.
 
 
        </script>
 
    </telerik:RadCodeBlock>
    <div>
        <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server">
            <telerik:RadGrid ID="RadGrid1" runat="server" AllowMultiRowEdit="true" DataSourceID="SqlDataSource1"
                onclick="gridFocus(event)" Width="830px" ShowHeader="true" Skin="Office2007" OnColumnCreated="RadGrid1_ColumnCreated"
                AllowAutomaticUpdates="true" OnItemUpdated="RadGrid1_ItemUpdated" AutoGenerateColumns="False">
                <MasterTableView EditMode="InPlace" CommandItemDisplay="Top" TableLayout="Fixed">
                    <editformsettings>
                        <editcolumn filtercontrolalttext="Filter EditCommandColumn column">
                        </editcolumn>
                    </editformsettings>
                    <CommandItemTemplate>
                        <div style="float: left">
                            <input type="button" value="Paste from Excel" onclick="pasteFromExcel()" />
                            <input type="button" value="Clear cells" onclick="clearCells()" />
                        </div>
                        <div style="float: right">
                            <asp:Button ID="UpdateEditedButton" CommandName="UpdateEdited" Text="Update edited items"
                                runat="server" />
                        </div>
                    </CommandItemTemplate>
                    <CommandItemSettings ExportToPdfText="Export to PDF" />
                    <rowindicatorcolumn filtercontrolalttext="Filter RowIndicator column"
                        visible="True">
                    </rowindicatorcolumn>
                    <expandcollapsecolumn filtercontrolalttext="Filter ExpandColumn column"
                        visible="True">
                    </expandcollapsecolumn>
                    <Columns>
                        <telerik:GridNumericColumn DataField="ID" DataType="System.Int32"
                            HeaderText="ID" UniqueName="ID" Visible="true" ReadOnly="True">
                        </telerik:GridNumericColumn>
                            <telerik:GridNumericColumn DataField="Column1"
                                HeaderText="Column1"
                                UniqueName="Column1" Visible="true">
                            </telerik:GridNumericColumn>
                            <telerik:GridNumericColumn DataField="Column2"
                                HeaderText="Column2"
                                UniqueName="Column2" Visible="true">
                            </telerik:GridNumericColumn>
                            <telerik:GridNumericColumn DataField="Column3"
                                HeaderText="Column3"
                                UniqueName="Column3" Visible="true">
                            </telerik:GridNumericColumn>
                            <telerik:GridNumericColumn DataField="Column4"
                                HeaderText="Column4"
                                UniqueName="Column4" Visible="true">
                            </telerik:GridNumericColumn>
                            <telerik:GridNumericColumn DataField="Column5"
                                HeaderText="Column5"
                                UniqueName="Column5" Visible="true">
                            </telerik:GridNumericColumn>
                            <telerik:GridNumericColumn DataField="Column6"
                                HeaderText="Column6"
                                UniqueName="Column6" Visible="true">
                            </telerik:GridNumericColumn>
                            <telerik:GridNumericColumn DataField="Column7"
                                HeaderText="Column7"
                                UniqueName="Column7" Visible="true">
                            </telerik:GridNumericColumn>
                            <telerik:GridNumericColumn DataField="Column8"
                                HeaderText="Column8"
                                UniqueName="Column8" Visible="true">
                            </telerik:GridNumericColumn>
                            <telerik:GridNumericColumn DataField="Column9"
                                HeaderText="Column9"
                                UniqueName="Column9" Visible="true">
                            </telerik:GridNumericColumn>
                            <telerik:GridNumericColumn DataField="Column10"
                                HeaderText="Column10"
                                UniqueName="Column10" Visible="true">
                            </telerik:GridNumericColumn>
                        </Columns>
                </MasterTableView>
                <filtermenu enableimagesprites="False">
                </filtermenu>
            </telerik:RadGrid>
        </telerik:RadAjaxPanel>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString1 %>"
            DeleteCommand="DELETE FROM [EmptyTable] WHERE [ID] = @ID" InsertCommand="INSERT INTO [EmptyTable] ([ID], [Column1], [Column2], [Column3], [Column4], [Column5], [Column6], [Column7], [Column8], [Column9], [Column10]) VALUES (@ID, @Column1, @Column2, @Column3, @Column4, @Column5, @Column6, @Column7, @Column8, @Column9, @Column10)"
            SelectCommand="SELECT * FROM [EmptyTable]" UpdateCommand="UPDATE [EmptyTable] SET [Column1] = @Column1, [Column2] = @Column2, [Column3] = @Column3, [Column4] = @Column4, [Column5] = @Column5, [Column6] = @Column6, [Column7] = @Column7, [Column8] = @Column8, [Column9] = @Column9, [Column10] = @Column10 WHERE [ID] = @ID">
            <DeleteParameters>
                <asp:Parameter Name="ID" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="Column1" Type="String" />
                <asp:Parameter Name="Column2" Type="String" />
                <asp:Parameter Name="Column3" Type="String" />
                <asp:Parameter Name="Column4" Type="String" />
                <asp:Parameter Name="Column5" Type="String" />
                <asp:Parameter Name="Column6" Type="String" />
                <asp:Parameter Name="Column7" Type="String" />
                <asp:Parameter Name="Column8" Type="String" />
                <asp:Parameter Name="Column9" Type="String" />
                <asp:Parameter Name="Column10" Type="String" />
                <asp:Parameter Name="ID" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="ID" Type="Int32" />
                <asp:Parameter Name="Column1" Type="String" />
                <asp:Parameter Name="Column2" Type="String" />
                <asp:Parameter Name="Column3" Type="String" />
                <asp:Parameter Name="Column4" Type="String" />
                <asp:Parameter Name="Column5" Type="String" />
                <asp:Parameter Name="Column6" Type="String" />
                <asp:Parameter Name="Column7" Type="String" />
                <asp:Parameter Name="Column8" Type="String" />
                <asp:Parameter Name="Column9" Type="String" />
                <asp:Parameter Name="Column10" Type="String" />
            </InsertParameters>
        </asp:SqlDataSource>
    </div>
Grid
Vasil
Telerik team
 answered on 18 Sep 2012
Narrow your results
Done
Selected tags
Tags
Grid
General Discussions
Editor
Scheduler
ComboBox
Ajax
Window
TreeView
Menu
Calendar
Chart (Obsolete)
TabStrip
Input
Dock
ToolTip
Upload (Obsolete)
AsyncUpload
WebParts for SharePoint
PanelBar
FileExplorer
Splitter
ListBox
Chart (HTML5)
Rotator
ListView
Button
ToolBar
TreeList
Sharepoint Integration
FormDecorator
Filter
Slider
ScriptManager and StyleSheetManager
UI for ASP.NET AJAX in ASP.NET MVC
AutoCompleteBox
PivotGrid
Installer and VS Extensions
Spell
Documentation and Tutorials
ImageEditor
Captcha
RibbonBar
DropDownList
OrgChart
Visual Style Builder
DropDownTree
Gantt
ColorPicker
Notification
BinaryImage
SkinManager
TileList
Wizard
SearchBox
Spreadsheet
Map
ImageGallery
Rating
DatePicker
MediaPlayer
XmlHttpPanel
Diagram
Compression
DataPager
SiteMap
CloudUpload
LightBox
Gauge
PageLayout
AjaxLoadingPanel
Navigation
SocialShare
DataForm
Persistence Framework
ClientExportManager
ProgressArea
TagCloud
CheckBox
AjaxPanel
Barcode
ClientDataSource
NumericTextBox
PdfViewer
DateTimePicker
MultiColumnComboBox
MultiSelect
RadioButtonList
MaskedTextBox
Theme Builder
Styling
ProgressBar
DateInput
Chat
ODataDataSource
MonthYearPicker
Licensing
TimePicker
LinkButton
ToggleButton
Accessibility
Label
Localization
DateRangePicker
TreeMap
Security
ImageButton
InputManager
Timeline
Card
Drawer
PushButton
Ticker
Signature
Avatar
Switch
Breadcrumb
SplitButton
DragDropManager
Stepper
FloatingActionButton
Chip
ChipList
AIPrompt
Badge
OTPInput
+? more
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Learn how
3604 3605
3606
3607 3608
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Learn how
Want to show your ninja superpower to fellow developers?
Learn how