如何在Asp.Net Mvc中使用Webgrid On View显示数据集数据？ [英] How I Can Show Dataset Data Using Webgrid On View In Asp.Net Mvc?

问题描述

我想将数据集传递给View，然后我想将数据集表[0]分配给webgrid数据集。是否有可能在asp.net mvc中像webforms一样。

表示我想使用webgrid显示数据表数据，并希望分配web.grid数据源，如asp.net webforms。

i want to pass dataset to View and then i want to assign the dataset table[0] to webgrid datasourse . is it possible in asp.net mvc like webforms .
means i want to show datatable data using webgrid and want to assign webgrid datasource like asp.net webforms.

推荐答案

在ASP.NET中，MVC数据作为Model从控制器传递到视图。如果要在web网格中显示数据表，则需要使用如下所示的模型类

<控制器中的
：

IN ASP.NET MVC data is passed from controller to view as Model.If you want to show datatable in web grid you need to use a model class as shown below

In Controller:

public ActionResult Contact()
        {
            ViewBag.Message = "Your contact page.";
            DataTable table = new DataTable();
            table.Columns.Add("Dosage", typeof(int));
            table.Columns.Add("Drug", typeof(string));
            table.Columns.Add("Patient", typeof(string));
            table.Columns.Add("Date", typeof(DateTime));

            // Here we add five DataRows.
            table.Rows.Add(25, "Indocin", "David", DateTime.Now);
            table.Rows.Add(50, "Enebrel", "Sam", DateTime.Now);
            table.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Now);
            table.Rows.Add(21, "Combivent", "Janet", DateTime.Now);
            table.Rows.Add(100, "Dilantin", "Melanie", DateTime.Now);

            DataSet ds = new DataSet();
            ds.Tables.Add(table);
            
            //

            var plist = ds.Tables[0].AsEnumerable().Select(x => new ModelClass
            {
                Dosage = x.Field<int>("Dosage"),
                Drug = x.Field<string>("Drug"),
                Patient = x.Field<string>("Patient"),
                Date = x.Field<DateTime>("Date")
            });



            return View(plist);
        }

查看





@model IEnumerable< test1.Models.ModelClass>

@ {

ViewBag.Title =联系人;



}

< h2> @ ViewBag.Title。< / h2>

< h3> @ ViewBag.Message< / h3> < br $>


@ {

var grid = new WebGrid（Model，canPage：true，canSort：true，rowsPerPage：2）;

grid.Pager（WebGridPagerModes.NextPrevious）;



}

< div>

@ grid.GetHtml（）;

< / div>





和模型类：< br $> b $ b

In View


@model IEnumerable<test1.Models.ModelClass>
@{
ViewBag.Title = "Contact";

}
<h2>@ViewBag.Title.</h2>
<h3>@ViewBag.Message</h3>

@{
var grid = new WebGrid(Model, canPage: true, canSort: true, rowsPerPage: 2);
grid.Pager(WebGridPagerModes.NextPrevious);

}
<div>
@grid.GetHtml();
</div>


And The Model Class:

public class ModelClass
  {
      public int Dosage { get; set; }
      public string Drug { get; set; }
      public string Patient { get; set; }
      public DateTime Date { get; set; }
  }

这篇关于如何在Asp.Net Mvc中使用Webgrid On View显示数据集数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！