Can you group on a graph using different dataSets?

Hi Experts, I have an unusual problem where I need to create a line graph comparing different dates of data. Problem is that each date is retrieved using a different dataset.  The reason for this is that the "where" clause I use goes via a special odbc diver to the database. So I can only use one date retrieval per dataset.  
At the moment I am using the first dataset to retrieve the first data points. I then use the second, third etc data points using the lookup feature.
This works fine for plotting each DataSet information as a line graph Horizontally E.g. The line represents 1 DataSet of information.  However what I want to do is have each dataSet grouped long the X axis, so one line on the graph would represent many dataset data points.
I hope that makes sense. Firstly do you think this is possible and secondly how would I do this. Please let me know if I need to explain further.
bruskhickoryAsked:
Who is Participating?
 
vastoConnect With a Mentor Commented:
If you already have the data retrieved the easiest way to process it will be to merge the tables. (I guess you have the same structure). Check DataTable.Merge Method:
http://msdn.microsoft.com/en-us/library/wkk7s5zk.aspx
0
 
rajeevnandanmishraCommented:
Hi,
How you are creating the datasets? I mean isn't it possible to create a single dataset in a procedure (using union or temp tables) by querying multiple times?
In that way you will get a single output dataset that further can be represented in the graph.

You can use opendatasource/ openrowset methods of mssql also to fetch dataset using odbc drivers OPENDATASOURCE
0
 
bruskhickoryAuthor Commented:
Great just information what I was looking for. I would have used 'union' to join different tables but I am unable to use this in the sql script do the odbc driver I am using.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.