x axis values mixed strings and ints

[debett]

Hi all,

I have found out that when my data for x axis has mixed string and int values (even though they come in as "strings'" from the DB), I get an exception "Input string was not in a correct format." Looking at the call stack I see that it fails converting ToDouble.

Do you know any workarounds?

Note, this is a generic/dynamic solution, so I don't know what kind of data comes in. I allow users to select fields on the fly which they want to display on the chart. Then, I have code to populate the grid:

qbChart.Series.Clear();
this.qbChart.DataGroupColumn = this.ddlGroup.SelectedValue;
this.qbChart.PlotArea.XAxis.DataLabelsColumn = this.ddlX.SelectedValue;
sdsResults.ConnectionString = cm.css.ConnectionString;
sdsResults.SelectCommand = SQLString;             
this.qbChart.DataBind();

I would like to stick with sql datasource. IAlso, I do not have an option to convert values to int in DB.

Thank you.

[Giuseppe]

Hello debett,

Could you elaborate a bit more on your specific scenario? We tried to reproduce the problem based on your guidelines but our efforts were unsuccessful so far -- could you review the attached sample application and let us know whether we are missing some key component that would trigger the erroneous behavior?

Looking forward to your reply.


Regards,
Giuseppe
the Telerik team

[debett]

Giuseppe,

I have changed the data in your example and it fails:) I cannot attach here the complete project, but I'll list 2 files:

Code:

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.RadChart1.Series.Clear();
        this.RadChart1.DataGroupColumn = "Item2";
        this.RadChart1.PlotArea.XAxis.DataLabelsColumn = "Item1";
        this.RadChart1.DataSource = this.Data;
        this.RadChart1.DataManager.ValuesYColumns = new string[] { "Item3" };
        this.RadChart1.DataBind();

    }
}


public List<Tuple<string,string, string >> Data
{
    get
    {
        return new List<Tuple<string, string, string>>()
                   {new Tuple<string, string, string>(null, null, "1"),
                       new Tuple<string, string, string>(null, "F", "26"),
                       new Tuple<string, string, string>(null, "M", "48"),

                       new Tuple<string, string, string>("01", "F", "27"),
                       new Tuple<string, string, string>("01", "M", "21"),
                       new Tuple<string, string, string>("02", "F", "19"),
                       new Tuple<string, string, string>("02", "M", "23"),

                       new Tuple<string, string, string>("K", "F", "35"),
                       new Tuple<string, string, string>("K", "M", "29"),
                   };
    }
}

Behind:

<telerik:RadChart ID="RadChart1" runat="server">
        </telerik:RadChart>

Please, let me know if you need more info.


Thank you.

[Yavor]

Hello debett,

Our system indicates, that you have opened an identical ticket on the same issue. To avoid duplicate posts, we can continue our communication in the support ticket in question, which will be addressed shortly.

Kind regards,
Yavor
the Telerik team

[Boris]

HI,
I have the same problem i need to set to x-axis mixed types (int and string) and i get an error :
"Input string was not in a correct format"
Did find solution for debett and mine problem?

[Yavor]

Hello Boris,

Are you applying any format strings to the values? Also, are all the values along the xAxis properly populated? Any additional information on your precise setup will help us better address the question set forth.

All the best,
Yavor
the Telerik team

[Boris]

Hello Yavor,
I'm not applying any format strings to the values.
And all the values populated.
I use x axis to show user info, an ID of the user (304411111 - int or string)  or a name of the user (Boris - string).
Depending on user role he can see for some users their name and for other only their ID .
If I set only the ID to all users or only names this works fine, but when I mixed and show some users an ID and some Names
It give me an error "Input string was not in a correct format"

Thank's!

[Yavor]

Hi Boris,

Based on the supplied information, it is hard to determine what is causing the exception.
If the problem persists, it will be best if you open a formal support ticket, and send us a small working project, demonstrating your setup, and showing the unwanted exception, for additional review and testing.

Best wishes,
Yavor
the Telerik team