如何使用StoredProcedure绑定WebGrid ..？ [英] How to bind WebGrid using StoredProcedure..?

问题描述

型号：

Model:

public class Registration
    {
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public string Email { get; set; }
        public string Gender { get; set; }
        public string Address { get; set; }
        public string City { get; set; }
        public string State { get; set; }
        public string Country { get; set; }
        public Int64 PhoneNumber { get; set; }
        public string Password { get; set; }
    }

DataAccessLayer：

DataAccessLayer:

public DataSet Registration_Select(Registration objRegistration)
{
   return SQL.ExecuteDataset(sqlconn,CommandType.StoredProcedure,
"TR_Registration_Select");
}

BaseAccessLayer:
<pre lang="c#">public DataSet Registration_Select(Registration objRegistration)
{
    return objDL_Registration.Registration_Select(objRegistration);
}

控制器：

Controller:

public class GridController : Controller
{
    Registration list = new Registration();
    BL_Registration obj = new BL_Registration();
    public ActionResult Grid()
    {
       List<registration> list = GetRegistration();
       return View(list.AsEnumerable());    
    }

    public List<registration> GetRegistration()
    {
       DataSet ds = obj.Registration_Select(list);
       if (ds.Tables.Count > 0)
         {
            return Grid = ds.Tables[0];
         }
    }
}

查看：

View:

@model IEnumerable<mvc_application.models.registration>
-
-
-
-
    <div>
       @using (Html.BeginForm("Grid", "Grid"))
       {
          <div id="DivGird">
          @{
             WebGrid Grid = new WebGrid(source: Model);
             Grid.Bind(Model);
             @Grid.GetHtml(
             tableStyle: "webgrid-table",
             headerStyle: "webgrid-header",
             footerStyle: "webgrid-footer",
             alternatingRowStyle: "webgrid-alternating-row",
             rowStyle: "webgrid-row-style",
             columns: Grid.Columns(
                Grid.Column(columnName: "FirstName", header: "First Name"),
                Grid.Column(columnName: "LastName", header: "Last Name"),
                Grid.Column(columnName: "Email", header: "Email"),
                Grid.Column(columnName: "Gender", header: "Gender"),
                Grid.Column(columnName: "Address", header: "Address"),
                Grid.Column(columnName: "City", header: "City"),
                Grid.Column(columnName: "States", header: "State"),
                Grid.Column(columnName: "Country", header: "Country"),
                Grid.Column(columnName: "PhoneNumber", header: "Phone Number")
             ));
          }
          </div>
       }
    </div>

请帮助我.. 。

Please Help Me...

推荐答案

详情请参阅链接：



http://www.aspdotnet-pools.com/2014/07/how -to-bind-data-to-webgrid-in-aspnet.html [ ^ ]

Refer the link for details:

http://www.aspdotnet-pools.com/2014/07/how-to-bind-data-to-webgrid-in-aspnet.html[^]

这篇关于如何使用StoredProcedure绑定WebGrid ..？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！