Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET MVC
How Can I bind my Gridview with the DB ?
Here I fix The Values but i want to connect the grid to the DB Smile | :)
 
.cs Code ( the Controller )
 
using ReceiptMvc.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
 
namespace ReceiptMvc.Controllers
{
    public class ShowGridController : Controller
    {
        //
        // GET: /ShowGrid/
        ReceiptDBEntities db = new ReceiptDBEntities();
 
        public ActionResult Index()
        {
            return View(ReceiptItems);
        }
 
        private readonly List<ReceiptItem> ReceiptItems = new List<ReceiptItem>()
    {
 
        new ReceiptItem { ReceiptItemId =9,ReceiptId=5, Price=50 ,Item ="gg",Quantity=20 }
        
 

    };
    }
}
 
.cshtml code ( The View )
 
@model IEnumerable<ReceiptMvc.Models.ReceiptItem>
@using GridMvc.Html
 
@{
    ViewBag.Title = "Index";
}
 
<h2>Index</h2>
<div style="width:500px;">
    @Html.Grid(Model).Columns(columns =>
                    {
                        columns.Add(c => c.ReceiptId).Titled("ReceiptId").Filterable(true);
                        columns.Add(c => c.ReceiptItemId).Titled("ReceptItemId");
                        columns.Add(c => c.Item).Titled("Item");
                        columns.Add(c => c.Quantity).Titled("Quantity");
                        columns.Add(c => c.Price).Titled("Price");
                    }).WithPaging(3).Sortable(true)
</div>
Posted 4-May-14 9:13am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Check out the following links:
 
Grid view in MVC
 
Data in MVC
  Permalink  

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



Advertise | Privacy | Mobile
Web03 | 2.8.1411022.1 | Last Updated 8 May 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100