Click here to Skip to main content
11,565,623 members (39,816 online)
Rate this: bad
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";
<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");
Posted 4-May-14 8:13am

1 solution

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

Solution 1

Check out the following links:

Grid view in MVC

Data in MVC

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

  Print Answers RSS

Advertise | Privacy | Mobile
Web03 | 2.8.150624.2 | Last Updated 8 May 2014
Copyright © CodeProject, 1999-2015
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