Questions on UI for ASP.NET AJAX Forum

1 answer

66 views

Filter values and actual query against the db

Hi:

I am creating a filtered grid and I am concerned about performance. My default query against the table has a top 200 attribute. I went into 'Sql Query Profiler' and the filter did not appear. So, are you only applying the filter against the output dataset? In which case the top 200 will not work. How can I have the actual db query limited?

Phil

Grid

answered on 06 Mar 2011

1 answer

1.0K+ views

CS0103: The control name does not exist in the current context

hi
I have a this error when use script for get clientid of control
CS0103: The name 'RadTextBox1' does not exist in the current context

Line 271:        function SetCalendarStartTime() {
Line 272:            Calendar.setup({
Line 273:                inputField: "<%# RadTextBox1.ClientID %>",
Line 274:
Line 275:                button: "date_btn_1",

this mycode is here

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/Site.Master" AutoEventWireup="true" CodeBehind="Capsule.aspx.cs" Inherits="FireQuench.PL.Capsule" %>

<%@ Register src="../UserControl/uscMsgBox.ascx" tagname="uscMsgBox" tagprefix="uc1" %>

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

<style type="text/css">

.style1

{

width: 80%;

}

.tah

{

font-family: Tahoma;

font-size: 19pt;

</style>

</asp:Content>

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

<div id="divbody" style="width:80%; vertical-align:top; text-align:center;">

<table align="center" cellpadding="0" cellspacing="0" class="style1" dir="rtl">

<tr>

<td>

<uc1:uscMsgBox ID="msgbox" runat="server" />

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="grdParish">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="grdParish" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" />

</td>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<td>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:FireQuenchConnectionString %>"

SelectCommand="SELECT * FROM [vPart]"></asp:SqlDataSource>

<telerik:RadGrid ID="grdParish" runat="server" HorizontalAlign="Center" Skin="Outlook"

AutoGenerateColumns="False" GridLines="None" OnItemCreated="RadGrid1_ItemCreated" OnItemDataBound="RadGrid1_ItemDataBound"

onneeddatasource="grdParish_NeedDataSource" oninsertcommand="grdParish_InsertCommand"

ondeletecommand="grdParish_DeleteCommand"

onupdatecommand="grdParish_UpdateCommand">

<AlternatingItemStyle Font-Bold="False" Font-Italic="False" Font-Names="tahoma"

Font-Overline="False" Font-Size="9pt" Font-Strikeout="False"

Font-Underline="False" HorizontalAlign="Center" VerticalAlign="Middle"

Wrap="True" />

<MasterTableView DataKeyNames="iNumber" Dir="RTL" CommandItemDisplay="Top"

NoMasterRecordsText="نوع کپسول تا به حال ثبت نشده است" EnableColumnsViewState="true" EditFormSettings-ColumnNumber="3">

<RowIndicatorColumn>

<HeaderStyle Width="20px"></HeaderStyle>

</RowIndicatorColumn>

<ExpandCollapseColumn>

<HeaderStyle Width="20px"></HeaderStyle>

</ExpandCollapseColumn>

<CommandItemSettings AddNewRecordText="نوع کپسول جدید"

ShowRefreshButton="False" />

<Columns>

<telerik:GridTemplateColumn DataField="iNumber" EditFormColumnIndex="0" HeaderText="شهرستان"

UniqueName="iParishNumber">

<EditItemTemplate>

<telerik:RadComboBox ID="iParishNumberRadComboBox" runat="server"

DataTextField="strName" DataValueField="iNumber" AutoPostBack="true">

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="iParishNumberLabel" runat="server" Text='<%# Eval("strNameParish") %>'></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="بخش" EditFormColumnIndex="0"

UniqueName="iPartNumber">

<EditItemTemplate>

<telerik:RadComboBox ID="iNumberRadComboBox" runat="server"

DataTextField="strName" DataValueField="iNumber"

>

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="iNumberLabel" runat="server" Text='<%# Eval("strNamePart") %>'></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="strPhysicalPlace" EditFormColumnIndex="0" HeaderText="محل استقرار"

UniqueName="strPhysicalPlace">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn HeaderText="نوع" EditFormColumnIndex="1"

UniqueName="iCapsuleTypeNumber">

<EditItemTemplate>

<telerik:RadComboBox ID="iCapsuleTypeNumberRadComboBox" runat="server"

DataTextField="strName" DataValueField="iNumber"

>

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="iCapsuleTypeNumberLabel" runat="server" Text='<%# Eval("strNameCapsulType") %>'></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="وزن" EditFormColumnIndex="1"

UniqueName="iCapsuleWeightNumber">

<EditItemTemplate>

<telerik:RadComboBox ID="iCapsuleWeightNumberRadComboBox" runat="server"

DataTextField="strName" DataValueField="iNumber" >

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="iCapsuleWeightNumberLabel" runat="server" Text='<%# Eval("strNameCapsulWeight") %>'></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="وضعیت فعلی" EditFormColumnIndex="1"

UniqueName="iStatusNumber">

<EditItemTemplate>

<telerik:RadComboBox ID="iStatusNumberRadComboBox" runat="server" Skin="Hay"

DataTextField="strName" DataValueField="iNumber" Font-Names="tahoma" >

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="iStatusNumberLabel" runat="server" Text='<%# Eval("strNameStatus") %>'></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="iPartNumber" DataType="System.Int32"

HeaderText="iNumber2" ReadOnly="True" SortExpression="iNumber2"

UniqueName="iNumber2" ForceExtractValue="Always" Visible="False">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="iParishNumber" DataType="System.Int32"

HeaderText="iParishNumber2" ReadOnly="True" SortExpression="iParishNumber2"

UniqueName="iParishNumber2" ForceExtractValue="Always" Visible="False">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="iNumber" DataType="System.Int32"

HeaderText="iNumber" ReadOnly="True" SortExpression="iNumber"

UniqueName="iNumber" ForceExtractValue="Always" Visible="False">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="iCapsuleTypeNumber" ForceExtractValue="Always"

HeaderText="iCapsuleTypeNumber2" UniqueName="iCapsuleTypeNumber2" Visible="false" ReadOnly="true">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="iCapsuleWeightNumber" ForceExtractValue="Always"

HeaderText="iCapsuleWeightNumber2" UniqueName="iCapsuleWeightNumber2" Visible="false" ReadOnly="true">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="iStatusNumber" ForceExtractValue="Always"

HeaderText="iStatusNumber2" UniqueName="iStatusNumber2" Visible="false" ReadOnly="true">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="strChattelsCode" ForceExtractValue="Always" EditFormColumnIndex="2"

HeaderText="کد اموال" UniqueName="strChattelsCode">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="iTimeLife" ForceExtractValue="Always" EditFormColumnIndex="2"

HeaderText="طول عمر مفید" UniqueName="iTimeLife">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn DataField="strProductionDate"

EditFormColumnIndex="2" HeaderText="تاریخ تولید" UniqueName="strProductionDate">

<EditItemTemplate>

<table>

<tr>

<td>

<telerik:RadTextBox ID="RadTextBox1" runat="server" ClientIDMode="Static" AutoPostBack="true" Text='<%# Bind("strProductionDate") %>' >

</telerik:RadTextBox>

</td>

<td><img ID="date_btn_1" alt="" src="../App_Themes/Style/Images/cal.png" style="vertical-align: top;" /></td>

</tr>

</table>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="strProductionDateLabel" runat="server"

Text='<%# Eval("strProductionDate") %>' ></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridEditCommandColumn ButtonType="LinkButton" CancelText="انصراف"

EditText="ویرایش" InsertText="نوع جدید" UpdateText="ذخیره">

<HeaderStyle Font-Names="Tahoma" Font-Size="9pt" HorizontalAlign="Center"

VerticalAlign="Middle" Width="50px" />

</telerik:GridEditCommandColumn>

<telerik:GridButtonColumn CommandName="Delete" Text="حذف" UniqueName="column1">

<HeaderStyle Width="20px" />

<ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False"

Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center"

VerticalAlign="Middle" Wrap="True" />

</telerik:GridButtonColumn>

</Columns>

<EditFormSettings>

<EditColumn UniqueName="EditCommandColumn1" ButtonType="ImageButton" InsertText="ذخیره" UpdateText="ذخیره"

CancelText="انصراف"></EditColumn>

</EditFormSettings>

<ItemStyle Font-Bold="False" Font-Italic="False" Font-Names="tahoma"

Font-Overline="False" Font-Size="9pt" Font-Strikeout="False"

Font-Underline="False" HorizontalAlign="Center" VerticalAlign="Middle"

Wrap="True" />

<EditItemStyle BackColor="#CCCCFF" Font-Bold="False" Font-Italic="False"

Font-Names="tahoma" Font-Overline="False" Font-Size="9pt"

Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Right"

VerticalAlign="Middle" Wrap="True" />

<HeaderStyle Font-Bold="True" Font-Italic="False" Font-Names="tahoma"

Font-Overline="False" Font-Size="9pt" Font-Strikeout="False"

Font-Underline="False" HorizontalAlign="Center" VerticalAlign="Middle"

Wrap="True" />

</MasterTableView>

</telerik:RadGrid>

</td>

</tr>

</table>

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

<script type="text/javascript" >

Sys.WebForms.PageRequestManager.getInstance().add_endRequest(EndRequestHandler);

Sys.WebForms.PageRequestManager.getInstance().add_pageLoaded(pageLoadedHandler)

function pageLoadedHandler(sender, args)

{ SetCalendarStartTime(); }

function EndRequestHandler(sender, args)

{ SetCalendarStartTime(); }

function SetCalendarStartTime() {

Calendar.setup({

inputField: "<%# RadTextBox1.ClientID %>",

button: "date_btn_1",

ifFormat: "%Y/%m/%d",

dateType: 'jalali',

weekNumbers: false

});

}

</script>

</telerik:RadCodeBlock>

</div>

</asp:Content>

please help to me for solve this error
thank

Grid

answered on 06 Mar 2011

2 answers

118 views

[Solved] Telerik Webmail Demo Questions

I gotta say, the webmail demo that has an Outlook like appearance is very interesting and amazing to say the least....and I would like to learn how to do something like it. Only thing is, the downloadable code is not available to download like the other demos that Telerik has available. Is there a way I can download this demo code?

General Discussions

answered on 06 Mar 2011

10 answers

258 views

Fixed Resource Headers

Hi there,

I am having some difficulty figuring if it is possible to have static resource headers with the Scheduler.
So basically I want the resource headers to remain at the top of the scheduler area when scrolling vertically.
I played around a bit with the HeaderTemplate but couldn't get what I wanted, and can't find any documentation about this.

Any suggestions?

Scheduler

answered on 06 Mar 2011

2 answers

220 views

Light weight Code calendar

As a test we replace one date calendar using are old code with a teleik calendar. Rendered the HTML and did file size comparison between the two. Just one telerik calendar increased our rendered HTML 26%. Our pages need to be optimized. Is there a direction someone can point me to find an optimized, light weigh code example of the raddatepicker control?

Calendar

answered on 06 Mar 2011

8 answers

440 views

Exporting RadGrid to excel

I need to export a datatable to Excel. I have a cosume control inheridet from RadPageView. basically is a TAB with other control on it. I made a Radgid dynamically like the following:

RadGrid grid = new RadGrid { AutoGenerateColumns = true };

grid.DataSource = dt.DefaultView; // DT is a DataTable

grid.DataBind();

// I include also the grid to my Tab
div.Controls.AddAt(0, grid); // Div a div container in this TAB. by running this code i can see my grid with all columns and rows
but if i add the exportSetting, and export it doesn't show the grid (What actually I want), and no Excel file neither the code that I'm using is:

grid.ExportSettings.OpenInNewWindow = true

grid.ExportSettings.FileName = "CSV Writer

grid.MasterTableView.GridLines = GridLines.Both

grid.MasterTableView.ShowHeader = true

grid.MasterTableView.ExportToCSV();

Any help would be greatly appreciated.

Grid

answered on 05 Mar 2011

2 answers

235 views

[Solved] Not applying width and height of RadWindow from Css ?

I had a custom class in css page

.RadWindow_NewAndReply
{
   width:55%;
   height:55%;
}

and in design page i am using like this

<telerik:RadWindow
   runat="server"
   ID="Edit"
   NavigateUrl="~/Reply.aspx"
   OnClientPageLoad="onWindowLoad"
ReloadOnShow="true"
   CssClass="RadWindow_NewAndReply"
   ShowContentDuringLoad="false"
   Modal="false"
   Behaviors="Close,Move,Minimize,Maximize"
   VisibleStatusbar="false">
</telerik:RadWindow>

but its not appling.. what may be the problem?

Regards
Bhuvan

Window

answered on 05 Mar 2011

4 answers

212 views

RadRotator and RadWindow

We have a RadWindowManager on a Page. We open RadWindows using Javascript

var oManager = GetRadWindowManager();

oManager.open("./Popup.aspx", "Popup");

Everything works fine.
When I dynamically add a RadRotator to my page using the code below the RadWindow Script stops working. Instead of opening a window the page does a postback.

radRotator.ID = "twitter" + ContentItem.ContentItemId;

radRotator.CssClass = "RSSFountainClass";

radRotator.RotatorType =(TwitterRotatorType>0) ? TwitterRotatorType : RotatorType.AutomaticAdvance;

radRotator.ScrollDirection = RotatorScrollDirection.Up;

radRotator.ScrollDuration = ScrollDuration;

radRotator.FrameDuration = FrameDuration;

radRotator.ItemTemplate = new

RotatorItemTemplate(ContentItem, RSSItemTemplateClass, RSSItemDateTimeClass, RSSItemDateClass, RSSItemTimeClass, RSSItemTitleClass);

radRotator.Height = new Unit(Height, UnitType.Pixel);

radRotator.DataSource = RSSDataSource();

radRotator.InitialItemIndex = -1;

radRotator.DataBind();

Controls.Add(radRotator);

When i disable the handler, the script works again.

Below the handler code:

private class RotatorItemTemplate : ITemplate

{

Label literal;

private ContentItem ContentItem { get; set; }

private string RSSItemTemplateClass { get; set; }

private string RSSItemDateTimeClass { get; set; }

private string RSSItemDateClass { get; set; }

private string RSSItemTimeClass { get; set; }

private string RSSItemTitleClass { get; set; }

public RotatorItemTemplate(ContentItem contentItem, string rssItemTemplateClass, string rssItemDateTimeClass, string rssItemDateClass, string rssItemTimeClass, string rssItemTitleClass)

{

literal = new Label();

ContentItem = contentItem;

RSSItemTemplateClass = rssItemTemplateClass;

RSSItemDateTimeClass = rssItemDateTimeClass;

RSSItemDateClass = rssItemDateClass;

RSSItemTimeClass = rssItemTimeClass;

RSSItemTitleClass = rssItemTitleClass;

}

public void InstantiateIn(Control container)

{

literal = new Label();

literal.DataBinding += TwitterItem_ItemDataBound;

container.Controls.Add(literal);

}

/// <summary>

/// TwitterItem_ItemDataBound Method

/// </summary>

/// <param name="sender">An object</param>

/// <param name="e">An EventArgs</param>

/// <returns>A void</returns>

private void TwitterItem_ItemDataBound(object sender, EventArgs e)

{

Label labelControl = (Label)sender;

RadRotatorItem rotatorItem = (RadRotatorItem)labelControl.NamingContainer;

XPathNavigator xPathNavigator = ((IXPathNavigable)rotatorItem.DataItem).CreateNavigator();

HtmlGenericControl htmlGenericControlItem = new HtmlGenericControl();

htmlGenericControlItem.Attributes.Add("onclick", "window.open('" +

((ContentItem.FileTitle == TwitterType.Follow.ToString())

? xPathNavigator.SelectSingleNode("link").Value

: xPathNavigator.SelectSingleNode("link/@href").Value)

+ "', '_blank')");

if (!string.IsNullOrEmpty(RSSItemTemplateClass))

htmlGenericControlItem.Attributes.Add("class", RSSItemTemplateClass);

HtmlGenericControl htmlGenericControlDateTime = new HtmlGenericControl();

if (!string.IsNullOrEmpty(RSSItemDateTimeClass))

htmlGenericControlDateTime.Attributes.Add("class", RSSItemDateTimeClass);

HtmlGenericControl htmlGenericControlTime = new HtmlGenericControl();

if (!string.IsNullOrEmpty(RSSItemTimeClass))

htmlGenericControlTime.Attributes.Add("class", RSSItemTimeClass);

htmlGenericControlTime.Controls.Add(new LiteralControl(

((ContentItem.FileTitle == TwitterType.Follow.ToString())

? Convert.ToDateTime(xPathNavigator.SelectSingleNode("pubDate").Value).ToShortDateString()

: xPathNavigator.SelectSingleNode("author/name").Value))

);

HtmlGenericControl htmlGenericControlDate = new HtmlGenericControl();

if (!string.IsNullOrEmpty(RSSItemDateClass))

htmlGenericControlDate.Attributes.Add("class", RSSItemDateClass);

htmlGenericControlDate.Controls.Add(new LiteralControl(

((ContentItem.FileTitle == TwitterType.Follow.ToString())

? Convert.ToDateTime(xPathNavigator.SelectSingleNode("pubDate").Value).ToShortTimeString()

: xPathNavigator.SelectSingleNode("updated").Value))

);

htmlGenericControlDateTime.Controls.Add(htmlGenericControlDate);

htmlGenericControlDateTime.Controls.Add(htmlGenericControlTime);

htmlGenericControlItem.Controls.Add(htmlGenericControlDateTime);

HtmlGenericControl htmlGenericControlTitle = new HtmlGenericControl();

if (!string.IsNullOrEmpty(RSSItemTitleClass))

htmlGenericControlTitle.Attributes.Add("class", RSSItemTitleClass);

htmlGenericControlTitle.Controls.Add(new LiteralControl(

((ContentItem.FileTitle == TwitterType.Follow.ToString())

? xPathNavigator.SelectSingleNode("title").Value

: xPathNavigator.SelectSingleNode("content").Value)));

htmlGenericControlItem.Controls.Add(htmlGenericControlTitle);

labelControl.Controls.Add(htmlGenericControlItem);

}

Can anyone help me to solve this problem? Why does the page perform a postback after adding the Rotator handler.

Rotator

answered on 05 Mar 2011

1 answer

163 views

blank rows appearing in exported excel file

I am trying to figure out why a blank row is appearing between each row of data in the excel file that gets exported from my radgrid. Here is how I am doing the export:

grdMetricsClosed.ExportSettings.ExportOnlyData = true;

grdMetricsClosed.ExportSettings.IgnorePaging = true;

grdMetricsClosed.ExportSettings.OpenInNewWindow = true;

foreach (GridColumn col in grdMetricsClosed.MasterTableView.RenderColumns)

{

col.Visible = true;

}

grdMetricsClosed.MasterTableView.ExportToExcel();

I am at a loss as to why that is happening. Anyone run into this and if so, what is the solution?

Grid

answered on 04 Mar 2011

2 answers

114 views

[Solved] Get GridEditableItem for preinserted item

Hello,
I need to get to the GridItem for a record that I am inserting. I'm actually changing the value of one of the controls in my EditItemTemplate.
Basically, the idea is the user performs some action while entering the information, and then through server-side code the value of a particular control gets changed.
But, I'm doing this outside the InsertCommand event, and can't figure out how to find it inside the RadGrid control.

Grid

answered on 04 Mar 2011