Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
210 views

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.

Danail Vasilev
Telerik team
 answered on 24 Aug 2015
3 answers
495 views

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.

Viktor Tachev
Telerik team
 answered on 24 Aug 2015
1 answer
55 views

 

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

Viktor Tachev
Telerik team
 answered on 24 Aug 2015
1 answer
118 views

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!

 

 

 

 

Viktor Tachev
Telerik team
 answered on 24 Aug 2015
7 answers
454 views
We're using the radalert, radprompt and radconfirm windows to replace the browser's default dialogs. The problem we're experiencing is when providing  text to these windows that is larger then expected. The windows do size nicely vertically. The trouble is that the windows do not get centered correctly. When calculating the height of the window, it seems that the default given size is used instead of the actual size of the windows.

So let's say I open a radalert with width=300 and height=200. Due to the large content provided to the radalert window, the height of the window in effect becomes larger than 200, say 350. As a result the radalert gets centered correctly horizontally, but it's off-centre vertically. It looks like the calculation of the position still uses a height of 200 instead of the actual 350. I have digged into the code and tried to manually fix this, but I can't figure out how to do it. Any suggestions?
Eyup
Telerik team
 answered on 24 Aug 2015
3 answers
296 views
Hi,
My requirement is Bind the grid dynamic , and add the controls like Text Box And rad Como box at run time by Item value.
so far have done the control adding and now my grid is ready to take values from user , 
but when user selected value from rad combo box (dynamic added control in grid), and click the save button i cannot find the Rad Combo box 
pls suggest me the way how to get the values for dynamically added controls in Rad-grid on button click.
below are the steps i followed
1. Added Grid in Aspx. with Autogenerated Column = true
2. On Item created event added dynamic controls in Grid. 
3. bind the data to ad combo box (dynamic added control in grid) 
4. on save Button i have to save the selected values from rad combo box (dynamic added control in grid), to data base
in above step 1 to 3 are done , but step 4 making me trouble .

below is code for button click.
protected void btnSaveAll_Click(object sender, EventArgs e)
{
    Questionnaire MyQue = Questionnaire.getQuestionnaire(mQuestionnaireid); 
    ArrayList ColumnLst = GetColumnList();
                Dictionary<string,string> RowSplitValue = new Dictionary<string,string>();
                foreach (GridEditableItem Item in rgPivotQuestionnaireResult.MasterTableView.Items)
                {
                    foreach (GridColumn Column in rgPivotQuestionnaireResult.MasterTableView.RenderColumns)
                    {
                        if (ColumnLst.Contains(Column.UniqueName))
                        {
                            //RowSplitValue = new Dictionary<string, string>(Item.SavedOldValues[Column.UniqueName]);
                            if (Item[Column].Controls.Count > 0)
                            {
                                Control ItemControle= new Control();
                                ItemControle = Item[Column].Controls[0];
                                if (ItemControle is TextBox)
                                {
                                    TextBox TxtBx = (TextBox)Item[Column].Controls[0];
                                }
                                if (Item[Column].Controls.Count > 1)
                                {
                                    ItemControle = Item[Column].Controls[1];
                                    if (ItemControle is RadComboBox)
                                    {
                                        RadComboBox RCB = (RadComboBox)Item[Column].Controls[1];
                                          MyQue .Answervalue = RCB.SelectedValue;
                                    }
                                }
                            }
                        }
                    }
                }
   MyQue .Save();
}
Viktor Tachev
Telerik team
 answered on 24 Aug 2015
3 answers
121 views

How can I do this programatically?

 

http://docs.telerik.com/devtools/wpf/controls/radmenu/features/checkable-items​

Aneliya Petkova
Telerik team
 answered on 24 Aug 2015
4 answers
204 views

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

Maria Ilieva
Telerik team
 answered on 24 Aug 2015
1 answer
87 views

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.

 

Maria Ilieva
Telerik team
 answered on 24 Aug 2015
1 answer
196 views

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.Update​StoredProc(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

Angel Petrov
Telerik team
 answered on 24 Aug 2015
Narrow your results
Selected tags
Tags
+? more
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?