Click here to Skip to main content
15,907,326 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Model:
C#
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:
C#
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:
C#
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:
C#
@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...
Posted
Updated 6-Oct-14 22:13pm
v3

1 solution

 
Share this answer
 
Comments
Member 11066311 7-Oct-14 5:00am    
sir, i want to bind from DataSet using StoredProcedure not with entity model...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900