I can easily create a databound chart if it’s a simply scenario like totals by month and I’ve already provided the high level grouping in the SQL. But I want to do something like, totals by month by app, and have it be a stacked chart w/ the apps as the series, I don’t know how to do that. I specify from my sql data source the column for the app name (app), and I specify the label (ie Outlook). How in the Category series Item section can I get it to recognize my datafield, and also have it filter on values that only = ‘Outlook’? The example below for the series item sets the values to a static value.
<telerik:ColumnSeries DataFieldY="app" Name="Outlook" Stacked="false" Gap="1.5" Spacing="0.4">
<Appearance>
<FillStyle BackgroundColor="#d5a2bb"></FillStyle>
</Appearance>
<LabelsAppearance DataFormatString="{0}" Position="OutsideEnd"></LabelsAppearance>
<TooltipsAppearance DataFormatString="{0}" Color="White"></TooltipsAppearance>
<SeriesItems>
<telerik:CategorySeriesItem Y="25000"></telerik:CategorySeriesItem>
<telerik:CategorySeriesItem Y="12000"></telerik:CategorySeriesItem>
<telerik:CategorySeriesItem Y="39000"></telerik:CategorySeriesItem>
</SeriesItems>
</telerik:ColumnSeries>
//snippet for the below chart
<telerik:ColumnSeries Name="Lounge">
<Appearance>
<FillStyle BackgroundColor="#850071"></FillStyle>
</Appearance>
<LabelsAppearance DataFormatString="{0} sales" Position="OutsideEnd"></LabelsAppearance>
<TooltipsAppearance DataFormatString="{0} sales" Color="White"></TooltipsAppearance>
<SeriesItems>
<telerik:CategorySeriesItem Y="15000"></telerik:CategorySeriesItem>
<telerik:CategorySeriesItem Y="23000"></telerik:CategorySeriesItem>
<telerik:CategorySeriesItem Y="10000"></telerik:CategorySeriesItem>
</SeriesItems>
</telerik:ColumnSeries>
My dataset looks like this:
day app avg
Tue Outlook 10
Tue Word 4
Tue Excel 7
Wed Outlook 2
etc..
I want this chart to look like online demo example, but instead of Wooden Table, Lounge, etc, it would list the values in the ‘app’ column of my dataset.
I'm creating a very generic table editor and would like to set the readonly property of a grid column at run time. The select and update SQL commands are being generated at runtime and they work perfectly with AutoGenerateColumns="true", but I need to set some columns to readonly. I was hoping to simply enumerate the columns after data binding or on the grid's pre_render, but the column count is always 0 for auto generated columns.
I looked at grid.MasterTableView.RenderColumns, but each column's IsEditable property is read-only.
Anyone know how to accomplish this? I'm trying to avoid dynamically creating each column in code and then appending them to the collection.
When i am trying to Update a data, I should verify that data already available in radgrid or not.
Note - I need to throw error message or alert message if that data already available in grid
I have a RadTextbox inside a <telerik:GridBoundColumn>
By default Radgrid gets loaded with database data. After dataload when i type search text in RadTextbox, the input string should search value in SQL datasource.
My Issue:
I am not able to pass the RadTextbox string to sql select query via Code behind.
Please help!
How can I do this programatically?
http://docs.telerik.com/devtools/wpf/controls/radmenu/features/checkable-items
Hi
I have used DatePicker with bootstrap theme for UI for ASP.NET AJAX Q1 2015.
But when I am opening month pop up the in place of OK and Cancal button true and false text is coming.
And in place of today's date blank text is coming.
I am using I.E to test it.
can you please help me with this issue.
Thanks and Regards,
Ritesh
I created a new skin based off the default skin, changing just the font. Some images are not loaded when the new skin is loaded. An example is in the screenshot. I had to load up a grid with the Default skin, download the images, and place them in the folder containing the page. Surely there's a better way as this means I will have to have copies of these image files in every folder containing pages where a grid is used.
I am using a RadTreeList with an UpdateCommand, which updates one BIT field on SQL Server via a stored procedure. After the update, I force the RadTreeList to rebind its data source, but it OCCASIONALLY will not reflect the updated data (which I know for certain is getting set on SQL Server). Sometimes it shows the new value, sometimes not.
What I have tried in the UpdateCommand:
protected void rtlRoster_UpdateCommand(object sender, TreeListCommandEventArgs e)
{
//some code eliminated for brevity
//Perform the update via SQL stored procedure
SQL.UpdateStoredProc(params...);
//I have tried sleeping before reloading the data source, which is not preferred
Thread.Sleep(1500);
//I have tried forcing the data source to clear out explicitly and then resetting it to the proper data source afterwards
rtlRoster.DataSource = new ArrayList();
rtlRoster.DataBind();
//I have tried forcing it to reload the data source explicitly
rtlRoster_NeedDataSource(sender, new TreeListNeedDataSourceEventArgs(TreeListRebindReason.ExplicitRebind));
//I have tried using this code from an online Telerik example (http://docs.telerik.com/devtools/aspnet-ajax/controls/treelist/data-editing/updating-records/using-inplace-and-editforms-modes)
rtlRoster.EditIndexes.Clear();
rtlRoster.Rebind();
//And I have tried the brute force way of reloading the page
Response.Redirect(Request.RawUrl);
}
I was hoping there would be some obvious setting that I could control, such as RadGrid's <ClientSettings><DataBinding EnableCache="false">, but I see no such property on the RadTreeList.
Any ideas why this would be happening intermittently and how to fix it?
ASP.NET version: 4.0.30319.34209 (though the .NET Framework is 4.5)
OS: Windows 8.1 Pro
exact browser version: IE11, Chrome 44.0.2403.155 m, and FF 39.0
exact version of the Telerik product: Telerik.Web.UI.dll 2013.2.717.45
preferred programming language (VB.NET or C#): C#
Thanks,
Brent Wood