Click here to Skip to main content
11,642,855 members (71,070 online)
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 8: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)

  Print Answers RSS
0 DamithSL 328
1 OriginalGriff 280
2 Sergey Alexandrovich Kryukov 270
3 Afzaal Ahmad Zeeshan 195
4 jyo.net 190
0 DamithSL 541
1 OriginalGriff 495
2 Mika Wendelius 469
3 Sergey Alexandrovich Kryukov 330
4 Afzaal Ahmad Zeeshan 324


Advertise | Privacy | Mobile
Web01 | 2.8.150731.1 | 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