Questions on UI for ASP.NET AJAX Forum

2 answers

410 views

How to access GridBoundColumn by DataField?

I need to update one row of RadGrid after ajax call.
I get correct dataItem by rowIndex:
var dataItem = $find("<%= MyGrid.ClientID %>").get_masterTableView().get_dataItems()[radGridRowIndex];

But then it's a total mess!
I have tried a lot of ways to get correct cell to update its value, but in vain:
<telerik:GridBoundColumn HeaderStyle-CssClass='GridHeaderGreen la gridBottomHeaderGreen' ItemStyle-CssClass='la' DataField="CounterName" HeaderText="Performance counter" />

dataItem["CounterName"]
dataItem.get_dataItem()["CounterName"]
dataItem.CounterName
dataItem.get_dataItem().CounterName

I have also tried to use UniqueColumn name = DataField and apply get_cell method, but also in vain.

I can use GridTemplateColumn instead, but it will generate more markup (will add span inside td), I wanted to avoid this.

p.s. Had to use UniqueColumnName everywhere. And did
$($find("<%= MyGrid.ClientID %>").get_masterTableView().getCellByColumnUniqueName(dataItem, "CounterName")).text(bla-bla-bla);

Grid

answered on 21 Nov 2012

1 answer

90 views

Set ImageUrl using hierarchical data binding

Hi,

How can I set the ImageUrl on an RadMenuItem when populating the menu from code using hierarchical data binding.
I am trying to create a menu with icons/images.

Thanks!

TS.

Menu

answered on 21 Nov 2012

2 answers

76 views

Headers Misaligning at end of horizontal scroll

I have a grid that is resized by the following JavaScript

function GridCreated(sender, args) {

var scrollArea = sender.GridDataDiv;

var gridHeader = sender.GridHeaderDiv;

scrollArea.style.height = $telerik.$(window).height() / 2 - gridHeader.clientHeight + "px";

sender.get_element().style.width = ($telerik.$(window).width() * 0.85) + "px";

gridHeader.style.width = ($telerik.$(window).width() * 0.85 -17) + "px";

}

The radGrid has the below settings

<Telerik:RadGrid Visible="False" ID="ctlReportGrid" runat="server" AutoGenerateColumns="False" GridLines="Horizontal" CellSpacing="1" xSkin="Mac" EnableAJAXLoadingTemplate="True" LoadingTemplateTransparency="50" Width="400px">

<ClientSettings>

<Scrolling allowscroll="true" UseStaticHeaders="true"/>

<ClientEvents OnGridCreated="GridCreated" />

</ClientSettings>

<MasterTableView ShowFooter="True">

In any browser other than IE, when the horizontal scrollbar is taken to the extreme right end, the headers of the columns misalign by the width of the scrollbar. (i.e. they move slightly to the right).
In IE there is a small image that fills the space above the scrollbar as the headers move to the left. This is missing in the other browsers.

There are no item-style:widths within the grid.

Is there a setting I am missing?
Thank you in advance for any and all help!

Grid

answered on 21 Nov 2012

1 answer

73 views

RadGrid with unexpected postback

I have a RadPane on a web page that and the ID of the RadPane starts with an underscore. The RadPane also contains a RadGrid, and when clicking on the header of the RadGrid there is a postback that occurs that probably should not be happening. If a RadPane's ID does not start with an underscore and contains a RadGrid clicking the header does not result in a postback behaving as I expect. Why does the underscore in the ID of the RadPane make a difference in the behavior?

HTML

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<table>
<tr>
<td>When clicking in the header first grid you will get a postback when the ID of the RadPane starts with an underscore. </td>
</tr>
<tr>
<td>When clicking in the header of the second grid you will not get a postback when the ID of the RadPane does not start with an underscore.</td>
</tr>
</table>
<telerik:RadScriptManager runat="server" ID="ScriptManager1"></telerik:RadScriptManager>
<telerik:RadSplitter runat="server" ID="Splitter" Orientation="Horizontal">

<telerik:RadPane runat="server" ID="_Test" Height="100%">
<telerik:radgrid runat="server" ID="Grid1" Width="100%" Height="100%" AllowFilteringByColumn="true" Style="border: 0; outline: none">
<MasterTableView TableLayout="Fixed" Width="100%" />
<ClientSettings EnablePostBackOnRowClick="True">
<Scrolling AllowScroll="true" UseStaticHeaders="true"/>
<Selecting AllowRowSelect="True"></Selecting>
</ClientSettings>
</telerik:radgrid>
</telerik:RadPane>

<telerik:RadPane runat="server" ID="Test" Height="100%">
<telerik:radgrid runat="server" ID="Grid2" Width="100%" Height="100%" AllowFilteringByColumn="true" Style="border: 0; outline: none">
<MasterTableView TableLayout="Fixed" Width="100%" />
<ClientSettings EnablePostBackOnRowClick="True">
<Scrolling AllowScroll="true" UseStaticHeaders="true"/>
<Selecting AllowRowSelect="True"></Selecting>
</ClientSettings>
</telerik:radgrid>
</telerik:RadPane>
</telerik:RadSplitter>
</form>
</body>
</html>

Code Behind:

protected void Page_Load(object sender, EventArgs e)
{
var intData = new List<int> { 1, 2, 3, 4, 5, 6, 7, 8 };
var intData1 = new List<int> { 10, 20, 30, 40, 50, 60, 70, 80 };

Grid1.DataSource = intData;
Grid1.DataBind();

Grid2.DataSource = intData1;
Grid2.DataBind();
}

Grid

answered on 21 Nov 2012

1 answer

1.0K+ views

Linq with Grid A query body must end with a select clause or a group clause

heey guys

I have question what is wrong with my linq statement , hope someone can explain me what I am doing wrong

if (this.selectLBU.HtUsers.Any())

{

reportRowItems = (from r in reportRowItems

from bu in r.User.HtBusinessUnits

where bu.LocationBusinessUnitId == selectLBU.LocationBusinessUnitId).ToList();

}

Thanks for help and fast answer

Grid

answered on 21 Nov 2012

1 answer

93 views

can't sort the Radgrid

heey guys

I have a question why is my fromdate drop down(sort expression) menu not working in selectyear and selectmonth I really dont get it cost me that much time

using HolidayTracker.Code;

using HolidayTracker.Data.Model;

using HolidayTracker.Report;

using System;

using System.Collections;

using System.Collections.Generic;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Drawing;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using Telerik.Web.UI;

using eis = Telerik.Web.UI.ExportInfrastructure;

namespace HolidayTracker.Testing

{

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

{

private HtUser user;

private HtUser User

{

get

{

user = HtUser.INIT_USER(this.Page, true);

return user;

}

#region Views

private int selectYear

{

get

{

if (this.ViewState["selectYear"] == null)

{

this.ViewState["selectYear"] = new int();

}

return (int)(this.ViewState["selectYear"]);

}

set

{

this.ViewState["selectYear"] = value;

}

private int selectMonth

{

get

{

if(this.ViewState["selectMonth"]==null)

{

this.ViewState["selectMonth"]= new int();

}

return (int)(this.ViewState["selectMonth"]);

}

set

{

this.ViewState["selectMonth"] = value;

}

//private HtVacationDay selectYear

//{

// get

// {

// return (HtVacationDay)ViewState["selectYear"];

// }

// set

// {

// ViewState["selectYear"] = value;

// }

//}

//Change type in int

//private HtVacationDay selectMonth

//{

// get

// {

// return (HtVacationDay)ViewState["selectMonth"];

// }

// set

// {

// ViewState["selectMonth"] = value;

// }

//}

private HtLocationBusinessUnit selectLBU

{

get

{

return (HtLocationBusinessUnit)ViewState["selectLBU"];

}

set

{

ViewState["selectLBU"] = value;

}

private HtBusinessUnit selectBusinessUnit

{

get

{

return (HtBusinessUnit)ViewState["selectBU"];

}

set

{

ViewState["selectBU"] = value;

}

private HtDepartment selectDepartment

{

get

{

return (HtDepartment)ViewState["selectDep"];

}

set

{

ViewState["selectDep"] = value;

}

#endregion

#region UAC

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

LoadYear();

LoadMonth();

LoadLBU();

}

if (User.HtUserRoles.Where(u => u.Name == UserRoles.LbuLeader.ToString()).Any())

{

this.rcbYear.Visible = true;

this.rcbMonth.Visible = true;

this.rcbLocationBusinessUnits.Visible = true;

this.rcbBusinessUnits.Visible = true;

this.rcbDepartment.Visible = true;

}

if (User.HtUserRoles.Where(u => u.Name == UserRoles.Administrator.ToString()).Any())

{

this.rcbMonth.Visible = true;

this.rcbYear.Visible = true;

this.rcbBusinessUnits.Visible = true;

this.rcbDepartment.Visible = true;

this.rcbLocationBusinessUnits.Visible = true;

}

else if (User.HtUserRoles.Where(u => u.Name == UserRoles.BuLeader.ToString()).Any())

{

this.rcbMonth.Visible = true;

this.rcbYear.Visible = true;

this.rcbBusinessUnits.Visible = true;

}

else if (User.HtUserRoles.Where(u => u.Name == UserRoles.DepartmentLeader.ToString()).Any())

{

this.rcbMonth.Visible = true;

this.rcbYear.Visible = true;

this.rcbDepartment.Visible = true;

}

else if (User.HtUserRoles.Where(u => u.Name == UserRoles.BackOffice.ToString()).Any())

{

this.rcbYear.Visible = true;

this.rcbMonth.Visible = true;

this.rcbLocationBusinessUnits.Visible = true;

this.rcbBusinessUnits.Visible = true;

this.rcbDepartment.Visible = true;

}

#endregion

protected void LoadLBU()

{

SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["HolidayTrackerConnectionString"].ConnectionString);

SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM HtLocationBusinessUnit", connection);

DataTable dt = new DataTable();

adapter.Fill(dt);

rcbLocationBusinessUnits.DataTextField = "Name";

rcbLocationBusinessUnits.DataValueField = "LocationBusinessUnitId";

rcbLocationBusinessUnits.DataSource = dt;

rcbLocationBusinessUnits.DataBind();

rcbLocationBusinessUnits.Items.Insert(0, new RadComboBoxItem("-Select a LBU-"));

}

protected void LoadBU(string locationBusinessUnitId)

{

SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["HolidayTrackerConnectionString"].ConnectionString);

SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM HtBusinessUnit WHERE LocationBusinessUnitId=@LocationBusinessUnitId", connection);

adapter.SelectCommand.Parameters.AddWithValue("@locationBusinessUnitId", locationBusinessUnitId);

DataTable dt = new DataTable();

adapter.Fill(dt);

rcbBusinessUnits.DataTextField = "Name";

rcbBusinessUnits.DataValueField = "BusinessUnitId";

rcbBusinessUnits.DataSource = dt;

rcbBusinessUnits.DataBind();

rcbBusinessUnits.Items.Insert(0, new RadComboBoxItem("-Select a BU-"));

}

protected void LoadDep(string businessUnitId)

{

SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["HolidayTrackerConnectionString"].ConnectionString);

SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM HtDepartment WHERE BusinessUnitId=@BusinessUnitId", connection);

adapter.SelectCommand.Parameters.AddWithValue("@businessUnitId", businessUnitId);

DataTable dt = new DataTable();

adapter.Fill(dt);

rcbDepartment.DataTextField = "Name";

rcbDepartment.DataValueField = "DepartmentId";

rcbDepartment.DataSource = dt;

rcbDepartment.DataBind();

rcbDepartment.Items.Insert(0, new RadComboBoxItem("-Select a Dep-"));

}

protected void LoadYear()

{

rcbYear.DataSource = HtVacationDay.GetAllVacationYears();

rcbYear.DataBind();

rcbYear.Items.Insert(0, new RadComboBoxItem("-Select a Year-"));

}

protected void LoadMonth()

{

rcbMonth.DataSource = HtVacationDay.GetAllVacationMonths();

rcbMonth.DataBind();

rcbMonth.Items.Insert(0, new RadComboBoxItem("-Select a Month-"));

}

protected void UserGrid_ItemCommand(object sender, GridCommandEventArgs e)

{

if (e.CommandName == Telerik.Web.UI.RadGrid.ExportToExcelCommandName ||

e.CommandName == Telerik.Web.UI.RadGrid.ExportToWordCommandName ||

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

{

}

if (e.CommandName == "EnablePaging")

{

UserGrid.AllowPaging = true;

UserGrid.Rebind();

}

protected void Button1_Click(object sender, EventArgs e)

{

UserGrid.Visible = true;

ImageButton1.Visible = true;

}

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)

{

foreach (GridItem item in UserGrid.MasterTableView.GetItems(new GridItemType[] { GridItemType.Pager, GridItemType.FilteringItem }))

item.Display = false;

RadAjaxPanel1.ResponseScripts.Add("PrintRadGrid('" + UserGrid.ClientID + "')");

}

protected override PageStatePersister PageStatePersister

{

get

{ return new SessionPageStatePersister(this); }

}

private void dataSourceFilterChanged()

{

IEnumerable<MonthReportRowItem> reportRowItems = HtUser.GetAll().Select(u => new MonthReportRowItem(u,selectMonth,selectYear)); ;

if (this.selectLBU != null)

{

if (this.selectBusinessUnit != null)

{

if (this.selectDepartment != null)

{

if (this.selectDepartment.HtUsers.Any())

{

reportRowItems = this.selectDepartment.HtUsers.Select(u => new MonthReportRowItem(u, 2012));

}

else

{

if (this.selectBusinessUnit.HtUsers.Any())

{

reportRowItems = this.selectBusinessUnit.GetAllUser().Select(u => new MonthReportRowItem(u, 2012));

}

else

{

if (this.selectLBU.HtUsers.Any())

{

reportRowItems = this.selectLBU.GetAllUsers().Select(u => new MonthReportRowItem(u, 2012));

}

if (this.selectYear != null)

{

if (this.selectMonth != null)

{

if (this.selectMonth)

{

}

else

{

if (this.selectYear)

{

}

this.UserGrid.DataSource = reportRowItems;

this.UserGrid.DataBind();

}

protected void UserGrid_DataBound(object sender, EventArgs e)

{

if (this.UserGrid.Items.Count > 0)

{

for (int item = 0; item <= UserGrid.Items.Count - 1; item++)//loops through each grid row

{

GridDataItem dataItem = this.UserGrid.Items[item];

for (int c = 1; c <= 31; c++)

{

dataItem[c.ToString()].Text = ((IEnumerable<MonthReportRowItem>)this.UserGrid.DataSource).ElementAt(item).MonthDayReport[c - 1].ToString();

}

protected void rcbYear_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)

{

this.selectYear = HtVacationDay.GetById(int.Parse(e.Value));

dataSourceFilterChanged();

}

protected void rcbMonth_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)

{

this.selectMonth = HtVacationDay.GetById(int.Parse(e.Value));

dataSourceFilterChanged();

}

protected void rcbLocationBusinessUnits_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)

{

this.selectLBU = HtLocationBusinessUnit.GetById(int.Parse(e.Value));

LoadBU(selectLBU.LocationBusinessUnitId.ToString());

dataSourceFilterChanged();

}

protected void rcbBusinessUnits_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)

{

this.selectBusinessUnit = HtBusinessUnit.GetById(int.Parse(e.Value));

LoadDep(this.selectBusinessUnit.BusinessUnitId.ToString());

dataSourceFilterChanged();

}

protected void rcbDepartment_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)

{

this.selectDepartment = HtDepartment.GetById(int.Parse(e.Value));

dataSourceFilterChanged();

}

thanks for help !!!

Grid

answered on 21 Nov 2012

1 answer

382 views

RadGrid not saving VirtualItemCount

I have some custom logic that grabs a single page worth of data before setting the datasource of my RadGrid. I set the MasterTableView.VirtualItemCount. However, upon load of the page, It is telling me that I have 4 items in 1 page, thereby not giving me access to further pages. Here is my code:

ASP
<telerik:RadGrid AllowPaging="true"
AllowSorting="true"
AutoGenerateColumns="false"
GridLines="None"
ID="LoginAuditGrid"
OnNeedDataSource="LoginAuditGrid_NeedDataSource"
PageSize="4"
PagerStyle-AlwaysVisible="true"
ShowFooter="false"
ShowGroupPanel="true"
Skin="Hay"
runat="server">

<ClientSettings AllowDragToGroup="true" />
<GroupingSettings ShowUnGroupButton="true" />

<MasterTableView AllowMultiColumnSorting="true"
AllowSorting="true"
CommandItemDisplay="Top"
EnableColumnsViewState="false"
Font-Size="8">
<Columns>
<telerik:GridBoundColumn DataField="ApplicationName" DataType="System.String" HeaderText="Application Name" UniqueName="ApplicationID" />
<telerik:GridBoundColumn DataField="Username" DataType="System.String" HeaderText="Username" UniqueName="Username" />
<telerik:GridBoundColumn DataField="IPAddress" DataType="System.String" HeaderText="IP Address" UniqueName="ApplicationID" />
<telerik:GridBoundColumn DataField="LoginAuditDT" DataType="System.DateTime" HeaderText="Login Time" UniqueName="LoginAuditDT" />
<telerik:GridBoundColumn DataField="LoginAuditStatus" DataType="System.String" HeaderText="Login Audit Status" UniqueName="LoginAuditReasonID" />
<telerik:GridBoundColumn DataField="SecurityUserID" DataType="System.Int32" HeaderText="Security User ID" UniqueName="SecurityUserID" />
</Columns>
<CommandItemSettings ShowExportToExcelButton="false" ShowAddNewRecordButton="false" />
</MasterTableView>
</telerik:RadGrid>

Code Behind
protected void LoginAuditGrid_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
//This method defines a set of criteria to filter my data on
BaseSearch criteria = new BaseSearch(SavedSearch);

List<LoginAuditDetail> data = ServiceProxy.GetService<IAdminService>().FetchLoginAudit(criteria);

LoginAuditGrid.MasterTableView.VirtualItemCount = ServiceProxy.GetService<IAdminService().FetchLoginAuditCount(criteria);
LoginAuditGrid.DataSource = data;
}

Grid

answered on 21 Nov 2012

4 answers

277 views

How to show only date instead of date time

Hi
how can i show only date instead of datetime in excel sheet while exporting into excel.

i,e i have a column datatime column in grid while i am exporting data into a excel using exporttoexcel command , it is showing date with time but i just wanted to show only date(dd/MM/yyyy) format in excel sheet.

Note: i have set the format of exportsetting of excel to "ExcelML"

it's very urgent..
waiting for quick reply..

Thanks
Santosh

Grid

answered on 21 Nov 2012

1 answer

126 views

Update RadGrid DataSource from external class

Hello! I am using Telerik ASP.NET controls to develop a WebApplication in C#, What I need is to show some data in a Grid, so I selected RadGrid to do it.
In my firt test, I just have a textbox with a button, so when you click on it, the text on the textbox is added to a global list, and this list is copied to a local list and added as DataSource:

public static List<string> gl = new List<string>(); //Global list to store all the elements

protected void RadButton3_Click(object sender, EventArgs e)

{

string txt = RadTextBox1.Text;

UpdateGrid(txt);

}

public void UpdateGrid(string elem) //Procedure to update the grid contents

{

gl.Add(elem);

List<string> l = new List<string>(); //Local list to set it as DataSource for the grid, so I don't get the exception

l.AddRange(gl);

RadGrid1.DataSource = l;

RadGrid1.DataBind();

}

I tested it and all worked fine, the problem is that the elements that I have to add to the grid are not those from the textbox, but they come from a WCF Duplex Service. So I add the Service Reference and create the client object to invoke the Service functions. As it is a Duplex Service, the client must implement Callback interface with the function that will be executed when the service returns a value.

I added a new button, to call the service, the Callback class, and a static class "UIGlobal" so I could access to the UpdateGrid method from this Callback class and pass the value I want to add to the grid:

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

{

public static List<string> gl = new List<string>();

protected void Page_Load(object sender, EventArgs e)

{

UIGlobal.MainPage = this; //Initialize the attribute of UIGlobal to get the reference os this page to access the UpdateGrid method

}

protected void RadButton3_Click(object sender, EventArgs e) //Same as before

{

string txt = RadTextBox1.Text;

UpdateGrid(txt);

}

public void UpdateGrid(string elem) //The method that updates the grid

{

gl.Add(elem);

List<string> l = new List<string>();

l.AddRange(gl);

RadGrid1.DataSource = l;

RadGrid1.DataBind();

}

protected void RadButton2_Click(object sender, EventArgs e) //Method that calls the WCF Duplex Service

{

InstanceContext instanceContext = new InstanceContext(new CallbackHandler());

PubSubClient ps_service = new PubSubClient(instanceContext); //Create the object required to call the service

List<string> tops = new List<string>();

tops.Add("realtime.db.analog.0analog.description");

ps_service.subscribe_Integrity(tops); //Call the service function

}

public class CallbackHandler : IPubSubCallback //This is the Callback class

{

public void Send(Change c) //When the service sends a value to the client, this function is executed

{

UIGlobal.MainPage.UpdateGrid(c.value); //Execute the UpdateGrid method with the value that the service sends back

}

public class UIGlobal //This is the class used to access to the page

{

public static Default MainPage { get; set; } //Reference to the page, initialized in the Page_Load method

}

When I execute it, everything seems to work fine, there are not exceptions thrown and I can see how the Send function is executed, it calls the UpdateGrid with the right value, and this function execute all the instructions, but the new value is not added to the grid, so I don't know what is happening, I don't know if it is because the function is being called from the UIGloblal Reference.
I can send you my proyect with both the asp.net client and the duplex service if you want.

Hope somebody can help me. Thanks!!

Grid

answered on 21 Nov 2012

1 answer

81 views

SelfHierarchy Caption Problem

Hi,
I am using SelfHierarchy within my RadGrid and would like to add Caption to my MasterTableView. When I set the caption like;

<MasterTableView HierarchyDefaultExpanded="false" HierarchyLoadMode="Client" AllowSorting="false"

DataKeyNames="RowOrder, ParentId" Caption="Caption Goes Here">

The caption is added to each details table as-well. Screen-shot is attached to see the behavior. I would like to hide caption for the details tables. How can I achieve this?

TIA.

Grid

answered on 21 Nov 2012