When I select one table from the dropdownlist want to display the total data of the table

See more:

MVC3

MVC4

SQL-Server-2014

I am binding the all database tables to the dropdownlist.when i select one table from the dropdownlist want to display the total data of the table.

i am already bind the database tables to the dropdownlist how to get the table data from
dropdown selection table

What I have tried:

using (var Mydb=new MCPEntities())
         {
             FieldInfo[] mytables = Mydb.GetType().GetFields(BindingFlags.Public |BindingFlags.NonPublic |BindingFlags.Instance);
             //List<string> results = Mydb.ExecuteStoreQuery<string>("SELECT name FROM sys.tables ORDER BY name").ToList();


             List<string> tbllistname = new List<string>();
             foreach (var item in mytables)
             {
                 tbllistname.Add(item.Name.Split('<', '>')[1]);
             }
             ViewBag.MyTables = tbllistname;


         }
         return View();
     }