在Razor中有效显示查询结果(Display query results efficiently in Razor)

 我用Visual C＃和“Razor”选项创建了一个ASP.NET MVC 4 Web应用程序 
 
 HomeController.cs 
 
    public ActionResult Tasks()
    {
        ViewBag.Message = "Tasks";

        string selectSql = "select * from Tasks";

        string connectionString = @"Data Source=lpc193\adamssqlserver;Database=master;Integrated Security=True;";

        DateTime strt;

        using (var cn = new SqlConnection(connectionString))
        using (var cmd = new SqlCommand(selectSql, cn))
        {
            cn.Open();

            using (var reader = cmd.ExecuteReader())
            {
                if (reader.Read())
                {
                    strt = reader.GetDateTime(reader.GetOrdinal("Start"));
                }
            }
        }

        return View();
    }
 
 Tasks.cshtml 
 
@{ 
    ViewBag.Title = "Tasks To Complete"; 
}

These are the tasks from the table

<!-- some datagrid object here ?? -->
 
 我有以下SQL Server 2012数据库表布局 
 
 
 我能够很好地查询表格并单独提取每个字段的值。 
 
 我想要做的是将DataGridView中的结果集（包含select *查询中的所有字段）显示给用户。 我可以很容易地将每个值放入一个TR TD并将其放入一个字符串中，将它显示在.cshtml一侧......但那并没有真正教会我什么，我怀疑它非常有效。 
 
 注意事项找到有关Razor的相关信息并显示查询数据非常困难。 是因为它是新的，和/或是Razor要避免的C＃新手？ 

I've created an ASP.NET MVC 4 Web Application with Visual C# and with the "Razor" option
 
HomeController.cs
 
    public ActionResult Tasks()
    {
        ViewBag.Message = "Tasks";

        string selectSql = "select * from Tasks";

        string connectionString = @"Data Source=lpc193\adamssqlserver;Database=master;Integrated Security=True;";

        DateTime strt;

        using (var cn = new SqlConnection(connectionString))
        using (var cmd = new SqlCommand(selectSql, cn))
        {
            cn.Open();

            using (var reader = cmd.ExecuteReader())
            {
                if (reader.Read())
                {
                    strt = reader.GetDateTime(reader.GetOrdinal("Start"));
                }
            }
        }

        return View();
    }
 
Tasks.cshtml
 
@{ 
    ViewBag.Title = "Tasks To Complete"; 
}

These are the tasks from the table

<!-- some datagrid object here ?? -->
 
I have the following SQL Server 2012 database table layout
 
 
I'm able to query the table just fine and pull out each field's value individually.
 
What I want to do is display the result set (with all fields from the select * query) in a DataGridView of sorts to the user. I could easily place each value into a TR TD and plop that into a string, display it on the .cshtml side... but thats doesn't really teach me anything, and I doubt its very efficient.
 
side note It's extremely difficult to find relevant information regarding Razor and displaying data from a query. Is it because its new, and/or is Razor something to avoid for a C# novice?

原文：https://stackoverflow.com/questions/16593359