Questions on UI for ASP.NET AJAX Forum

2 answers

466 views

Slow page load with radgrid

Hi,

We have a RadGrid with the following configuration:

<telerik:RadGrid ID="Grid" runat="server"

AutoGenerateColumns="false"

Skin="Simple"

AllowSorting="true"

AllowFilteringByColumn="true"

EnableHeaderContextMenu="true"

EnableHeaderContextFilterMenu="true"

OnNeedDataSource="Grid_NeedDataSource"

OnItemDataBound="Grid_ItemDataBound"

ViewStateMode="Disabled"

AllowPaging="true" PageSize="500" AllowCustomPaging="true"

>



It has batch editing enabled, too.



It has about 30 columns, 20 of them are GridTemplateColumn with RadComboBox. When we have more than 100 rows, page load is very slow, and customer doesn't want us to have pagination.



Is there any way so we can speed up page load? It's a mandatory requirement for us.



Thanks in advance,



Alfonso

Grid

answered on 16 Feb 2015

1 answer

134 views

Reorder List Issue

We have been using the ReorderList for several years without any issue. No we are having clients say that it is not working in "OX Yosemite with Safari 8.0.3". They can drag the fields fine but when it is saved they revert to the initial order. Firefox on the OX Yosemite seems to work just fine. How do we get this fixed?

General Discussions

answered on 16 Feb 2015

6 answers

129 views

Use more than custom (user) dictionary

Hi Team,

Please advise me how to use more than one (User) dictionary?

Thanks

Editor

answered on 16 Feb 2015

3 answers

185 views

Color Code PivotGrid Cells

I am wondering how I can color code individual cells based on data from a table in a RadPivotControl. I do not want to color code the Totals rows or columns. My row has the values Neonate, Infant, Child, and Adult. My Columns are 2012, 2013, 2014. The color code is based on a national average of mortality rates and can change from one year to the next. So an expected value for a neonate in 2012 is between 1 and 2% while 2013 is 0.5-1.5%. If my neonate mortality rate in 2012 is 2% then I am GREEN. However if my mortality rate is 2% for 2013 then I am RED. Please let me know the best method to accomplish this.

Owen

PivotGrid

answered on 16 Feb 2015

3 answers

221 views

RadNumericTextBox Problem

Hi Dears ,
im facing problem in RadNumericTextBox
problem is : RadNumericTextBox.Value or DbValue or Text is always null
problems occours when i set the empty message in java script then try to get value of RadNumericTextBox in Server side

Java Script Code :
rntbAutoBidValue.set_emptyMessage(Some Value );

then user insert values in RadNumericTextBox
and what ever what user insert i always get null value
Server side Code :
rntbAutoBidValue.DbValue

i fix the probem in this Code
on RadNumericTextBox Control :
ClientEvents-OnValueChanged="Save"

Java Script Code
// Solve problem in RadNumericTextBox
function Save(sender) {
var rntbAutoBidValue = $find("<%= rntbAutoBidValue.ClientID%>");
var Value = rntbAutoBidValue.get_value();
rntbAutoBidValue.set_emptyMessage(null);
}

if there flexible solution for this problem Kindly let me know
Regards ,,

General Discussions

answered on 16 Feb 2015

1 answer

141 views

Unable to save when Updating / Inserting in Grid

I have had to make changes to my FormTemplate fields to keep it from getting an error.
I believe it is because I have changed the fields from using selectedvalue and checked
set to a BIND to using Eval expressions. After making these changes when in edit mode
any changes put into the template fields don't seem to be populating the GridEditableItem
which I believe is the reason for the saves not going to the database now. If I remove
everything under the EditSettings then the grid goes back to successfully saving the
changes to the database. Below is both my markup and code behind. I can't hitting roadblock
after roadblock. Any help would be much appreciated?

Markup code:

<div class="WebpageManagementBox">

<br /><br />

<asp:Label ID="lblRolePrompt" Text="Select Role to associate web pages:" CssClass="box_Labels" runat="server"></asp:Label>

<br />

<telerik:RadDropDownList ID="ddlRoles" runat="server" CssClass="wepageManagementDropDown" Width="200px" DataTextField="role" DataValueField="ID" AutoPostBack="true" OnItemSelected="ddlRoles_ItemSelected"></telerik:RadDropDownList>

<br />

<telerik:RadGrid ID="RadGridwebpagemanagement" CssClass="webpageManagementGrid" MasterTableView-DataKeyNames="ID" runat="server"

AllowFilteringByColumn="True" AllowSorting="True"

GroupPanelPosition="Top"

OnNeedDataSource="RadGridwebpagemanagement_NeedDataSource"

OnUpdateCommand="RadGridwebpagemanagement_UpdateCommand" OnItemDataBound="RadGridwebpagemanagement_ItemDataBound" OnDeleteCommand="RadGridwebpagemanagement_DeleteCommand" OnInsertCommand="RadGridwebpagemanagement_InsertCommand">

<ClientSettings>

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

<Selecting AllowRowSelect="true" />

</ClientSettings>

<GroupingSettings CaseSensitive="false" />

<MasterTableView AutoGenerateColumns="false" CommandItemDisplay="Top" CommandItemSettings-AddNewRecordText="Add New Webpage"

InsertItemPageIndexAction="ShowItemOnCurrentPage">

<columns>

<telerik:GridBoundColumn DataField="webpage_name" HeaderText="Web Page" UniqueName="webpage_name" ItemStyle-Font-Names="Arial" ItemStyle-Font-Bold="true"

FilterControlWidth="200px">

<HeaderStyle Width="230px" Font-Names="Arial" />

<ItemStyle Width="230px" />

</telerik:GridBoundColumn>

<telerik:GridCheckBoxColumn DataField="add_privledge" HeaderText="Allow Adds" UniqueName="add_privledge"

FilterControlWidth="120px">

<HeaderStyle Width="120px" Font-Names="Arial" />

<ItemStyle Width="120px" />

</telerik:GridCheckBoxColumn>

<telerik:GridCheckBoxColumn DataField="edit_privledge" HeaderText="Allow Edits" UniqueName="edit_privledge"

FilterControlWidth="120px">

<HeaderStyle Width="120px" Font-Names="Arial" />

<ItemStyle Width="120px" />

</telerik:GridCheckBoxColumn>

<telerik:GridCheckBoxColumn DataField="delete_privledge" HeaderText="Allow Deletes" UniqueName="delete_privledge"

FilterControlWidth="120px">

<HeaderStyle Width="120px" Font-Names="Arial" />

<ItemStyle Width="120px" />

</telerik:GridCheckBoxColumn>

<telerik:GridEditCommandColumn ButtonType="LinkButton" EditText="Edit" CancelText="Cancel" ItemStyle-Width="50px" HeaderStyle-Width="50px" FilterControlWidth="50px" />

<telerik:GridButtonColumn ConfirmText="Delete this product?" ConfirmDialogType="RadWindow"

ConfirmTitle="Delete" ButtonType="LinkButton" Text="Delete" CommandName="Delete" ItemStyle-Width="50px" HeaderStyle-Width="50px" FilterControlWidth="50px" />

</columns>

<EditFormSettings EditFormType="Template">

<FormTemplate>

<div id="divGridEdit" class="divGrid">

<b>Add New Role to Webpage Association</b>

<br /><br />

<table>

<tr>

<td><asp:Label Text="Web Page:" runat="server"></asp:Label></td>

<td>

<asp:DropDownList ID="ddlWebPages" DataSourceID="sqlDataSourceWebpages" AppendDataBoundItems="True" DataTextField="webpage_name" DataValueField="ID"

SelectedValue='<%# DataBinder.Eval(Container.DataItem,"security_webpage_id") == DBNull.Value ? "" : DataBinder.Eval(Container.DataItem,"security_webpage_id") %>'

runat="server">

<asp:ListItem Value=""></asp:ListItem>

</asp:DropDownList>

</td>

</tr>

<tr>

<td><br /></td>

<td></td>

</tr>

<tr>

<td><asp:Label Text="Allow Add:" runat="server"></asp:Label></td>

<td><asp:CheckBox ID="chkboxAllowAdd"

Checked='<%# DataBinder.Eval(Container.DataItem,"add_privledge") == DBNull.Value ? false : DataBinder.Eval(Container.DataItem,"add_privledge") %>' runat="server" /></

td>

</tr>

<tr>

<td><asp:Label Text="Allow Edit:" runat="server"></asp:Label></td>

<td><asp:CheckBox ID="chkboxAllowEdit"

Checked='<%# DataBinder.Eval(Container.DataItem,"edit_privledge") == DBNull.Value ? false : DataBinder.Eval(Container.DataItem,"edit_privledge") %>' runat="server" /></

td>

</tr>

<tr>

<td><asp:Label Text="Allow Delete:" runat="server"></asp:Label></td>

<td><asp:CheckBox ID="chkboxDelete"

Checked='<%# DataBinder.Eval(Container.DataItem,"delete_privledge") == DBNull.Value ? false : DataBinder.Eval(Container.DataItem,"delete_privledge") %>' runat="server" /></

td>

</tr>

<tr>

<td><asp:Button ID="btnUpdate" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'

CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>' runat="server" /></td>

<td><asp:Button ID="btnCancel" Text="Cancel" runat="server" CommandName="Cancel" CausesValidation="false" /></td>

</tr>

</table>

</div>

</FormTemplate>

</EditFormSettings>

</MasterTableView>

<ClientSettings>

<ClientEvents OnRowDblClick="rowDblClick" />

</ClientSettings>

</telerik:RadGrid>

</div>

<asp:SqlDataSource ID="sqlDataSourceWebpages" runat="server" SelectCommand="SELECT * FROM dbo.security_webpage" ConnectionString="<%$ ConnectionStrings:GATEConnectionString %>"></asp:SqlDataSource>

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

Code Behind:

using GATE_Entity;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using Telerik.Web.UI;

using System.Collections;

namespace FRC

{

public partial class WebPageManagemet : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

GATEEntities dbContext = new GATEEntities();

// Load Role Drop-down List

var rolequery = from r in dbContext.Security_Role

select r;

IEnumerable<Security_Role> roles = rolequery.ToList();

ddlRoles.DataSource = roles;

ddlRoles.DataBind();

}

protected void RadGridwebpagemanagement_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

int? selectedroleid = Convert.ToInt32(ddlRoles.SelectedValue);

// Use LINQ query to populate radGrid

GATEEntities dbContext = new GATEEntities();

var query = from srw in dbContext.Security_Role_To_Webpage

join sw in dbContext.Security_Webpage on srw.security_webpage_id equals sw.ID

where srw.security_role_id == selectedroleid

select new

{

srw.ID,

srw.security_webpage_id,

sw.webpage_name,

srw.add_privledge,

srw.edit_privledge,

srw.delete_privledge,

srw.view_privledge

};

//IEnumerable<Security_Role_To_Webpage> securitypages = query.ToList();

RadGridwebpagemanagement.DataSource = query.ToList();

}

protected void ddlRoles_ItemSelected(object sender, Telerik.Web.UI.DropDownListEventArgs e)

{

RadGridwebpagemanagement.Rebind();

}

protected void RadGridwebpagemanagement_ItemDataBound(object sender, GridItemEventArgs e)

{

if (e.Item.FindControl("ddlWebPages") != null )

{

GridEditableItem editedItem = e.Item as GridEditableItem;

DropDownList _ddl = (DropDownList)e.Item.FindControl("ddlWebPages");

if (_ddl != null)

{

_ddl.DataSourceID = "";

_ddl.Items.Clear();

ListItem newitem = new ListItem("","");

_ddl.Items.Add(newitem);

_ddl.DataSource = this.sqlDataSourceWebpages;

_ddl.DataTextField = "webpage_name";

_ddl.DataValueField = "ID";

_ddl.DataBind();

}

protected void RadGridwebpagemanagement_DeleteCommand(object sender, GridCommandEventArgs e)

{

GATE_Entity.GATEEntities dbContext = new GATEEntities();

var editableItem = ((GridEditableItem)e.Item);

var lookupID = (int)editableItem.GetDataKeyValue("ID");

// Retrieve Entity

var webpagerecord = dbContext.Security_Role_To_Webpage.Where(n => n.ID == lookupID).FirstOrDefault();

if (webpagerecord != null)

{

// set for deletion

dbContext.Security_Role_To_Webpage.Remove(webpagerecord);

try

{

// Save changes to db

dbContext.SaveChanges();

}

catch (System.Exception)

{

}

private void DisplayMessage(string text)

{

RadGridwebpagemanagement.Controls.Add(new LiteralControl(string.Format("<span style='color:red'>{0}</span>", text)));

}

protected void RadGridwebpagemanagement_UpdateCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)

{

GATEEntities dbContext = new GATEEntities();

var editableItem = ((GridEditableItem)e.Item);

var lookupID = (int)editableItem.GetDataKeyValue("ID");

DropDownList ddlwebpage = (DropDownList)editableItem.FindControl("ddlWebPages");

var selectedval = Convert.ToInt32(ddlwebpage.SelectedValue);

// Check to make sure user didn't select webpage for this role that is already within the role

var roleid = Convert.ToInt32(ddlRoles.SelectedValue);

var webpagerecexist = (from srw in dbContext.Security_Role_To_Webpage

where srw.security_role_id == roleid &&

srw.security_webpage_id == selectedval &&

srw.ID != lookupID

select srw).ToList();

// If Count > 0 then user chose drop down webpage that is already associated with role

if (webpagerecexist.Count == 0)

{

// create sql criteria with which the changes will be applied to

var webpagerecord = dbContext.Security_Role_To_Webpage.Where(n => n.ID == lookupID).FirstOrDefault();

if (webpagerecord != null)

{

// update entity's state

editableItem.UpdateValues(webpagerecord);

try

{

// Save changes to db

dbContext.SaveChanges();

}

catch (System.Exception)

{

}

else

{

DisplayMessage("The webpage you selected already exists for this role!");

// keep in update mode

e.Canceled = true;

}

protected void RadGridwebpagemanagement_InsertCommand(object sender, GridCommandEventArgs e)

{

GATEEntities dbContext = new GATEEntities();

var editableItem = ((GridEditableItem)e.Item);

Hashtable values = new Hashtable();

editableItem.ExtractValues(values);

var newrec = dbContext.Security_Role_To_Webpage.Create();

newrec.security_webpage_id = (int?)values["security_webpage_id"];

newrec.security_role_id = (int?)values["security_role_id"];

newrec.add_privledge = (bool?)values["add_privledge"];

newrec.edit_privledge = (bool?)values["edit_privledge"];

newrec.delete_privledge = (bool?)values["delete_privledge"];

dbContext.SaveChanges();

}

Grid

answered on 16 Feb 2015

1 answer

212 views

RadGrid Batch Mode Get Value from Popup or bind another dropdown.

I am trying to get a value from a popup window.

My process goes like this.

When a user clicks on a value from a RadDropDownList (CUST_NBRDropDown) I have OnClientItemSelected fire a popup

<telerik:RadDropDownList ID="CUST_NBRDropDown" runat="server" DataSourceID="Customer_DDL" DataTextField="account_name" DataValueField="account_number" DropDownHeight="400px" SelectedValue='<%# Bind("CUST_NBR")%>' OnClientItemSelected="OnClientItemSelected">

</telerik:RadDropDownList>

function OnClientItemSelected(sender, eventArgs) {

var item = eventArgs.get_item();

//alert("You selected " + item.get_text() + " with value " + item.get_value());

retVal = window.open("BSDM_PLANT_BACKNUMBERS_popup.aspx?acct_num=" + item.get_value(), "Popup", "width=300,height=100");

retVal.focus();

}

On the BSDM_PLANT_BACKNUMBERS_popup.aspx page i have a RadComboBox that i want the user to be able to select one of the values from.(This dropdown is populated from a Oracle DB. with the filter from the original 'CUST_NBRDropDown' dropdown.)

After they select a value i want to return the selected value back to the BSDM_PLANT_BACKNUMBERS (Parent) page to a Textbox in the same row as the original RadDropDownList.

<asp:TextBox ID="CUST_NBR_txt" runat="server" Text='<%# Bind("CUST_NBR") %>' Visible="true"></asp:TextBox>

So far I have not been able todo that.

If possible instead of doing a popup i would like to be able to have the dropdown that is populated in the Popup window to be in the radgrid row. but from my understanding i cannot bind the dropdown in "batch edit mode" after the CUST_NBRDropDown is selected since this is all client side functions...

Any help would be greatly appreciated!

General Discussions

answered on 16 Feb 2015

1 answer

93 views

How to Call WCF for this

Hi

I need how to insert,Update,Delete using WCF Service client side only in Telerik grid using

Grid

answered on 16 Feb 2015

1 answer

149 views

Keyboard issue with radtoobar/radmenu

We have requirements for 508 and WCAG within our system. I have been testing the ability to move between the controls using the keyboard and ran across a problem with the radtoolbar so am looking for a way to get it working.

In the example below i can use the keyboard and tab through the open, save, cancel options on the main tool bar. When i stop on the "open tab" option i use the down arrow key to open up the radmenu. i can use the up/down arrow to move up down through the menu without any issues.

the problem comes in when i need to expand the "level 1a" menu. when focus is on that item, i hit the right arrow to expand the menu out. however, what happens when i click the right arrow key is that the focus moves to the "save" menu option on the toolbar. so i can't open that lower level menu and continue using the keyboard to get into the level 2a-e menu options.

Is this a bug in the controls? Is there a way to workaround the issue so i can use the keyboard to access the level 2 menu items?

<telerik:RadToolBar ID="RadToolBar1" runat="server">
<Items>
<telerik:RadToolBarButton>
<ItemTemplate>
<telerik:RadMenu runat="server">
<Items>
<telerik:RadMenuItem Text="open tab">
<Items>
<telerik:RadMenuItem Text="level 1a">
<Items>
<telerik:RadMenuItem Text="level 2a"></telerik:RadMenuItem>
<telerik:RadMenuItem Text="level 2b"></telerik:RadMenuItem>
<telerik:RadMenuItem Text="level 2c"></telerik:RadMenuItem>
<telerik:RadMenuItem Text="level 2d"></telerik:RadMenuItem>
<telerik:RadMenuItem Text="level 2e"></telerik:RadMenuItem>
</Items>
</telerik:RadMenuItem>
<telerik:RadMenuItem Text="level 1b"></telerik:RadMenuItem>
<telerik:RadMenuItem Text="level 1c"></telerik:RadMenuItem>
<telerik:RadMenuItem Text="level 1d"></telerik:RadMenuItem>
</Items>
</telerik:RadMenuItem>
</Items>
</telerik:RadMenu>
</ItemTemplate>
</telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="save"></telerik:RadToolBarButton>
<telerik:RadToolBarButton Text="cancel"></telerik:RadToolBarButton>
</Items>
</telerik:RadToolBar>

ToolBar

answered on 16 Feb 2015

9 answers

515 views

[Solved] Add new record to batch edit enabled grid via client javascript

Hi All,

I am using a grid with batch edit mode set.

I need to be able to add via javascript a new row to my grid with no callbacks in the middle. Is there a way to do this?

Regards

Jon

Grid

answered on 16 Feb 2015