Telerik Forums
UI for ASP.NET AJAX Forum
3 answers
877 views
Hi I need to export data via the radgrid to excel - problem is the key field is a ten digit number which the first six is the patient date of birth ...

Problem is when excel opens with the export the leading zero is missing therefore no longer the patient number

example before export - number 0101071111 
                        after export - number 101071111

Any ideas?
Peter Milchev
Telerik team
 answered on 13 Jul 2018
6 answers
1.0K+ views

I am creating RadHTMLChart programmatically to generate a single line chart with date on the x-axis and integers on the Y axis.. Everything seems to be working correctly but when I look closer to the data points the graph does not seem to be drawing every singles data point from the source. I am attaching an screenshot of the generated chart . I know that between the firs tool tip ("58") and the second tool tip ("31) . I have some data points that fluctuate to 59 then back to 58 and then 59 again but I do not see this reflected on my graph. Does HtmlChart takes an avarage to draw the graph or how does it work? Please any help would be appreciate it.

 The data source of the graph is obtained of a filtered CSV file.

Here is my code:

RadHtmlChart PowerChart = new RadHtmlChart();
            PowerChart.ID = "PowerChart";
            PowerChart.Width = Unit.Pixel(1200);
            PowerChart.Height = Unit.Pixel(500);
            PowerChart.Transitions = true;
            PowerChart.Skin = "Silk";
            PowerChart.Appearance.FillStyle.BackgroundColor = System.Drawing.Color.White;
            PowerChart.ChartTitle.Appearance.Align = Telerik.Web.UI.HtmlChart.ChartTitleAlign.Center;
            PowerChart.ChartTitle.Appearance.BackgroundColor = System.Drawing.Color.Transparent;
            PowerChart.ChartTitle.Appearance.Position = Telerik.Web.UI.HtmlChart.ChartTitlePosition.Top;
            LineSeries PowerChartLineSeries = new LineSeries();
            //PowerChartLineSeries.DataFieldY = "BatteryCapacity"; // ??? mayb non global
            PowerChart.PlotArea.XAxis.DataLabelsField = "DateandTime";
            PowerChart.PlotArea.XAxis.Type = Telerik.Web.UI.HtmlChart.AxisType.Date;
            PowerChart.PlotArea.XAxis.TitleAppearance.Text = "Date";
            PowerChart.PlotArea.XAxis.MajorGridLines.Color = System.Drawing.ColorTranslator.FromHtml("#EFEFEF");
            PowerChart.PlotArea.XAxis.MajorGridLines.Width = 1;
            PowerChart.PlotArea.XAxis.MinorGridLines.Color = System.Drawing.ColorTranslator.FromHtml("#F7F7F7");
            PowerChart.PlotArea.XAxis.MinorGridLines.Width = 1;
            PlotBand yAxisPlotBandDanger = new PlotBand();
            yAxisPlotBandDanger.Color = System.Drawing.ColorTranslator.FromHtml("#CC0000");
            yAxisPlotBandDanger.Alpha = 190;
            PlotBand yAxisPlotBandDanger2 = new PlotBand();
            yAxisPlotBandDanger2.Color = System.Drawing.ColorTranslator.FromHtml("#CC0000");
            yAxisPlotBandDanger2.Alpha = 190;
            PlotBand yAxisPlotBandWarning = new PlotBand();
            yAxisPlotBandWarning.Color = System.Drawing.Color.Yellow;
            yAxisPlotBandWarning.Alpha = 190;
            PlotBand yAxisPlotBandWarning2 = new PlotBand();
            yAxisPlotBandWarning2.Color = System.Drawing.Color.Yellow;
            yAxisPlotBandWarning2.Alpha = 190;
PowerChart.ChartTitle.Text = "Batttery Capacity in the last month";
                PowerChart.PlotArea.XAxis.BaseUnit = Telerik.Web.UI.HtmlChart.DateTimeBaseUnit.Days;
                PowerChart.PlotArea.YAxis.Step = 10;
                PowerChart.PlotArea.YAxis.MinValue = 0;
                PowerChart.PlotArea.YAxis.MaxValue = 120;
                yAxisPlotBandDanger.From = 0;
                yAxisPlotBandDanger.To = 5;
                yAxisPlotBandWarning.From = 5;
                yAxisPlotBandWarning.To = 10;
                PowerChart.PlotArea.YAxis.TitleAppearance.Text = "Battery Capacity";
                PowerChart.PlotArea.YAxis.LabelsAppearance.DataFormatString = "{0}%";
                PowerChart.PlotArea.YAxis.PlotBands.Add(yAxisPlotBandDanger);
                PowerChart.PlotArea.YAxis.PlotBands.Add(yAxisPlotBandWarning);
                PowerChartLineSeries.DataFieldY = "BatteryCapacity";
                PowerChart.PlotArea.Series.Add(PowerChartLineSeries);
                HtmlChartHolder.Controls.Add(PowerChart);
                PowerChart.DataSource = GetDataTableToGraph(4, "BatteryCapacity");
                PowerChart.DataBind();
 
public DataTable GetDataTableToGraph(int option, string powerVariable)
        {
             
            DateTime olddate;           
            DataTable sourceTable = new DataTable();
            sourceTable.Columns.AddRange(new DataColumn[] {
                new DataColumn("DateandTime", typeof(DateTime)),
                new DataColumn("BatteryCapacity", typeof(int)),
                new DataColumn("BatteryChargeState", typeof(string)),
                new DataColumn("BatteryStatus", typeof(string)),
                new DataColumn("BatteryVoltage", typeof(double)),
                new DataColumn("Temperature", typeof(double)),
                new DataColumn("InputVoltage", typeof(double)),
                new DataColumn("InputFrequency", typeof(double)),
                new DataColumn("OutputCurrent", typeof(double)),               
                new DataColumn("OutputLoad", typeof(int)),
                new DataColumn("OutputSource", typeof(string)),
                new DataColumn("OutputVoltage", typeof(double)),
                new DataColumn("LRTLB", typeof(string))                           
                });
            try
            {
                string directory = ReadPowerDisplayRegistry("Dir") + "Service\\PWRDATA.csv";
                string[] fileContent = File.ReadAllLines(directory);
                for (int i = 2; i < fileContent.Count(); i++)
                {
                    string[] rowData = fileContent[i].Split(',');
                    sourceTable.Rows.Add(rowData);
                }
 
                string[] selectedColumns = new[] { "DateandTime", powerVariable };
                DataTable newDt = new DataView(sourceTable).ToTable(false, selectedColumns);
 
 
                if (option == 0)
                {
                    olddate = DateTime.Now.AddMinutes(-30);
                }
                else if (option == 1)
                {
                    olddate = DateTime.Now.AddMinutes(-60);
                }
                else if (option == 2)
                {
                    olddate = DateTime.Now.AddDays(-1);
                }
                else if (option == 3)
                {
                    olddate = DateTime.Now.AddDays(-7);
                }
                else
                {
                    olddate = DateTime.Now.AddMonths(-1);
                }
 
                newDt.DefaultView.RowFilter = String.Format(CultureInfo.InvariantCulture.DateTimeFormat,
                    "[DateandTime] >#{0}#", olddate);
                //newDt.DefaultView.RowFilter = string.Format
 
                return newDt;
            }
 
            catch
            {
                return null;
            }
             
        }

Marin Bratanov
Telerik team
 answered on 13 Jul 2018
1 answer
82 views
Can anyone point me in the direction of either documentation, a demo, or even an old forum post that details how to setup a RadGrid (that's operating in Batch edit) that uses the GridTextBoxColumnEditor control to use the RadSpell control for spell check?
Rumen
Telerik team
 answered on 13 Jul 2018
8 answers
281 views

I have a .NET 4.0 web application which implements an error handler within the Application_Error event of Global.asax.

When an exception occurs this intercepts it and sends me an email including a variety of information like the logged in user, the page the error occurred on, the contents of the session etc.

This is all great but there is some fundamental detail missing which I seem unable to locate, i.e. the name of the control or the value that caused it to be out of range:


Selection out of range
Parameter name: value

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.ArgumentOutOfRangeException: Selection out of range
Parameter name: value

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[ArgumentOutOfRangeException: Selection out of range
Parameter name: value]
   Telerik.Web.UI.RadComboBox.PerformDataBinding(IEnumerable dataSource) +172
   Telerik.Web.UI.RadComboBox.OnDataSourceViewSelectCallback(IEnumerable data) +491
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +33
   Telerik.Web.UI.RadComboBox.OnDataBinding(EventArgs e) +1256
   Telerik.Web.UI.RadComboBox.PerformSelect() +37
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +74
   Telerik.Web.UI.RadComboBox.DataBind() +70
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +66
   System.Web.UI.WebControls.BaseDataBoundControl.OnPreRender(EventArgs e) +22
   Telerik.Web.UI.RadDataBoundControl.OnPreRender(EventArgs e) +36
   Telerik.Web.UI.RadComboBox.OnPreRender(EventArgs e) +87
   System.Web.UI.Control.PreRenderRecursiveInternal() +103
   System.Web.UI.Control.PreRenderRecursiveInternal() +175
   System.Web.UI.Control.PreRenderRecursiveInternal() +175
   System.Web.UI.Control.PreRenderRecursiveInternal() +175
   System.Web.UI.Control.PreRenderRecursiveInternal() +175
   System.Web.UI.Control.PreRenderRecursiveInternal() +175
   System.Web.UI.Control.PreRenderRecursiveInternal() +175
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2496
Subash
Top achievements
Rank 1
 answered on 13 Jul 2018
6 answers
550 views

Hi Everyone,

I'm sure this is an obvious question but how do I set a default time when a user selects a date.

I have 2 RadDateTimePicker controls on a page where the user selects a daterange.
When the user selects a From date I want to automatically set the time portion of the returned date to 0:00 and when the user selects a To date I want to default the time to 23:59.

What am I missing, surely there is a default Time property somewhere that controls the time portion of the date returned from the Calendar.

Many thanks

Antony

Donald McLean
Top achievements
Rank 2
 answered on 12 Jul 2018
4 answers
248 views
Hi there,

We end up with an error "Error: 'JSON' is undefined" when accessing pages using telerik controls in IE8.
It is quite new when migrating to IE8 (after some security hotfix?) and the compatibility mode does not help...
Trying the last version of Telerik controls does not help neither...

Do someone face similar issue and can give us some hint there?

Regards,
David
Shirish
Top achievements
Rank 1
 answered on 12 Jul 2018
0 answers
92 views

I have a Radgrid using automatic Update, and a custom Edit Form template. I need to pass all the values of an edited row so I can populate an email that will be sent to users from the code-behind. Using the code below that I have cobbled together from various posts, I can get all the row's current values, but not the updated values using the ItemUpdated event. Is there another event I can use, or different code to obtain Updated values for that row after my Edit Form is closed and database updated? I am new to this, so code examples are helpful. Thanks!

C#

public void RadGrid1_ItemUpdated(object sender, GridUpdatedEventArgs e)
        {
            GridEditFormItem item = (GridEditFormItem)e.Item;
            GridDataItem parentItem = (GridDataItem)item.ParentItem;
            string emailFlag = parentItem["EmailToSalesFlag"].Text;
            {
                if (emailFlag == "true");
                string SU = parentItem["StockUnit"].Text;
                string Make = parentItem["Make"].Text;
                string Model = parentItem["Model"].Text;
                string Description = parentItem["Description"].Text;
                string Type = parentItem["Type"].Text;
                string CustName = parentItem["CustName"].Text;
                string Salesperson = parentItem["Salesperson"].Text;
                string RecDate = parentItem["Rec_Date"].Text;
                string InvDate = parentItem["Inv_Date"].Text;
                string SpiffProg = parentItem["SpiffProg"].Text;
                string SpiffAmt = parentItem["SpiffAmt"].Text;
                string Notes = parentItem["Notes"].Text;
                string Approved = parentItem["Approved"].Text;
                string MgrNotes = parentItem["MgrNotes"].Text;
                string Email = parentItem["Email"].Text;
                //Populate HTML email Body               
                PopulateBody(SU, Make, Model, Description, Type, CustName, Salesperson, RecDate, InvDate, SpiffProg, SpiffAmt, Notes, Approved, MgrNotes, Email);
            }
        }

Andy
Top achievements
Rank 1
 asked on 12 Jul 2018
1 answer
121 views

Hello!

 

I have a weird problem with my radgrid. In one of my columns (GridBoundColumn), I can't insert the exclamation mark.

It seems like the combination (Shift + 1) is somehow blocked. I can't find anything related to this.

Every other keyboard combination is working. The only way I can add the exclamation mark is by copy paste. 

Has anyone encountered this before ? Any help is appreciated!

 

Thank you!

Tsvetomir
Telerik team
 answered on 12 Jul 2018
4 answers
147 views
hi,

I use RadGrid to manipulate row promotion level. I Enabled the user to drag and drop rows to set the drraged item position.

I need to manipulate my datasbase when the dragging finish.

I wish to do this with javascript that invoke WCF service and pass the relevant parameters.

the problem is when the row dropped,  the page Posback to server and the user need to wait until the updating  to DB will finish.

I only need help to disable this postBack.

(When I use set_cancel method in the droppedEvent Nothing Changed and if I use it in the Drraging event the Dropped Event no Fired at all).

Thanks.
sorry about my English.. :)

shimon
Flavien
Top achievements
Rank 1
Iron
 answered on 12 Jul 2018
6 answers
236 views
I want to put a button on the page that uses the ConfirmBtn-Grey.jpg image when the page loads, and then when the button is clicked it should display ConfirmBtn-Selected.jpg.

I'm using the following RadButton definition, but not getting any images displayed on my page...

<telerik:RadButton ID="RadButton1" runat="server" ButtonType="ToggleButton" ToggleType="CustomToggle">
    <ToggleStates>
        <telerik:RadButtonToggleState Selected="true" ImageUrl="../images/ConfirmBtn-Grey.jpg" />
        <telerik:RadButtonToggleState ImageUrl="../images/ConfirmBtn-Selected.jpg" />
    </ToggleStates>
</telerik:RadButton>

I've checked the paths to my images using Firebug and it's picking them up ok. Have I defined the button incorrectly?

Rob
Marin Bratanov
Telerik team
 answered on 12 Jul 2018
Narrow your results
Selected tags
Tags
+? more
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?