Questions on UI for ASP.NET AJAX Forum

1 answer

1.1K+ 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

108 views

[Solved] 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

415 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

298 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

138 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

97 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

5 answers

492 views

[Solved] Modifying Colums when AutoGenerateColumns=True

Hello,

The scenario:

AutoGenerateColumns is set to true
I attach a DataTable during NeedDataSource
At some point before the page load, I'm trying to hide one of columns if a certain condition is true.

The problem:
No matter which event I try, RadGrid1.MasterTableView.Columns is always empty.

I've tried just about every event: NeedDataSource, OnItemCreated, oncolumncreated, oncolumnsreorder, ondatabound, onprerender, Page.PreRender. At no time is the Columns property populated with columns.

I suppose I could create the columns programmatically from the DataTable but I'd rather let RadGrid do it for me if possible.

Any advice is greatly appreciated.

Thanks,
Jeff

Grid

answered on 21 Nov 2012

3 answers

620 views

RadGrid Binding through DataTable

Hi..
i am binding grid through data table through chart serious click event and set autogeneratecolumns="true" in grid at aspx page and also i didn't apply any code 'gridbound colum & gridtemplate column' like that based on datatable column and rows grid will be generated.
when i click first time in chart serious grid will be generated correctly but second time grid style will be changed in column header and overall structure.. what i want to do be grid same every time i execute this.
and my coding are mentioned below kindly guide me to solve this..

aspx code is

<telerik:RadGrid id="radgrid1" ruunat="server" autogeneratecolumn="true">
<headerstyle horizantalalign="left"/>
</telerik:RadGrid>

aspx.cs code is

DataTable table1=getdata();
radgrid1.datasource=table1;
radgrid1.databound();

thanks in advance..!

Grid

answered on 21 Nov 2012

13 answers

487 views

[Solved] RadGrid - show gridlines even if cell is empty.

Hi

How do I show gridlines even if cell is empty. I want to make this fix in all places. Is there any general code for this issue?

I have the radgrid structure like below

<

netcweb:NCRadGrid runat="server" ID="ActivityGrid"

OnNeedDataSource="ActivityGrid_NeedDataSource"

OnItemCreated="ActivityGrid_OnItemCreated"

PageSize="10" AllowPaging="true" SkinID="ActivityList"

OnPageSizeChanged="ActivityGrid_PageSizeChanged" OnPreRender="ActivityGrid_PreRender">

<telerik:GridTemplateColumn UniqueName="1" HeaderText="My courses student page">

<netcweb:PlaceHolderControl runat="server" ID="column1PlaceHolder">

</netcweb:PlaceHolderControl>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="2" HeaderText="StudentCourseListStatusHeader">

<netcweb:PlaceHolderControl runat="server" ID="column2PlaceHolder">

</netcweb:PlaceHolderControl>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="3" HeaderText="StudentCourseListDateHeader">

<netcweb:PlaceHolderControl runat="server" ID="column3PlaceHolder">

</netcweb:PlaceHolderControl>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="4" HeaderText="">

<netcweb:ImageCheckBoxControl runat="server" ID="DetailedListCheckBox"

OnCheckedChanged="DetailedListCheckBox_OnCheckedChanged" AutoPostBack="true"

SkinID="DetailedView" />

</HeaderTemplate>

<netcweb:PlaceHolderControl runat="server" ID="column4PlaceHolder">

</netcweb:PlaceHolderControl>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

</netcweb:NCRadGrid>

I tried the below code. All the values reside that grid was returns empty.

protected void ActivityGrid_PreRender(object sender, EventArgs e)

{

foreach (GridDataItem dataItem in ActivityGrid.MasterTableView.DetailTables[0].Items)

{

foreach (GridColumn col in ActivityGrid.MasterTableView.DetailTables[0].Columns)

{

if (dataItem[col.UniqueName].Text == string.Empty)

dataItem[col.UniqueName].Text =

" ";

}

Grid

answered on 21 Nov 2012

0 answers

97 views

TreeView NodeExpand interferes with RadAjaxPanel

Hi,
I have a RadTreeView inside a RadAjaxPanel, and I drag&drop items onto another RadTreeView, or a RadPane. What i have done is instead of subscribing to the server side OnNodeDrop, capture the OnClientNodeDropping of the treeView, and then make an ajax call through ajaxPanel.ajaxRequest.

It seems that the when I am sending the ajax calls from the treeview with my ajaxPanel.ajaxRequest, they travel through a different ajax channel, because, first of all, the loading panel doesn't show, and also only the other treeView on the page refreshes. The server does receive the call, though. If the drop is on the RadPane, or any other html element for that matter, no refresh happens at all.

Now, here's the interesting part. I have another treeview with a similar functionality which works just fine. I started making the two treeViews look each other by eliminating the differences, and found out that if I set the OnNodeExpand event handler for the treeView, this issue arises, and if I remove that, everything works alright.

In a nutshell, if the OnNodeExpand event handler is added to the treeview, ajax calls that are initiated from the treeView and go through ajaxPanel or ajaxManager, do reach the server, but do not refresh the intended controls on return. The only exception seems to be other treeViews on the page, which are refreshed correctly, but without showing the LoadingPanel.

I hope this is not too confusing.

Thanks
Safa

TreeView

asked on 20 Nov 2012