Jump to content
Software FX Community

How to bind two tables to one chart alternatively


Guest Tingjun Fan
 Share

Recommended Posts

Guest Tingjun Fan

I have two datatables, say tb1 and tb2. tb1 contains four columns: month, expense, revenue, net. tb2 contains two columns: month, wine sales.

 

I need to display the chart for tb1 and tb2 alternatively.

 

I use the following statement to bind the data to the chart tFXChart:

 

tFXChart.DataSourceSettings.FillFromSchema();

tFXChart.DataSource = tb1;

 

No problem there.

 

But later on when I tried to do the same thing by replacing tb1 with tb2, the chart shows errors.

 

If I tried to add code like the following before the lines, I got different types of errors or tb2 just fails to show (saying no data).

 

tFXChart.Series.Clear();

tFXChart.DataSourceSettings.DataFields.Clear();

 

Can someone tell me what I'm missing? Thanks in advance for your help.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...