Questions on UI for ASP.NET AJAX Forum

8 answers

335 views

Auto populate radGrid from search textbox

I want to know if this is possible - I haven't seen anything out there yet. I have a radTextBox in the header of my radGrid. When the user enters a letter/number for the name I want the radGrid to autopopulate based upon what is entered in the search box - could be 1 - 7 letters. Thanks for your help.

Ajax

answered on 03 Feb 2011

1 answer

42 views

Items in Pages Question

Hello,

At the base of my Grid control, I have the Telerik.Web.UI.GridPagerMode.NextPrevAndNumeric set as PagerStyle.Mode. It shows the next page buttons, as well as a drop down list box of items on the page to the left. And on the far right, it shows the number of items per page, such as "5 items in 4 pages."

I would like to move that "5 items in 4 pages" text to be left aligned with the drop down box. However, I can't figure out how to do it. It seems as though the drop down box has a width of 100%, which pushes the "5 items" text to the right size. I've tried various CSS tags to style the controls, but either I'm not doing it right, or what I want to do can't be done.

Has anyone tackled this? I think it's pretty simple, but I'm just stumped on how to do it.

Thanks!
Kevin J Baird

Grid

answered on 03 Feb 2011

1 answer

42 views

radajaxloadingpanel

Hello,
I have a solution using masterpage, in witch i have pur radAjaxManager, and every page i am doing ajax, it is done in the master , with loadingpanel, that is set in the master. I have wrote it like this :

<

telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server"

Skin="Vista" IsSticky="true" BackgroundPosition="Center" Height="60px"

Width="70px" HorizontalAlign="Center">

</telerik:RadAjaxLoadingPanel>

<asp:ContentPlaceHolder ID="contentBody" runat="server">

--------------Here comes the pages---------------
</asp:ContentPlaceHolder>
Actually , when ajax workes, i see the image loading but it is positioned in top of the page, and also take place. I want it to be in the center of the ajaxed place, and to above the content, not instead place in the content.
Is it possible?

I have attached a picture of how my loadingPanel is seen when ajaxed.

Thanks,
gila

Ajax

answered on 03 Feb 2011

2 answers

108 views

html viewer control with scroll bar

Hi

I’m trying to setup a terms & conditions box.

What mechanism/control can I use to display html T & C text (coming from a data field) on a web form such that when user scrolls to the bottom of the text using scroll bar then an event is fired to designate that user has read all the text?

Many Thanks

Regards

General Discussions

answered on 03 Feb 2011

1 answer

70 views

RadGrid with Refresh

I have a RadGrid with Refresh on Command line. I am not using ajax for Grid but want that ajax action when I click refresh. I deleted the following code

<telerik:AjaxSetting AjaxControlID="RadGrid">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadGrid"

LoadingPanelID="RadAjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

How can I just add refresh to ajax ?

Please help,
Smiely

Grid

answered on 03 Feb 2011

2 answers

80 views

Google-like Filtering of Hierarchical Grid

I have a Hierarchical RADGrid...

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

GridLines="None"

Width="900px"

OnNeedDataSource="RadGrid1_NeedDataSource"

oncolumncreated="RadGrid1_ColumnCreated"

AutoGenerateHierarchy="true"

AutoGenerateColumns="true" >

</telerik:RadGrid>

That I "adjust" using code-behind...

protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

this.RadGrid1.DataSource = CreateDataSet();

}

private DataSet CreateDataSet()

{

DataSet dataset = new DataSet();

string previousFY = string.Empty;

string currentFY = string.Empty;

if (DateTime.Now.Month >= 7)

{

previousFY = DateTime.Now.Year.ToString();

currentFY = (DateTime.Now.Year + 1).ToString();

}

else

{

previousFY = (DateTime.Now.Year - 1).ToString();

currentFY = DateTime.Now.Year.ToString();

}

OpenDataDataContext db = new OpenDataDataContext();

// FUND

var prevFYFundTotals = from t in db.open_FY_Totals

join f in db.Funds on new { Fund = t.Fund } equals new { Fund = f.fieldcode }

where

t.FY == currentFY

group new { t, f } by new

{

t.FY,

Fund = t.Fund.Substring(0, 2)

} into g

orderby

g.Key.FY,

g.Key.Fund

select new

{

g.Key.FY,

g.Key.Fund,

Fund_Desc = g.Max(p => p.f.desc30),

Budget = String.Format("{0:$#,0.00}", (System.Decimal?)g.Sum(p => p.t.BudgetAmt)),

Actual = String.Format("{0:$#,0.00}", (System.Decimal?)g.Sum(p => p.t.ActualAmt)),

Encumbered = String.Format("{0:$#,0.00}", (System.Decimal?)g.Sum(p => p.t.EncAmt)),

Committed = String.Format("{0:$#,0.00}", (System.Decimal?)(g.Sum(p => p.t.ActualAmt) + g.Sum(p => p.t.EncAmt))),

PercentCommitted = String.Format("{0:0.00}%", (Decimal?)Convert.ToDecimal((g.Sum(p => p.t.ActualAmt) + g.Sum(p => p.t.EncAmt)) / g.Sum(p => p.t.BudgetAmt) * 100)),

Remaining = String.Format("{0:$#,0.00}", (System.Decimal?)(g.Sum(p => p.t.BudgetAmt) - (g.Sum(p => p.t.ActualAmt) + g.Sum(p => p.t.EncAmt))))

};

DataTable dtPrevFYFundTotals = new DataTable();

dtPrevFYFundTotals.TableName = "PrevFYFundTotals";

dtPrevFYFundTotals.Columns.Add("Fund", typeof(string));

dtPrevFYFundTotals.Columns.Add("Fund_Desc", typeof(string));

dtPrevFYFundTotals.Columns.Add("Budget", typeof(string));

dtPrevFYFundTotals.Columns.Add("Actual", typeof(string));

dtPrevFYFundTotals.Columns.Add("Encumbered", typeof(string));

dtPrevFYFundTotals.Columns.Add("Committed", typeof(string));

dtPrevFYFundTotals.Columns.Add("PercentCommitted", typeof(string));

dtPrevFYFundTotals.Columns.Add("Remaining", typeof(string));

DataColumn[] keys = new DataColumn[1];

keys[0] = dtPrevFYFundTotals.Columns["Fund"];

dtPrevFYFundTotals.PrimaryKey = keys;

dataset.Tables.Add(dtPrevFYFundTotals);

foreach (var item in prevFYFundTotals)

{

dtPrevFYFundTotals.Rows.Add(new object

[] { item.Fund, item.Fund_Desc, item.Budget, item.Actual, item.Encumbered, item.Committed, item.PercentCommitted, item.Remaining });

}

// RESP

var prevFYRespTotals = from t in db.open_FY_Totals

join r in db.Resps on new { Resp = t.Resp } equals new { Resp = r.fieldcode }

where

t.FY == currentFY

group new { t, r } by new

{

t.FY,

Fund = t.Fund.Substring(0, 2),

t.Resp

} into g

orderby

g.Key.Fund,

g.Key.Resp

select new

{

Fund = g.Key.Fund.Substring(0, 2),

Resp = g.Key.Resp.Replace(".", ""),

Resp_Desc = g.Max(p => p.r.desc30),

Budget = String.Format("{0:$#,0.00}", (System.Decimal?)g.Sum(p => p.t.BudgetAmt)),

Actual = String.Format("{0:$#,0.00}", (System.Decimal?)g.Sum(p => p.t.ActualAmt)),

Encumbered = String.Format("{0:$#,0.00}", (System.Decimal?)g.Sum(p => p.t.EncAmt)),

Committed = String.Format("{0:$#,0.00}", (System.Decimal?)(g.Sum(p => p.t.ActualAmt) + g.Sum(p => p.t.EncAmt))),

PercentCommitted = String.Format("{0:0.00}%"

, g.Sum(p => p.t.BudgetAmt) > 0 ? ((g.Sum(p => p.t.ActualAmt) + g.Sum(p => p.t.EncAmt)) / g.Sum(p => p.t.BudgetAmt)) * 100 : 0),

Remaining = String.Format("{0:$#,0.00}", (System.Decimal?)(g.Sum(p => p.t.BudgetAmt) - (g.Sum(p => p.t.ActualAmt) + g.Sum(p => p.t.EncAmt))))

};

DataTable dtPrevFYRespTotals = new DataTable();

dtPrevFYRespTotals.TableName = "PrevFYRespTotals";

dtPrevFYRespTotals.Columns.Add("Fund", typeof(string));

dtPrevFYRespTotals.Columns.Add("Resp", typeof(string));

dtPrevFYRespTotals.Columns.Add("Resp_Desc", typeof(string));

dtPrevFYRespTotals.Columns.Add("Budget", typeof(string));

dtPrevFYRespTotals.Columns.Add("Actual", typeof(string));

dtPrevFYRespTotals.Columns.Add("Encumbered", typeof(string));

dtPrevFYRespTotals.Columns.Add("Committed", typeof(string));

dtPrevFYRespTotals.Columns.Add("PercentCommitted", typeof(string));

dtPrevFYRespTotals.Columns.Add("Remaining", typeof(string));

keys = new DataColumn[2];

keys[0] = dtPrevFYRespTotals.Columns["Fund"];

keys[1] = dtPrevFYRespTotals.Columns["Resp"];

dtPrevFYRespTotals.PrimaryKey = keys;

dataset.Tables.Add(dtPrevFYRespTotals);

foreach (var item in prevFYRespTotals)

{

dtPrevFYRespTotals.Rows.Add(new object

[] { item.Fund, item.Resp, item.Resp_Desc, item.Budget, item.Actual, item.Encumbered, item.Committed, item.PercentCommitted, item.Remaining });

}

//OBJECT

var prevFYObjTotals = from t in db.open_FY_Totals

join o in db.Object_Mgts on new { Obj = t.Obj } equals new { Obj = o.fieldcode }

where

t.FY == currentFY

group new { t, o } by new

{

t.FY,

Fund = t.Fund.Substring(0, 2),

t.Resp,

t.Obj

} into g

orderby

g.Key.Fund,

g.Key.Resp,

g.Key.Obj

select new

{

Fund = g.Key.Fund.Substring(0, 2),

Resp = g.Key.Resp.Replace(".", ""),

Obj = g.Key.Obj.Replace(".", ""),

Obj_Desc = g.Max(p => p.o.desc30),

Budget = String.Format("{0:$#,0.00}", (System.Decimal?)g.Sum(p => p.t.BudgetAmt)),

Actual = String.Format("{0:$#,0.00}", (System.Decimal?)g.Sum(p => p.t.ActualAmt)),

Encumbered = String.Format("{0:$#,0.00}", (System.Decimal?)g.Sum(p => p.t.EncAmt)),

Committed = String.Format("{0:$#,0.00}", (System.Decimal?)(g.Sum(p => p.t.ActualAmt) + g.Sum(p => p.t.EncAmt))),

PercentCommitted = String.Format("{0:0.00}%"

, g.Sum(p => p.t.BudgetAmt) > 0 ? ((g.Sum(p => p.t.ActualAmt) + g.Sum(p => p.t.EncAmt)) / g.Sum(p => p.t.BudgetAmt)) * 100 : 0),

Remaining = String.Format("{0:$#,0.00}", (System.Decimal?)(g.Sum(p => p.t.BudgetAmt) - (g.Sum(p => p.t.ActualAmt) + g.Sum(p => p.t.EncAmt))))

};

DataTable dtPrevFYObjTotals = new DataTable();

dtPrevFYObjTotals.TableName = "PrevFYObjTotals";

dtPrevFYObjTotals.Columns.Add("Fund", typeof(string));

dtPrevFYObjTotals.Columns.Add("Resp", typeof(string));

dtPrevFYObjTotals.Columns.Add("Obj", typeof(string));

dtPrevFYObjTotals.Columns.Add("Obj_Desc", typeof(string));

dtPrevFYObjTotals.Columns.Add("Budget", typeof(string));

dtPrevFYObjTotals.Columns.Add("Actual", typeof(string));

dtPrevFYObjTotals.Columns.Add("Encumbered", typeof(string));

dtPrevFYObjTotals.Columns.Add("Committed", typeof(string));

dtPrevFYObjTotals.Columns.Add("PercentCommitted", typeof(string));

dtPrevFYObjTotals.Columns.Add("Remaining", typeof(string));

keys = new DataColumn[3];

keys[0] = dtPrevFYObjTotals.Columns["Fund"];

keys[1] = dtPrevFYObjTotals.Columns["Resp"];

keys[2] = dtPrevFYObjTotals.Columns["Obj"];

dtPrevFYObjTotals.PrimaryKey = keys;

dataset.Tables.Add(dtPrevFYObjTotals);

foreach (var item in prevFYObjTotals)

{

dtPrevFYObjTotals.Rows.Add(new object

[] { item.Fund, item.Resp, item.Obj, item.Obj_Desc, item.Budget, item.Actual, item.Encumbered, item.Committed, item.PercentCommitted, item.Remaining });

}

// Create Relationships

// Fund DataTable to Resp DataTable relationship

DataRelation FundRespRelation = new DataRelation("FundResp", dataset.Tables["PrevFYFundTotals"].Columns["Fund"],

dataset.Tables["PrevFYRespTotals"].Columns["Fund"]);

// Resp DataTable to Obj DataTable

DataRelation RespObjRelation = new DataRelation("RespObj", dataset.Tables["PrevFYRespTotals"].Columns["Resp"],

dataset.Tables["PrevFYObjTotals"].Columns["Resp"]);

// there may not be records all the way down...

dataset.EnforceConstraints = false;

dataset.Relations.Add(FundRespRelation);

dataset.Relations.Add(RespObjRelation);

return dataset;

}

protected void RadGrid1_ColumnCreated(object sender, GridColumnCreatedEventArgs e)

{

if (e.Column.UniqueName == "Fund")

e.Column.Visible = false;

else if (e.Column.UniqueName == "Resp")

e.Column.Visible = false;

else if (e.Column.UniqueName == "Obj")

e.Column.Visible = false;

else if (e.Column.HeaderText.Contains("Desc"))

{

e.Column.HeaderText = "Account Description";

e.Column.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;

e.Column.HeaderStyle.VerticalAlign = VerticalAlign.Bottom;

if (e.OwnerTableView.Name == "")

e.Column.HeaderStyle.Width = Unit.Pixel(350);

else if (e.OwnerTableView.Name == "PrevFYRespTotals")

e.Column.HeaderStyle.Width = Unit.Pixel(265);

else

e.Column.HeaderStyle.Width = Unit.Pixel(240);

}

else if (e.Column.HeaderText == "Budget")

{

e.Column.HeaderText = "Annual Budget";

e.Column.HeaderStyle.HorizontalAlign = HorizontalAlign.Right;

e.Column.HeaderStyle.VerticalAlign = VerticalAlign.Bottom;

e.Column.HeaderStyle.Width = Unit.Pixel(100);

e.Column.ItemStyle.HorizontalAlign = HorizontalAlign.Right;

}

else if (e.Column.HeaderText == "Actual")

{

e.Column.HeaderText = "Actual Spent";

e.Column.HeaderStyle.HorizontalAlign = HorizontalAlign.Right;

e.Column.HeaderStyle.VerticalAlign = VerticalAlign.Bottom;

e.Column.HeaderStyle.Width = Unit.Pixel(100);

e.Column.ItemStyle.HorizontalAlign = HorizontalAlign.Right;

}

else if (e.Column.HeaderText == "Encumbered")

{

e.Column.HeaderText = "Unpaid Purchase Orders";

e.Column.HeaderStyle.HorizontalAlign = HorizontalAlign.Right;

e.Column.HeaderStyle.VerticalAlign = VerticalAlign.Bottom;

e.Column.HeaderStyle.Width = Unit.Pixel(100);

e.Column.ItemStyle.HorizontalAlign = HorizontalAlign.Right;

}

else if (e.Column.HeaderText == "Committed")

{

e.Column.HeaderText = "Total Committed";

e.Column.HeaderStyle.HorizontalAlign = HorizontalAlign.Right;

e.Column.HeaderStyle.VerticalAlign = VerticalAlign.Bottom;

e.Column.HeaderStyle.Width = Unit.Pixel(100);

e.Column.ItemStyle.HorizontalAlign = HorizontalAlign.Right;

}

else if (e.Column.HeaderText == "Percent Committed")

{

e.Column.HeaderText = "Percent Committed";

e.Column.HeaderStyle.HorizontalAlign = HorizontalAlign.Right;

e.Column.HeaderStyle.VerticalAlign = VerticalAlign.Bottom;

e.Column.HeaderStyle.Width = Unit.Pixel(50);

e.Column.ItemStyle.HorizontalAlign = HorizontalAlign.Right;

}

else if (e.Column.HeaderText == "Remaining")

{

e.Column.HeaderText = "Remaining Budget";

e.Column.HeaderStyle.HorizontalAlign = HorizontalAlign.Right;

e.Column.HeaderStyle.VerticalAlign = VerticalAlign.Bottom;

e.Column.HeaderStyle.Width = Unit.Pixel(100);

e.Column.ItemStyle.HorizontalAlign = HorizontalAlign.Right;

}

The result is attached...

I want to add 'Google-like filtering' but I only need to filter on the 'Account Description' column (at each level).

I looked at the Telerik.Web.Examples.Integration.GridAndCombo example and tried to use it as a jumping off point but since it isn't a hierarchical grid i started running into walls.

Can you please point me in the right direction?

Grid

answered on 03 Feb 2011

1 answer

194 views

Telerik Controls not rendering in IIS 7

Hi guys (and girls),

I have been scouring the net for a solution to a problem some colleagues of mine have been having but have been unsuccessful in finding an answer.

Problem : Our default browser here is IE 6.0 and our Web Server is running IIS 6.0 and we are having all sorts of issues with CSS (which we currently did not have using IE 6.0 and VS 2010) so we have decided to see if we have the same problems running on IIS 7.0. Now here is the problem, I cannot get any of the RAD controls to actually render onto the page? Now I have read posts saying that the app pool should run in classic or you can add a handler to the <system.webServer> section of the web.config file but neither have made any change.

<add name="Telerik_Web_UI_WebResource_axd" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" preCondition="integratedMode,runtimeVersionv2.0"/>

Initially I had a bit of trouble getting classic to work due to the ISAPI and CGI http Handlers not being enabled but I think I managed to sort that out.

Any help on the issue would be much appreciated.

Thanks in advance,
Matthew Burhop

General Discussions

answered on 03 Feb 2011

1 answer

76 views

combobox inside radwindow changes the window property

Hi in my application i have a radwindow with treeview inside a combobox for selecting items ...
Issue is i have set the height and width of the window, and if i click the combobox the height remains the same but i am getting a scrollbar to navigate the treeview...

what property can i set inorder to display the treeview items out of the window if it exceeds the window height so that users don wnat to scroll the window for selecting the items...

Window

answered on 03 Feb 2011

1 answer

47 views

Skin problem...

Hi,

I'm dynamically creating a RadGrid on PageLoad event and binding some data.
i have set the property EnableEmbededSkins="false" i have imported the skin file to the "/app_themes/forest/grid.css".
i have set the property Skin="Forest". i have enabled grouping options in the grid.

problem is I'm not able to see style for the "Grouping" buttons.
one more problem is sum of all columns width is not taking 100%.
i have set the grid width property to 100%.

Thanks
K²

Grid

answered on 03 Feb 2011

1 answer

145 views

problem with RadGrid if using ClientEvents-OnCommand and ItemCommand

Hi,
i am facing following problem with RadGrid if i am using ClientEvents-OnCommand.
the problem is if i am adding ClientEvents-OnCommand in radgrid, it does fire itemcomamnd event of grid for user defined command,
but it always points to the first item in radgrid (e.Item) .

.ascx

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

</script>

</telerik:RadCodeBlock>

.cs

    protected void Page_Load(object sender, EventArgs e)
    {
        this.RadGrid1.ItemCommand += OnItemCommand;
        this.RadGrid1.ClientSettings.ClientEvents.OnCommand = "OnCommand";
    }

    void OnItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
    {
        if (e.Item == null)
            return;

        switch (e.CommandName)
        {
            // user defined
            case "Standard":

GridDataItem item = (GridDataItem)e.Item;

// e.g id is always Id of the first item in radgrid if ClientEvents-OnCommand is defined
var id = new Guid(item["Id"].Text);
... etc

if i remove ClientEvents-OnCommand, it works fine.

am i doing anything wrong ?

Grid

answered on 03 Feb 2011