Questions on UI for ASP.NET AJAX Forum

1 answer

161 views

I have a bound RadGrid which has three columns that are aggregated (Aggregate="Avg") on it. These three columns are of type currency. My challenge here is that the aggregation needs to be conditional based upon the value in the cell. If the value is $0.00, then it should not be included in the Average calculation. I know this seems odd, but it's the request that my users are giving to me.

Take the following example of the data in a segment of the grid

Sale Amount
$45.00
$50.00
$100.00
$0.00
-----------
Avg $48.75

The average calculation will be the sum of fields divided by the row count or (45 + 50 + 100 + 0) / 4 = 48.75

HOWEVER

What my users want is for this calculation to be (45 + 50 + 100 + 0) / 3 = 65 They want the row with $0.00 to not be included in the average calculation.

The documentation for the Aggregate (http://www.telerik.com/help/aspnet-ajax/grdtotalsingridfooters.html) has a little tidbit on the first page which *might* be what I'm looking for, but I'm not sure if it is or how to use it:

" RadGrid will calculate aggregates over the entire data source and will respect the filter expression applied (if present)"

Any assistance is very much appreciated!

Thank you,
Michael Smith

Grid

answered on 08 Jan 2011

1 answer

131 views

treeview with checkbox

hi
please see the attached file
how can i make this picture with treeview?
thanks a lot

TreeView

answered on 08 Jan 2011

1 answer

74 views

Grid Has No Style / Skin

I am using the RadGrid in a page - but for some reason it displays without any skin / styling. The grid is in a usercontrol - and I have a RadFormDecorator declared in the main page.

Here is the code I am using to display the grid:

<telerik:RadGrid ID="AddUserGrid" AutoGenerateColumns="false" ShowFooter="true" Width="400px" runat="server">

<PagerStyle Mode="NextPrevAndNumeric" />

<MasterTableView AutoGenerateColumns="false" TableLayout="Auto" ShowFooter="true">

<Columns>

<telerik:GridBoundColumn DataField="email" HeaderText="Email" />

<telerik:GridBoundColumn DataField="username" HeaderText="UserName" />

</Columns>

</MasterTableView>

<ClientSettings>

<Selecting AllowRowSelect="true" />

</ClientSettings>

</telerik:RadGrid>

And here is how it looks:
Rendered Grid

Any idea on why all the style would be missing?

Grid

answered on 07 Jan 2011

9 answers

391 views

Can't find Nwind.mdb for demo

I am trying to do the tutorial located at:http://www.telerik.com/help/aspnet-ajax/grddesigncreatinghierarchicalgrids.html that a telerik staffer recommended I complete. The problem is (as always) I can not find all the components to even learn the tutorial, namely, the ACCESS database file called Nwind.mdb. I looked in the Live Demos/App_Data file (C:\Program Files\Telerik\RadControls for ASPNET AJAX Q3 2008\Live Demos\App_Data) and there is no Nwind.mdb file residing there. I performed a search on my box and found this particular ACCESS database within another application (Developer Express .net), but nothing in the Live Demos/App_Data folder as the tutorial instructs, only Northwind.mdf and the Northwind.ldf.

Now because I needed the .MDB file, not a .MDF file, I copied and pasted the Nwind.mdb file from the Developer Express folder and pasted it in the Live Demos/App_Data folder in Telerik. I then copied said database file from the Dev Express directory and pasted it from that directory into the Live Demos/App_Data file of my telerik project as the tutorial instructs. However, when I try to configure the database to the AccessDataSource1 control for the RadGrid to display the data, I keep receiving the following error:

Database schema could not be retrieved for this connection. Please make sure the connections settings are correct and that the databse i online. Unspecified error

Why can't I connect to the database? I'm online, which I don't know how that makes any difference since the Live Demos/App_data directory is on hard drive.

Grid

answered on 07 Jan 2011

0 answers

150 views

Setting default selection of a radcombobox in GridEditableItem

I have a RadGrid that is using a FormTemplate when inserting/updating values.

One of the values in my SQL Table is a bit flag. That is, it's going to be either true or false.

I can easily set this bit using a checkbox like the following in my FormTemplate:

<asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Eval("CanBeFatal") != DBNull.Value ? Convert.ToBoolean(Eval("CanBeFatal")) : false %>' />

This essentially selects the checkbox if the flag is set to true. However, I would prefer to display a RadComboBox instead of a checkbox and set the selected item based on the value of the bit flag. I've tried various methods to achieve this, but haven't had any success. I'm not sure if this is even possible, but any help would be appreciated.

Based on the sample below, if my bit flag is set to false, I would like the RadComboBox to have the 2nd item selected. For simplity of this message, I am leaving out the various methods I used to evaluate the bit flag and attempt to set the selection in the sample to avoid confusion.

<telerik:RadComboBox ID="RadComboBox2" runat="server" >

<Items>

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

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

</Items>

</telerik:RadComboBox>

Thanks!

UPDATE:
I was finally able to set the selection after playing a bit more. Seems the value for the bit is case sensitive. I got it working by doing the following:

<telerik:RadComboBox ID="RadComboBox2" runat="server" SelectedValue='<%# Eval("CanBeFatal") %>'>

<Items>

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

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

</Items>

</telerik:RadComboBox>

Guess I spoke to soon. Hope this helps someone else!

Grid

asked on 07 Jan 2011

1 answer

296 views

want to show confirmation message on button click

Hello in my grid i hv one button inside the grid ..

<telerik:GridTemplateColumn DataField="DelFlag" HeaderText="Status" SortExpression="DelFlag"
                            HeaderStyle-HorizontalAlign="Center" UniqueName="DelFlag" Visible="true" AllowFiltering="false">
                            <ItemTemplate>
                               <asp:Button ID="btnStatus" Font-Size="11px" Width="65px" runat="server" Text='<%#Eval("DelFlag")%>'
                                 CommandName="Command" />
                            </ItemTemplate>
                            <ItemStyle VerticalAlign="Middle" HorizontalAlign="Center" />
                        </telerik:GridTemplateColumn>

if user click on button want to show the message "Are you sure want's to change status?". if user click yes then update status otherwise not.

Please find attached image file u get an idea. In image file Status column that button .. on click on that button want to show the confirmation message.

thanks

Grid

answered on 07 Jan 2011

5 answers

165 views

Still not the treelist that i was expecting :(

Hi everyone.
I don´t speak very well english so my apologizes

I am user of telerik asp.net Ajax, and i like it .
I have tried the aspxTreelist of Devexpress and i was expecting something alike, but is not, i am very upset.

I was expecting double click expand/colapse, sumary , Edit on place (like form) , scrollbars ,etc..

I have a project to finish and i use Telerik Asp.Net Ajax , but i have to buy only the component of aspxTreeList of Devexpress :(

I expect that issues comes in the next release.

Thanks

TreeList

answered on 07 Jan 2011

10 answers

264 views

RadMenu and Caching

Hi,

I have a radmenu in a user control which is loaded dyanamically from another user control. On first load of the site, i.e. after compilation, the menu operates correctly but on subsequent loads it does not an iisreset is needed for the menu to work again. This is due to me having output caching enabled (sql cache dependency). I get the sys is not defined/telerik not defined errors.

Remove the caching and everything is fine. I need to cache the menu / data as it is intensive to get the data. Anyone know what I need to do so I can set the output cache and the menu continue to work properly?

Thanks,

Leon.

Menu

answered on 07 Jan 2011

1 answer

99 views

ComboBox, IE and Backspace problem

Hi,
i've got a problem with telerik combobox in IE, when I enter the combobox and press BackSpace it redirects me to the previous page.

In FF, it works fine. Don't you know where could be a problem?

Here is my code:
<telerik:RadComboBox ID="comboCompany" runat="server" Width="304px" OnClientSelectedIndexChanging="LoadSites">
</telerik:RadComboBox>

Thanks for answer.

ComboBox

answered on 07 Jan 2011

12 answers

499 views

RadGrid Item Missing Border when null

Hello,

I have a RadGrid populated from a method in a class file. When I bind the grid one of the columns is populated with a space, " ". For some reason, this causes the RadGrid to not place borders/gridlines around the items in that column. I've attached an example of what this looks like.

Any help would be appreciated.

Thanks,
Casey

Grid

answered on 07 Jan 2011