C# Create a temporary table

Greetings,

I am creating a brief application that is filling three seperate tables in a SQL server database.  Here is an example

Table 1
----------------------
ID    Name              VotesReceived              %OfVote         %Change
1     Bob                    100                                   51.0               0
2     Bob                     110                                   51.2                .2
3     Bob                     125                                  50.4                -.8

Table 2
-----------------
ID    Name              VotesReceived              %OfVote         %Change
1     Carol                  90                                      49.0               0
2     Carol                  95                                      49.1                .1
3     Carol                   115                                    49.8                .7

Table 3
----------------
ID       TimeReported         VoteTotal                TotalChange
1               11:00AM            190                                0
2                11:05AM            205                                15
3                11:10 AM             240                              35

I need to display the data in all three of these tables in a dataset that I would be able to scroll through using the ID field.  

What would be the best way to go about getting this information.  Should I re-adjust the application and place all the data into one table instead of three separate tables, or would it be more feasible to create a temporary table that would populate the data when the class is called?

Thanks for the help, data-driven applications are new to me in C# (heck C# is new to me)