Creating a generic table in view from an action (button)

See more:

MVC4

I am relatively new to MVC and its kicking my butt!

I have a view that has an empty dataTable on it. There are a few drop downs that determine the actions that will occur.

Drop down 1 - Selects from a list of databases
Drop down 2 - Populated via JSON with the tables in the db selected (From Drop down 1)
then a button. OnClick it fires and grabs all the data from the database.

Originally it was a single table, so i was able to use a model and a partial view. But now that I have possibly thousands of table schemas to consider, I have no clue how to set it up. I grabbed the data from the database and pushed it to a public data table in my controller. From there i tried getting it to display to the view, but the only thought i had was push it to the viewbag. But doing so never calls anything when it returns back to the view.

please assist if you can.

Thanks in advance
Samantha