Questions on UI for ASP.NET AJAX Forum

2 answers

290 views

Advanced Filtering Using Filter By Column

Hi,

We have a database that contains thousands of order records. I want to use the Filter By Column feature of the RadGrids in order to sort these columns, but getting thousands of records from the database will take too long. What I'm hoping I can do is using the RadGrid.FilterCommandName function in the ItemCommand to get both the column name and the filter text from the Filter box so that I can call a stored procedure to access the database and pull back only the data I want.

Is it possible to do that? I've tried looking at the tutorials but I can't find anything that gives me what I need, the only tutorials seem to be filtering on the data that's already in the grid and we only have the top 50 rows.

Any help you could provide would be appreciated.

Grid

answered on 15 Dec 2011

1 answer

50 views

IE, Opera does one thing-Safari,Firefox and Chrome another

this grid is read-only except for a single column - cases
when anywhere on the grid is clicked the Cases column of the row clicked opens for update
if the grid is clicked again
IE and Opera update the column, then open the Cases column of the new row clicked
Firefox, Chrome and Safari update the column but the new row is not put in Edit Mode

<body onbeforeprint="return window_onbeforeprint()" onafterprint="return window_onafterprint()">

<form id="frmEditOrderNew" method="post" runat="server">

<telerik:RadCodeBlock ID="rcBlock" runat="server">

<script type="text/javascript">

<!--

function RowDblClick(sender, eventArgs) {

idx = eventArgs.get_itemIndexHierarchical();

sender.get_masterTableView().editItem(idx);

}

function RowClick(sender, eventArgs) {

idx = eventArgs.get_itemIndexHierarchical();

sender.get_masterTableView().editItem(idx);

}

function RowDataBound(sender, args) {

var obj = args.get_dataItem();

var obje = args.get_item();

}

-->

</script>

</telerik:RadCodeBlock>

.....

<telerik:RadGrid ID="rgEditOrder" OnNeedDataSource="rgEditOrder_NeedDataSource" OnItemCommand="rgEditOrder_ItemCommand" ShowFooter="True" Skin="Sunset" runat="server">

<GroupingSettings CaseSensitive="false" />

<MasterTableView DataKeyNames="OrderSeq" AutoGenerateColumns="false" AllowSorting="true" AllowPaging="true" AllowFilteringByColumn="False" EditMode="InPlace" >

<Columns>

<telerik:GridBoundColumn UniqueName="StoreNumber" DataField="StoreNumber" HeaderText="Store #" DataFormatString="{0:#####}" DataType="System.Int32" Aggregate="None" ReadOnly="True">

<HeaderStyle Width="36px" />

</telerik:GridBoundColumn>

more columns

<telerik:GridTemplateColumn UniqueName="Qty" HeaderText="Cases" DataField="Qty" DataType="System.Int32" Aggregate="Sum" >

<ItemTemplate>

<asp:Label ID="lblQty" Text='<%# Bind("Qty") %>' Width="32px" runat="server" />

</ItemTemplate>

<EditItemTemplate>

<telerik:RadNumericTextBox ID="rntbQty"

DBValue='<%# Eval("Qty") %>' OnTextChanged="rntbQty_TextChanged" MinValue="0" MaxValue="99999" MaxLength="5" AutoPostBack="True" Width="32px" runat="server">

<NumberFormat DecimalDigits="0" GroupSeparator="" />

</telerik:RadNumericTextBox>

</EditItemTemplate>

<HeaderStyle Width="32px" />

</telerik:GridTemplateColumn>

more columns

<telerik:GridBoundColumn UniqueName="OrderSeq" DataField="OrderSeq" DataType="System.Int64" Visible="false">

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

<ClientSettings>

<ClientEvents OnRowDblClick="RowDblClick" />

<ClientEvents OnRowClick="RowClick" />

<ClientEvents OnRowDataBound="RowDataBound" />

</ClientSettings>

</telerik:RadGrid>

code behind

protected void rntbQty_TextChanged(object sender, EventArgs e)

{

RadNumericTextBox rntbQty;

GridDataItem gdItem;

GridEditableItem geItem;

DateTime ShipDate;

int Qty, iBooth, iPage, iConsolid;

double fStore, dVendor, dItemID, dNetCost;

string[] strDel = new string[1];

double[] dQty = new double[1];

WsOrderSystem wsOrder;

bool bUpdate = false;

rntbQty = (RadNumericTextBox)sender;

gdItem = rntbQty.NamingContainer as GridDataItem;

geItem = rntbQty.NamingContainer as GridEditableItem;

Qty = Convert.ToInt32(rntbQty.Value);

fStore = Convert.ToDouble(ExtractValue(geItem, "StoreNumber"));

kode

wsOrder = new WsOrderSystem();

bUpdate = wsOrder.AddToOrder(fStore, iBooth, iPage, dVendor, dNetCost, dItemID, strDel, dQty, true, iConsolid);

geItem.Edit = false;

rgEditOrder.MasterTableView.Rebind();

}

Grid

answered on 15 Dec 2011

4 answers

237 views

Problems with OnClientFileUploaded

I have a MasterPage, ContentPage Setup. The contentpage contains a RadTabStrip On one of the tabs I have created a usercontrol that contains a FileUpload control and some other controls. I and am using OnClientValidationFailed ="validationFailed" successfully however OnClientFileUploaded="fileUploaded" fails. The failure is when the control is trying to render it says that the jquery method that I assigned to the property could not be found. The method is there and will work if I put the method in the masterpage. I even tried to rebind on callbacks with no success.

UserControl Code

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="FileUpload.ascx.cs"

Inherits="MAAS.WebApplication.Controls.FileUpload" %>

<style type="text/css">

.upload-panel

{

width: 300px;

}

.info-panel

{

display: none;

margin-top: 15px;

}

</style>

<script type="text/javascript">

//<![CDATA[

function validationFailed(sender, eventArgs) {

$(".ErrorHolder").append("<p>Validation failed for '" + eventArgs.get_fileName() + "'.</p>").fadeIn("slow");

sender.deleteFileInputAt(0);

}

function fileUploadRemoved(sender, args) {

$(".ErrorHolder").append("<p>removed file '" + eventArgs.get_fileName() + "'.</p>").fadeIn("slow");

sender.deleteFileInputAt(0);

}

function fileUploaded(sender, args) {

$telerik.$(".ErrorHolder").html("");

setTimeout(function() {

sender.deleteFileInputAt(0);

}, 10);

}

//Re-bind for callbacks

var prm = Sys.WebForms.PageRequestManager.getInstance();

prm.add_endRequest(function() {

fileUploaded(sender, args);

});

//]]>

</script>

<telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy_BatchImport" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="BtnSubmit">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="ImportedPolicyRadGrid" LoadingPanelID="RadAjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

<%-- <telerik:AjaxSetting AjaxControlID="ImportedPolicyRadGrid">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="ImportedPolicyRadGrid" LoadingPanelID="RadAjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>--%>

</AjaxSettings>

</telerik:RadAjaxManagerProxy>

<br />

<p>

Select files to upload (xls, xlsx)

</p>

<div class="upload-panel">

<telerik:RadProgressManager runat="server" ID="RadProgressManager1" />

<telerik:RadAsyncUpload runat="server" ID="RadAsyncUpload1" MultipleFileSelection="Disabled"

OnClientValidationFailed="validationFailed"

OnClientFileUploaded="fileUploaded"

AllowedFileExtensions="xls, xlsx" AutoAddFileInputs="True">

<FileFilters>

<telerik:FileFilter Description="*.xls; *. xlsx" Extensions="xls, xlsx"></telerik:FileFilter>

</FileFilters>

</telerik:RadAsyncUpload>

<telerik:RadProgressArea runat="server" ID="RadProgressArea1">

</telerik:RadProgressArea>

</div>

<div class="ErrorHolder">

</div>

<asp:Button runat="server" ID="BtnSubmit" Text="Submit" OnClick="BtnSubmit_OnClick" />

<asp:PlaceHolder ID="PlaceHolder1" runat="server" Visible="false">

<telerik:RadGrid ID="ImportedPolicyRadGrid" runat="server" Width="97%" PageSize="15"

AllowPaging="True" OnPageIndexChanged="ImportedPolicyRadGrid_PageIndexChanged"

CellSpacing="0" GridLines="None" Skin="Web20">

<MasterTableView Width="100%" Summary="RadGrid table">

</MasterTableView>

<PagerStyle Mode="NextPrevAndNumeric" />

<ClientSettings>

<Scrolling AllowScroll="True" UseStaticHeaders="True" />

</ClientSettings>

</telerik:RadGrid>

<br />

<asp:Button runat="server" ID="SaveBatch" Text="Save Batch" OnClick="SaveBatch_OnClick" />

</asp:PlaceHolder>

Content Page Code

<%@ Page Title="" Language="C#" MasterPageFile="~/MAASDefault.Master" AutoEventWireup="true"

CodeBehind="PolicyManagement.aspx.cs" Inherits="MAAS.WebApplication.PolicyManagement" %>

<%@ MasterType VirtualPath="MAASDefault.master" %>

<%@ Reference VirtualPath="MAASDefault.master" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">

</asp:Content>

<asp:Content ID="Content2" runat="server" ContentPlaceHolderID="MainContentTitle">

Policy Adjustments Management</asp:Content>

<asp:Content ID="Content3" runat="server" ContentPlaceHolderID="MainContent">

<telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy1" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="RadTabStrip1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadTabStrip1" />

<telerik:AjaxUpdatedControl ControlID="RadMultiPage1" LoadingPanelID="RadAjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="RadMultiPage1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadMultiPage1" LoadingPanelID="RadAjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManagerProxy>

<telerik:RadTabStrip runat="server" ID="RadTabStrip1" Orientation="HorizontalTop"

OnClientTabSelecting="onTabSelecting" MultiPageID="RadMultiPage1" CssClass=""

OnTabClick="RadTabStrip1_OnTabClick">

</telerik:RadTabStrip>

<telerik:RadMultiPage runat="server" ID="RadMultiPage1" SelectedIndex="0" Height="100%"

Width="100%" CssClass="" OnPageViewCreated="RadMultiPage1_PageViewCreated">

</telerik:RadMultiPage>

<%-- <div id="textDiv" style="font: 1em/1.2em 'Arial', sans-serif;" ondblclick="OpenAddAdjustmentWindow()">

<p>

<strong>Test Adjustment Addition Form</strong></p>

</div>

<br />

--%>

<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

<script type="text/javascript">

//<![CDATA[

function OpenAddAdjustmentWindow() {

radopen("Controls/AdjustmentWorkFlow/NewAdjustment.aspx", "AddAdjustmentDialog");

}

function OpenAddAdjustmentPage() {

window.open("Controls/AdjustmentWorkFlow/NewAdjustment.aspx", "AddAdjustmentDialog");

}

function onTabSelecting(sender, args) {

if (args.get_tab().get_pageViewID()) {

args.get_tab().set_postBack(false);

}

function validationFailed(sender, eventArgs) {

$(".ErrorHolder").append("<p>File extension validation failed for '" + eventArgs.get_fileName() + "'.</p>").fadeIn("slow");

}

function onRequestStart(sender, args) {

if (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0) {

args.set_enableAjax(false);

}

var imageButtonPath = null;

function RowDblClicked(sender, eventArgs) {

var grid = sender;

var rowIndex = eventArgs.get_itemIndexHierarchical();

if (rowIndex.indexOf(':') != -1) {

rowIndex = rowIndex.substr(rowIndex.lastIndexOf('_') + 1);

}

var tableView = eventArgs.get_tableView();

var row = tableView.get_dataItems()[rowIndex];

if (tableView.getCellByColumnUniqueName(row, "ExpandColumn")) {

var imageButton;

if (row.get_expanded() == false) {

row.set_expanded(true);

imageButton = tableView.getCellByColumnUniqueName(row, "ExpandColumn").childNodes[0];

imageButton.className = "rgCollapse";

}

else {

row.set_expanded(false);

imageButton = tableView.getCellByColumnUniqueName(row, "ExpandColumn").childNodes[0];

imageButton.className = "rgExpand";

}

//]]>

</script>

</telerik:RadCodeBlock>

</asp:Content>

<asp:Content ID="Content4" runat="server" ContentPlaceHolderID="RadWindowControlContent">

<telerik:RadWindowManager ID="RadWindowManager1" runat="server">

<Windows>

<telerik:RadWindow ID="AddAdjustmentDialog" runat="server" Title="Editing record"

Height="500px" Width="757px" Left="250px" ReloadOnShow="false" ShowContentDuringLoad="false"

Modal="true" VisibleStatusbar="false" />

</Windows>

</telerik:RadWindowManager>

</asp:Content>

AsyncUpload

answered on 15 Dec 2011

1 answer

109 views

RadProgress not showing

I am having some trouble using RadProgressArea and RadProgressManager with the RadUpload control. When i run it in VS it works fine, and the progressbar shows while uploading. When i publish it to IIS however, the file uploads but the progressbar does not show. I have looked through the suggestions here:http://www.telerik.com/help/aspnet-ajax/upload-troubleshooting-no-radprogressarea.html
But none of those options seems to be right. Also, i use several other RadControls that i have no issues with after deployment, so the telerik dll should be available.
Here is the entire code for my page:

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="WebForm1.aspx.vb" Inherits="ProScreen3.Publisher.WebForm1" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title></title>

</head>

<body>

<form id="form1" runat="server">

<div>

<telerik:RadScriptManager ID="RadScriptManager1" runat="server" EnablePageMethods="True" EnableScriptGlobalization="True" EnableScriptLocalization="True">

</telerik:RadScriptManager>

<telerik:RadProgressManager ID="RadProgressManager1" Runat="server" />

<br />

<telerik:RadUpload ID="RadUpload1" Runat="server" ReadOnlyFileInputs="True" Skin="Simple" MaxFileInputsCount="1" ControlObjectsVisibility="None">

<Localization Clear="Clear" Delete="Delete" Remove="Remove"

Select="Choose" />

</telerik:RadUpload>

<telerik:RadButton ID="btnUpload" runat="server"></telerik:RadButton>

<br />

<telerik:RadProgressArea Visible="true" ID="RadProgressArea1" Runat="server"

DisplayCancelButton="false" HeaderText="ProScreen"

ProgressIndicators="TotalProgressBar, TotalProgress, TotalProgressPercent, CurrentFileName, TimeElapsed, TimeEstimated, TransferSpeed">

</telerik:RadProgressArea>

<asp:Label ID="lblOut" runat="server" Text=""></asp:Label>

</div>

</form>

</body>

</html>

And the codebehind:

Imports Telerik.Web.UI

Public Class WebForm1

Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

End Sub

Private Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpload.Click

For Each file As UploadedFile In RadUpload1.UploadedFiles

lblOut.Text = file.GetName().ToString

Next

End Sub

End Class

And finally my web.config:

<?xml version="1.0"?>

<!--

For more information on how to configure your ASP.NET application, please visit

http://go.microsoft.com/fwlink/?LinkId=169433

-->

<configuration>

<location path="Telerik.Web.UI.WebResource.axd">

<system.web>

<authorization>

<allow users="*"/>

</authorization>

</system.web>

</location>

<location path="Style">

<system.web>

<authorization>

<allow users="*"/>

</authorization>

</system.web>

</location>

<system.web>

<authorization>

<deny users="?"/>

</authorization>

<authentication mode="Forms"/>

<sessionState mode="InProc"/>

<compilation debug="true" strict="false" explicit="true" targetFramework="4.0">

<assemblies>

<add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>

<add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

<add assembly="System.Speech, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

</assemblies>

</compilation>

<httpHandlers>

<add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" validate="false" />

<add path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" validate="false"/>

<add path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" validate="false"/>

<add path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" validate="false"/>

<add path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" validate="false"/>

</httpHandlers>

<pages enableSessionState="true">

<controls>

<add tagPrefix="telerik" namespace="Telerik.Web.UI" assembly="Telerik.Web.UI"/>

</controls>

</pages>

<httpModules>

<add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule" />

<add type="System.Web.SessionState.SessionStateModule" name="Session"/>

</httpModules>

<httpRuntime maxRequestLength="21081920" executionTimeout="3600"/>

</system.web>

<appSettings/>

<system.webServer>

<validation validateIntegratedModeConfiguration="false" />

<handlers>

<remove name="ChartImage_axd"/>

<remove name="Telerik_Web_UI_SpellCheckHandler_axd"/>

<remove name="Telerik_Web_UI_DialogHandler_aspx"/>

<remove name="Telerik_RadUploadProgressHandler_ashx"/>

<remove name="Telerik_Web_UI_WebResource_axd"/>

<add name="ChartImage_axd" path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" preCondition="integratedMode"/>

<add name="Telerik_Web_UI_SpellCheckHandler_axd" path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" preCondition="integratedMode"/>

<add name="Telerik_Web_UI_DialogHandler_aspx" path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" preCondition="integratedMode"/>

<add name="Telerik_RadUploadProgressHandler_ashx" path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" preCondition="integratedMode"/>

<add name="Telerik_Web_UI_WebResource_axd" verb="*" preCondition="integratedMode" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" />

</handlers>

<security >

<requestFiltering>

<requestLimits maxAllowedContentLength="1024000000" />

</requestFiltering>

</security>

</system.webServer>

</configuration>

Upload (Obsolete)

answered on 15 Dec 2011

2 answers

107 views

Iframe overlap RadContextMenu

Hi,

I have one issue with RadContextMenu and Iframe. There are 2 or 3 RadManuItems in ContextMenu. Now if one PDF document is open in Iframe and I click on ContextMenu then PDF document overlaps tha Contextt Menu. I tried to update Z-index of Context menu but did not succeed. I am using latest DLL version. Please find attached image to to get proper idea.

Thanks & Regards

Prashan Shrinal

Menu

answered on 15 Dec 2011

2 answers

152 views

Databinding GridDropDownColumn in Grid

Hello..
i want to know how to bind data in girddropdown at serverside.
below source.

aspx :
   <telerik:RadGrid ID="gv" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                    CellSpacing="0" GridLines="None" OnNeedDataSource="gv_NeedDataSource" Skin="Windows7"
                    Culture="ko-KR" OnUnload="gv_Unload" OnUpdateCommand="gv_UpdateCommand" >
                    <MasterTableView DataKeyNames="CODE_SECTION,CODE_GROUP" EditMode="InPlace">
                        <Columns>
                            <telerik:GridEditCommandColumn ButtonType="ImageButton" ItemStyle-Width="50px" />
                            <telerik:GridDropDownColumn ColumnEditorID="GridDropDownListEditor1" DataField="CODE_SECTION"
                                DropDownControlType="DropDownList" HeaderText="System" ListTextField="TEXT" ListValueField="VALUE"
                                UniqueName="Gubun" DataSourceID="????">
                            </telerik:GridDropDownColumn>
                       </Columns>
                  </MasterTableView>
</telerik:RadGrid>

C# :
i want to bind data C# code in aspx.cs, Not SqlDataSource in .aspx

Grid

answered on 15 Dec 2011

1 answer

228 views

Disable Edit button for only one row in the grid

Hi,
1. I have the grid with 7 columns, in that 4 are readonly during Edit. two of them are editable and one is the "Select" checkbox.
When I click a button external to the grid, I am triggering the initinsert event. During this, I want to copy the data as is for the readonly columns, from the row that is checked to the row that got added thru the initInsert event. How can I do this? [ Editable fields are editable here too]
2. Now that when the user enters data, if he tries to enter same data as above for the new row, then I need to allow him to do so, but should not allow him to edit the old row and need to disable the Edit button for that row.
Please suggest.
Thanks and Regards,
Deepika Karanth

Grid

answered on 15 Dec 2011

1 answer

74 views

focus update button

I have a grid with ClientSelectColumn, EditCommandColumn and In-Place editing. When a user edits a record and tabs from control to control, when they get to the last text box and click tab, the focus is set on the checkbox in the ClientSelectcolumn of the next row. Is there a way , when the user gets to the last edit textbox and hits Tab, that the Update button in the EditCommandColumn receives focus?

Grid

answered on 15 Dec 2011

2 answers

527 views

How to Clear RadTextBoxes Using C#?

hi,
i am D.Srinivasa Rao, i have a problem to Clear RadTextBox using c# in Asp.Net, in my page i have a number of RadTextBoxes and RadNumericTextBoxes. now i want to clear all RadTextBoxes, RadNumericTextBoxes using control Functions.

For TextBoxes i used the following Function to Clear all TextBoxes

protected void ClearTextBoxes(Control control)
{
foreach (Control c in control.Controls)
{
if (c is TextBox)
((TextBox)c).Text = "";
}
}

in the same way how can i clear the RadTextBoxes.

Please Help me

Thanks
D.Srinivasa Rao.

ComboBox

answered on 15 Dec 2011

1 answer

67 views

RadContextMenu on Details RadGrid

I have a Master Grid and Details Grid inside it, I can have context menu for rows in MasterGrid, but how can I set another context menu for child grid? Is this supported?

Regards
Mazdak

Grid

answered on 15 Dec 2011