Need help connecting SQL stored procedure to UltraChart

Stephen Maye posted over 15 years ago

I am admittedly new to this, but after much reading I am stumped how to get the data from my stored procedure to appear on a scatter chart within UltraChart.

Here is what I am doing. Just sample data I made up. THE REAL DATA WILL COME FROM A STORED PROCEDURE. If that makes a difference

Here is where I have created a sql datasource in Visual Studio and select the table above

Next I set the UltraChart datasource to be the Sql datasource above

Now it this point when i ran it it crashed. Here is the message

Then I went in to the Chart Wizard and added a chart area and two axes. Here I set the X-axis

Then set Y

And then at least when I ran it it did not crash, but no data was shown. See below.

How do i connect my X data with the X-axis and Y-data with the Y-axis? Can I do it in the wizard or do I have to do it in the code?

Please also keep in mind this is all just test data trying to get anything to work. The actual data will be coming from a stored procedure whose output looks like this

TIA for your help.

Parents

No Data

Reply

26458

Offline Max Rivlin [Infragistics] posted over 15 years ago

You can stick with your original approach of assigning the sql datasource directly to the chart.
You just have to set two additional properties for it to work:
chart.ScatterChart.ColumnX = 0
chart.ScatterChart.ColumnY = 1

By default the chart will look for numeric data in columns 1 and 2, but yours is in columns 0 and 1. This should fix the error.
Cancel
Reply

Cancel

Children

90

Offline Stephen Maye posted over 15 years ago in reply to Max Rivlin [Infragistics]
Hey Max,

Thanks very much for the reply. Since I posted this I kept at it reading all over your site here. I managed to make it run, but would appreciate running what I found past you for confirmation.

In my case I was trying the most simple thing possible to create a scatter; I created a SQL table with 3 columns labels, X, and Y. I plopped a single UltraWebChart on the page all alone. I set the datasource to the SQL table and set the chart type to scatter. I wanted to see if I could make the chart work without adding any code at all.

After much trial and error here is what I found

Although I read that a the labels column set as a text field was optional the chart would not run unless it was there. Even if I was not using them at all the column needed to be there.

The labels column needed to be the first column on the left or it would not run

The X and Y data columns needed to be set as numeric

If the column names were ColumnX and ColumnY the chart correctly interpreted which was which and it charted the data correctly

If these two data columns were named anything else it charted the first one as X and the second as Y. But it DID run fine.

I then created a stored procedure whose output was formatted just like the table and everything worked fine.

It seems to agree with your reply above. Does all that sound correct?

Now I am actually moving on to the ultimate goal of a scatterline diagram. So far I know I need to do a composite chart and have been successful at recreating the wizard example located here http://help.infragistics.com/Help/NetAdvantage/NET/2008.2/CLR2.0/html/Chart_Creating_a_Composite_Chart.html

I want to take the output of a single stored procedure to do a scatter plot using the first two numric columns and then use subsequent columns to plot the upper and lower control limits. By now I am thinking I can just goto the chart and select that stored procedure as the datasource, but I am going to have to use code to tell the chart what columns to use for the UCL and LCL lines.

Am I on the right track? Any pointers you might have to help? I am about as green with this stuff as someone can be. I am very happy to take any help offered :)
Cancel
Reply

Cancel