using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Configuration;
using System.Windows;
using System.Data;
using System.Data.SqlClient;

namespace mvc4prj.Controllers
{
    public class HomeController : Controller
    {
        public DataTable dt;

        public string StrConnWork = "Data Source=(localdb)\\v11.0;Initial Catalog=Test;Integrated Security=true; User ID=sa; Password=";

        private void BindData(string sViewSource)
        {

            using (SqlConnection Cnn = new SqlConnection(StrConnWork))
            {
                    SqlCommand command = new SqlCommand("select * from " + sViewSource, Cnn);
                    SqlDataAdapter adapter = new SqlDataAdapter();
                    Cnn.Open();
                    DataSet dtSet = new DataSet();
                    adapter.SelectCommand = command;
                    adapter.Fill(dtSet, sViewSource);
                    DataTable dt = dtSet.Tables[sViewSource];

            }
        }
        
        

        public ActionResult Index()
        {
            BindData("t1"); 

            // t1 - таблица в базе
            
            return View(dt);
        }

    }

}

@model System.Data.DataTable 
@using System.Data; 


@{
    ViewBag.Title = "Index";
}

<h2>Index</h2>
<div>
<table> 
    <thead> 
    <tr> 
    @foreach (DataColumn col in Model.Columns)   //на этой строке заедает  
    {          
        <th>@col.ColumnName</th> 
    }     
    </tr> 
    </thead>         
    <tbody> 
    @foreach (DataRow row in Model.Rows)     
    {         
        <tr> 
        @foreach (DataColumn col in Model.Columns)         
        {              
            <td>@row[col.ColumnName]</td> 
        }         
        </tr> 
    }     
    </tbody> 
</table>

</div>