Using scalar query as data source for winform chart

Question

0.00/5 (No votes)

See more:

In my winforms app i have created a dataset from Trial.Accdb database & in it i have added a Scalarquery() which return count of 1 particular column , now i want to use this query as data-source to show as a chart in my winform .Please help me how to achieve this
.

as i can't post images here i have asked same question in stack-overflow so that i can link it here for you.

c# - Using scalar query as data source for winform chart - Stack Overflow[^]

What I have tried:

and here is form load event code

private void FrmDashBoard_Load(object sender, EventArgs e)
        {
            
            this.mSdiesTableAdapter1.Fill(this.trialDataSet2.MSdies.);
            


            this.reportViewer1.RefreshReport();
        }

Posted 5-Aug-20 19:43pm

Member 14898617

Add a Solution

Comments

[no name] 6-Aug-20 1:58am

A data point needs at least 2 values; a series needs multiple data points.

Member 14898617 6-Aug-20 2:05am

I didn't get you(could you please explain further?) , the columns "Size in mg" in the query can be used as series right? then for y axis i can use total column , my question is how to make this scalar query as data source to my chart .

[no name] 6-Aug-20 10:55am

And for the "x" value? Even then, a single point is meaningless in relation to nothing else.

Member 14898617 6-Aug-20 23:37pm

Thank you very much for your reply , but X value is not a single pint here
this is the scalar query output:
Size_in_mg(X axis)--------- Count(of Size_in_mg)(Y-axis)
100-300mg --------- 3
200-400mg --------- 2
300-500mg --------- 1

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)