Questions on UI for ASP.NET AJAX Forum

1 answer

136 views

Hi,

I am trying to set the values for Between filter in the PreRender event of the grid..
Filter works fine if I pass a single value (int)

column.CurrentFilterFunction = GridKnownFunction.EqualTo

column.CurrentFilterValue = 60

But I need to pass a range of values and use "Between" filter. Tried couple of syntaxes given below but did not work. Can you please let me know what am I doing wrong?

If (

Not Page.IsPostBack) Then

RadGrid1.MasterTableView.FilterExpression =

"([Price] between 60 AND 70) "

Dim column As GridColumn = RadGrid1.MasterTableView.GetColumnSafe("Price")

column.CurrentFilterFunction =

GridKnownFunction.GreaterThanOrEqualTo

column.CurrentFilterValue = 60

column.AndCurrentFilterFunction =

GridKnownFunction.LessThanOrEqualTo

column.AndCurrentFilterValue = 70

'column.AndCurrentFilterFunction = GridKnownFunction.Between

'column.CurrentFilterFunction= 60,70

RadGrid1.MasterTableView.Rebind()

End If

Grid

answered on 26 Aug 2011

3 answers

194 views

Vertical RadTab IE 9 / Moz 5 Issue

Hello guys,

I'm facing a problem with the RadTab component on IE 9 and Mozilla 5. In the other versions of IE, its behavior is ok. Don't know about other Mozilla versions. Follows more info about the issue.

I have a RadTab and a MultiPage. RadTab is linked with the MultiPage. I want a VerticalLeft RadTab, but, in these new versions, the RadTab persists at the top of the multipage and is showing as HorizontalTab. On other versions, it is working as expected. I've tried some CSS combinations, but none of them worked as expected.

Follows the code:

<telerik:RadTabStrip ID="rtsVertical" runat="server" MultiPageID="rmpCourseEdit"

SelectedIndex="1" SkinID="OutlookVTAB" Style="float: left">

<Tabs>

<telerik:RadTab Text="pgvBasic" PageViewID="pgvBasic" runat="server" Selected="True" /

<telerik:RadTab Text="pgvComposite" PageViewID="pgvComposite" runat="server" />

<telerik:RadTab Text="pgvTexts" PageViewID="pgvTexts" runat="server" />

<telerik:RadTab Text="pgvPub" PageViewID="pgvPub" runat="server" />

<telerik:RadTab Text="pgvSpec" PageViewID="pgvSpecialist" runat="server" />

</Tabs>

</telerik:RadTabStrip>

<telerik:RadMultiPage ID="rmpCourseEdit" runat="server" SelectedIndex="0" RenderSelectedPageOnly="false" CssClass="MultiPageV">
... </>

Follows the CSS and Skins:
<telerik:RadTabStrip runat="server" SkinID="OutlookHTAB"

Skin="Outlook"

EnableEmbeddedSkins="False"

Orientation="HorizontalTop"

/>

-------------------------

Can you help me with this guys?

tks,

TabStrip

answered on 26 Aug 2011

1 answer

152 views

Closing radwindow and refreshing a grid inside a user control

I have a grid ( radGridDocs ) when the user clicks a linkbutton in the grid (which is in the UC, DocumentAccess) the modal window pops up and the client can enter their comments. When they are finished entering their comments and click submit, the desired behavior is for the window (docComments) to close and refresh the grid. I assume this will be done via Java script, but I am new to java scripting and require a little help.

Thanks,
Chuck

Window

answered on 26 Aug 2011

1 answer

125 views

Hierarchical grid, export to PDF Error with Custom Expand/Collapse Column

Update:

Telerik Please close this issue. I was able to able to fix it as suggested by Princy.

Basically, in Pre-Render event I hide the Default Expand/Collapse Column and rest I followed based on below link.

http://www.telerik.com/community/forums/aspnet-ajax/grid/gridexpandcolumn-expandimageurl-and-buttontype.aspx

Thanks Telerik and Princy.

gc_0620

___________________________________________________________________________________________

Folks using VS 2010 with RadGrid for ASP.Net Ajax 2011 V2.

I have a Hierarchical grid, Master Table HierarchyLoadMode="Client".

If use use expand/collapse Expand/Collapse ImageUrl from a File via ColumnCreated event, I got the attached error message while exporting to PDF. But If i do not call Column created event in Radgrid thus by using default Expand/Collapse ImageURL, the PDF export works fine. Also if I use HierarchyLoadMode=Server or ServerOnDemand and call ColumnCreated event, export works fine.

Any help appreciated..

Thanks

gc_0620

protected void RadGrid1_ColumnCreated(object sender, GridColumnCreatedEventArgs e)

{

if (e.Column is GridExpandColumn)

{

(e.Column as GridExpandColumn).ButtonType = GridExpandColumnType.ImageButton;

(e.Column as GridExpandColumn).ExpandImageUrl = "~/Images/grd_SinglePlus.gif";

(e.Column as GridExpandColumn).CollapseImageUrl = "~/Images/grd_SingleMinus.gif";

}

protected void Export_to_PDF_Click(object sender, System.EventArgs e)

{

RadGrid1.ExportSettings.ExportOnlyData = false;

RadGrid1.MasterTableView.HierarchyDefaultExpanded = true;

RadGrid1.ExportSettings.OpenInNewWindow = true;

RadGrid1.MasterTableView.ExportToPdf();

}

Grid

answered on 26 Aug 2011

2 answers

771 views

Set focus on the radcombobox

Hi guys,
I have following code in my aspx page:

<

tr>

<td >

Please enter job posting number:

</p>

</td>

<td >

<telerik:RadNumericTextBox ID="JobPostingNo" runat="server" TabIndex="9" Font-Bold="true" MaxLength="4" Type="Number" MinValue="1" MaxValue="9999" CssClass="textbox" Width="48px" Enabled="false">

</telerik:RadNumericTextBox>

</td>

<td>

<asp:Image ID="JobPNErrImage" runat="server" Width="14px" Height="14px" ImageUrl="~/Image/error-icon.jpg" Visible="false" />

</td>

</tr>

<tr>

<td>

Have you met all of the criteria outlined in the posting?

</p>

</td>

<td>

<telerik:RadComboBox ID="ddlPost" runat="server" TabIndex="10" AutoPostBack="false" Font-Size="Small" Width="53px">

<Items>

<telerik:RadComboBoxItem Text="Select" Value="" Selected="true" />

<telerik:RadComboBoxItem Text="Yes" Value="Y" />

<telerik:RadComboBoxItem Text="No" Value="N" />

</Items>

</telerik:RadComboBox>

</td>

And here is a code behind file:

RadPanelBar

attestPanel = (RadPanelBar)formPanel.FindItemByValue("principalForm").FindControl("attestationPanel");

RadNumericTextBox jobPostNo = (RadNumericTextBox)attestPanel.FindItemByValue("principalattestaionInfo").FindControl("JobPostingNo");

RadComboBox ddlAprvPost = (RadComboBox)attestPanel.FindItemByValue("principalattestaionInfo").FindControl("ddlAprv");

if (ddlAprvPost.SelectedValue == "Y")

{

jobPostNo.Enabled =

true;

jobPostNo.Focus();

}

else

{

if (jobPostNo.Text.Length > 0)

{

jobPostNo.Text =

string.Empty;

}

jobPostNo.Enabled =

false;

}

My question is: when jobPostNo control is disabled how to shift focus to the next control right after this control.

Thanks so much.

General Discussions

answered on 25 Aug 2011

9 answers

813 views

GridHyperlinkColumn client-side onclick

I would be grateful for an example of how to wire-up some client-side javascript to the click event on a GridHyperlinkColumn. I have this markup:

and I want to send the value of the DataNavigateUrlFields to a client-side javascript function when the hyperlink is clicked:

someClientSideFunction( value of the DataNavigateUrlFields of the clicked item );

Thanks

Grid

answered on 25 Aug 2011

2 answers

408 views

How to get Detail Table row count from Client Side while Scrolling rows in Master Table.

Folks,

I am using ASP.Net Ajax Q2 2011 with VS 2010. Below is my Grid Table Laout.

Parent Table

---- Detail Table 1 (GridTableView Name = "Detail")

--- Detail Table 1.1

---- Detail Table 2

　
My desired expectations:

1) While I am scrolling rows in Parent Table, I would like to get the row counts of related Detail Table 1 but not row counts of other Detail Tables.

2) Also if I am scrolling rows in Detail Table 1, do nothing.

Below works to get the Row Count of Parent Table; but having some difficulty to getting row count of Related Detail Table 1.

function RowCount(sender, args)

{

var grid = $find("<%=RadGrid1.ClientID %>");

var MasterTable = grid.get_masterTableView();

var Rows = MasterTable.get_dataItems();

  // Need Help here to get the Row Count of Detail Table 1 and Pass into TextBox RowCountTextBox...



    alert(Rows.length);

document.getElementById("<%=RowCountTextBox.ClientID %>").value = parseInt(Rows.length);

}

Rad Grid Settings: 

'''

 

HierarchyLoadMode = "ServerBind"

 
'''

<ClientEvents OnFilterMenuShowing="filterMenuShowing" OnRowSelected = "RowCount" />

'''

<asp:TextBox ID="RowCountTextBox" runat="server" Text="" Width = "400px"> </asp:TextBox>

I tried in Server Side Prerender event, but did not get the Child Table row count if Parent row is not expanded.

Thanks

gc_0620

Grid

answered on 25 Aug 2011

2 answers

104 views

using header text

Hello,

I have a telerik grid in which as a item template I have a checkbox..so it gets repeated at all rows..now In the header text I wanted a checkbox which if selected selects all the checkboxes on the page...can someone please tell me me how can I do that.

Thanks

Grid

answered on 25 Aug 2011

11 answers

219 views

[Solved] Delete from RadGrid (bind from procedure)

Hello again,

I need some help to know how i can get a property from the selectedItem of my Radgrid, so i can execute a delete on a table on my database...

I'm populating data from a stored procedure, using entity.

EscalonamentoFacturasEntities objectContx = new EscalonamentoFacturasEntities();

RadGrid2.DataSource = objectContx.UsersAssignResume();

RadGrid2.DataBind();

I need to when click a button "delete", get a property("UserName") from RadGrid2 selected Item, so i can use it like a parametter and execute a storeCommand like this:

objectContx.ExecuteStoreCommand(

"Delete from Table Where Table.UserName = @par");

Grid

answered on 25 Aug 2011

1 answer

122 views

Problem with Export to CSV

Hello experts,

I have an export button on my RadGrid but it's working bad...The idea was to export a specific collumn...After some changes at this moment when i click to export, my grid shows the list to export, instead of give me a .csv....Can you help?

aspx:

<telerik:RadGrid ID="RadGrid1" runat="server" GridLines="None" AllowPaging="True"

AllowSorting="True" AutoGenerateColumns="False" Width="97%" enableajax="True"

AllowFilteringByColumn="True" ShowFooter="True" Skin="Black" OnItemCommand="RadGrid1_ItemCommand"

OnGridExporting="RadGrid1_GridExporting" AllowMultiRowSelection="True" OnItemDataBound="RadGrid1_ItemDataBound">

<PagerStyle Mode="NextPrevAndNumeric"></PagerStyle>

<ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True" EnablePostBackOnRowClick="true">

<Selecting AllowRowSelect="True" />

</ClientSettings>

<MasterTableView DataKeyNames="SequencialNumber" Width="100%" CommandItemSettings-ShowExportToCsvButton="True"

CommandItemSettings-ShowAddNewRecordButton="false" CommandItemDisplay="Top">

<Columns>

<telerik:GridBoundColumn DataField="SequencialNumber" HeaderText="SequencialNumber"

UniqueName="SequencialNumber" SortExpression="SequencialNumber">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Priority" HeaderText="Priority" UniqueName="Priority"

FilterControlAltText="Filter Priority column" SortExpression="Priority" DataType="System.Int32">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Process" HeaderText="Staging" UniqueName="Process"

SortExpression="Process" FilterControlAltText="Filter Process column">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SupplierCode" HeaderText="SupplierCode" UniqueName="SupplierCode"

SortExpression="SupplierCode" FilterControlAltText="Filter SupplierCode column">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="MessageStatus" HeaderText="MessageStatus" UniqueName="MessageStatus"

SortExpression="MessageStatus" FilterControlAltText="Filter MessageStatus column">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="DocumentType" HeaderText="DocumentType" UniqueName="DocumentType"

FilterControlAltText="Filter DocumentType column" SortExpression="DocumentType">

</telerik:GridBoundColumn>

<telerik:GridDateTimeColumn UniqueName="InvoiceCreationDate" DataField="InvoiceCreationDate"

HeaderText="InvoiceCreationDate" FilterControlAltText="Filter InvoiceCreationDate column"

SortExpression="InvoiceCreationDate">

<FilterTemplate>

<telerik:RadDatePicker ID="RadDatePicker1" runat="server">

</telerik:RadDatePicker>

</FilterTemplate>

</telerik:GridDateTimeColumn>

<telerik:GridBoundColumn DataField="SupplierVatNumber" FilterControlAltText="Filter SupplierVatNumber column"

HeaderText="SupplierVatNumber" SortExpression="SupplierVatNumber" UniqueName="SupplierVatNumber">

</telerik:GridBoundColumn>

</Columns>

<ExpandCollapseColumn Visible="False">

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

</ExpandCollapseColumn>

<RowIndicatorColumn Visible="False">

<HeaderStyle Width="20px" />

</RowIndicatorColumn>

</MasterTableView>

<FilterMenu EnableImageSprites="False">

</FilterMenu>

<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default">

</HeaderContextMenu>

</telerik:RadGrid>

aspx.cs:

public partial class InvoicesScalingDefault : iConnect.Web.iConnect, IInvoicesScale

{

private InvoicesScalePresenter _presenter;

public System.Collections.Generic.IList<Data.SapDocuments> SapDocuments

{

get;

set;

}

protected void Page_Load(object sender, EventArgs e)

{

if (!this.IsPostBack)

{

this._presenter.OnViewInitialized();

LoadData();

}

this._presenter.OnViewLoaded();

}

[CreateNew]

public InvoicesScalePresenter Presenter

{

set

{

this._presenter = value;

this._presenter.View = this;

}

/// <summary>

/// Carregar RadGrid1 com o objecto SapDocuments

/// </summary>

private void LoadData()

{

string user = Page.User.Identity.Name.Substring(Page.User.Identity.Name.IndexOf("\\") + 1);

EscalonamentoFacturasEntities objectContx = new EscalonamentoFacturasEntities();

RadGrid1.DataSource = objectContx.ShowUnprocessedInvoices(user);

//RadGrid1.DataBind();

}

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)

{

if (e.CommandName == Telerik.Web.UI.RadGrid.ExportToCsvCommandName)

{

RadGrid1.MasterTableView.Columns.FindByUniqueName("SequencialNumber").Visible = true;

RadGrid1.ExportSettings.IgnorePaging = true;

int count = 0;

foreach (GridColumn column in RadGrid1.Columns)

{

if (column.Visible)

{

if (count > 0)

column.Visible = false;

else

count++;

}

protected void RadGrid1_GridExporting(object sender, GridExportingArgs e)

{

e.ExportOutput = e.ExportOutput.Replace("\"\r\n\"", "\"\r\n\"'");

}

Grid

answered on 25 Aug 2011