DataGrid View with "CRUD operations" using Dojo DataGrid, JsonRest Store, Entity Framework, SQL Server, ASP.NET MVC Web API

Nikfazan

Rate me:

4.86/5 (6 votes)

7 Jul 2013CPOL4 min read

70.5K

3.8K

DataGrid View with "CRUD operations" using Dojo DataGrid, JsonRest Store, Entity Framework, SQL Server, ASP.NET MVC Web API

DojoDataGrid-Demo.zip
- DojoDataGrid-Demo
  - DojoDataGrid.sln
  - DojoDataGrid.suo
  - DojoDataGrid
    - App_Data
      - Database1.mdf
      - Database1_log.LDF
    - App_Start
    - bin
      - Antlr3.Runtime.dll
      - EntityFramework.dll
      - Newtonsoft.Json.dll
      - System.Web.Optimization.dll
      - System.Web.Providers.dll
      - WebGrease.dll
    - Content
      - Site.css
      - themes
        
        base
        
        images
        
        ui-bg_flat_0_aaaaaa_40x100.png
        
        ui-bg_flat_75_ffffff_40x100.png
        
        ui-bg_glass_55_fbf9ee_1x400.png
        
        ui-bg_glass_65_ffffff_1x400.png
        
        ui-bg_glass_75_dadada_1x400.png
        
        ui-bg_glass_75_e6e6e6_1x400.png
        
        ui-bg_glass_95_fef1ec_1x400.png
        
        ui-bg_highlight-soft_75_cccccc_1x100.png
        
        ui-icons_222222_256x240.png
        
        ui-icons_2e83ff_256x240.png
        
        ui-icons_454545_256x240.png
        
        ui-icons_888888_256x240.png
        
        ui-icons_cd0a0a_256x240.png
        
        jquery.ui.accordion.css
        
        jquery.ui.all.css
        
        jquery.ui.autocomplete.css
        
        jquery.ui.base.css
        
        jquery.ui.button.css
        
        jquery.ui.core.css
        
        jquery.ui.datepicker.css
        
        jquery.ui.dialog.css
        
        jquery.ui.progressbar.css
        
        jquery.ui.resizable.css
        
        jquery.ui.selectable.css
        
        jquery.ui.slider.css
        
        jquery.ui.tabs.css
        
        jquery.ui.theme.css
        
        jquery-ui.css
        
        minified
        
        images
        
        ui-bg_flat_0_aaaaaa_40x100.png
        
        ui-bg_flat_75_ffffff_40x100.png
        
        ui-bg_glass_55_fbf9ee_1x400.png
        
        ui-bg_glass_65_ffffff_1x400.png
        
        ui-bg_glass_75_dadada_1x400.png
        
        ui-bg_glass_75_e6e6e6_1x400.png
        
        ui-bg_glass_95_fef1ec_1x400.png
        
        ui-bg_highlight-soft_75_cccccc_1x100.png
        
        ui-icons_222222_256x240.png
        
        ui-icons_2e83ff_256x240.png
        
        ui-icons_454545_256x240.png
        
        ui-icons_888888_256x240.png
        
        ui-icons_cd0a0a_256x240.png
        
        jquery.ui.accordion.min.css
        
        jquery.ui.autocomplete.min.css
        
        jquery.ui.button.min.css
        
        jquery.ui.core.min.css
        
        jquery.ui.datepicker.min.css
        
        jquery.ui.dialog.min.css
        
        jquery.ui.progressbar.min.css
        
        jquery.ui.resizable.min.css
        
        jquery.ui.selectable.min.css
        
        jquery.ui.slider.min.css
        
        jquery.ui.tabs.min.css
        
        jquery.ui.theme.min.css
        
        jquery-ui.min.css
    - Controllers
    - DojoDataGrid.csproj
    - DojoDataGrid.csproj.user
    - favicon.ico
    - Global.asax
    - Global.asax.cs
    - Images
      - accent.png
      - bullet.png
      - heroAccent.png
      - orderedList0.png
      - orderedList1.png
      - orderedList2.png
      - orderedList3.png
      - orderedList4.png
      - orderedList5.png
      - orderedList6.png
      - orderedList7.png
      - orderedList8.png
      - orderedList9.png
    - Models
      - Blog.cs
      - BloggingModel.Context.cs
      - BloggingModel.Context.tt
      - BloggingModel.cs
      - BloggingModel.Designer.cs
      - BloggingModel.edmx
      - BloggingModel.tt
    - packages.config
    - Properties
      - AssemblyInfo.cs
    - Scripts
    - Views
      - _ViewStart.cshtml
      - Home
        
        Index.cshtml
      - Shared
        
        _Layout.cshtml
        
        Error.cshtml
      - Web.config
    - Web.config
    - Web.Debug.config
    - Web.Release.config
  - Readme.txt
DojoDataGrid-Demo-noexe.zip
- DojoDataGrid.sln
- DojoDataGrid.suo
- Database1.mdf
- Database1_log.LDF
- BundleConfig.cs
- FilterConfig.cs
- RouteConfig.cs
- WebApiConfig.cs
- Site.css
- ui-bg_flat_0_aaaaaa_40x100.png
- ui-bg_flat_75_ffffff_40x100.png
- ui-bg_glass_55_fbf9ee_1x400.png
- ui-bg_glass_65_ffffff_1x400.png
- ui-bg_glass_75_dadada_1x400.png
- ui-bg_glass_75_e6e6e6_1x400.png
- ui-bg_glass_95_fef1ec_1x400.png
- ui-bg_highlight-soft_75_cccccc_1x100.png
- ui-icons_222222_256x240.png
- ui-icons_2e83ff_256x240.png
- ui-icons_454545_256x240.png
- ui-icons_888888_256x240.png
- ui-icons_cd0a0a_256x240.png
- jquery.ui.accordion.css
- jquery.ui.all.css
- jquery.ui.autocomplete.css
- jquery.ui.base.css
- jquery.ui.button.css
- jquery.ui.core.css
- jquery.ui.datepicker.css
- jquery.ui.dialog.css
- jquery.ui.progressbar.css
- jquery.ui.resizable.css
- jquery.ui.selectable.css
- jquery.ui.slider.css
- jquery.ui.tabs.css
- jquery.ui.theme.css
- jquery-ui.css
- ui-bg_flat_0_aaaaaa_40x100.png
- ui-bg_flat_75_ffffff_40x100.png
- ui-bg_glass_55_fbf9ee_1x400.png
- ui-bg_glass_65_ffffff_1x400.png
- ui-bg_glass_75_dadada_1x400.png
- ui-bg_glass_75_e6e6e6_1x400.png
- ui-bg_glass_95_fef1ec_1x400.png
- ui-bg_highlight-soft_75_cccccc_1x100.png
- ui-icons_222222_256x240.png
- ui-icons_2e83ff_256x240.png
- ui-icons_454545_256x240.png
- ui-icons_888888_256x240.png
- ui-icons_cd0a0a_256x240.png
- jquery.ui.accordion.min.css
- jquery.ui.autocomplete.min.css
- jquery.ui.button.min.css
- jquery.ui.core.min.css
- jquery.ui.datepicker.min.css
- jquery.ui.dialog.min.css
- jquery.ui.progressbar.min.css
- jquery.ui.resizable.min.css
- jquery.ui.selectable.min.css
- jquery.ui.slider.min.css
- jquery.ui.tabs.min.css
- jquery.ui.theme.min.css
- jquery-ui.min.css
- BlogController.cs
- HomeController.cs
- ValuesController.cs
- DojoDataGrid.csproj
- DojoDataGrid.csproj.user
- favicon.ico
- Global.asax
- Global.asax.cs
- accent.png
- bullet.png
- heroAccent.png
- orderedList0.png
- orderedList1.png
- orderedList2.png
- orderedList3.png
- orderedList4.png
- orderedList5.png
- orderedList6.png
- orderedList7.png
- orderedList8.png
- orderedList9.png
- Blog.cs
- BloggingModel.Context.cs
- BloggingModel.Context.tt
- BloggingModel.cs
- BloggingModel.Designer.cs
- BloggingModel.edmx
- BloggingModel.tt
- packages.config
- AssemblyInfo.cs
- _references.js
- jquery.unobtrusive-ajax.js
- jquery.unobtrusive-ajax.min.js
- jquery.validate.js
- jquery.validate.min.js
- jquery.validate.unobtrusive.js
- jquery.validate.unobtrusive.min.js
- jquery.validate-vsdoc.js
- jquery-1.7.1.js
- jquery-1.7.1.min.js
- jquery-1.7.1-vsdoc.js
- jquery-ui-1.8.20.js
- jquery-ui-1.8.20.min.js
- knockout-2.1.0.debug.js
- knockout-2.1.0.js
- modernizr-2.5.3.js
- _ViewStart.cshtml
- Index.cshtml
- _Layout.cshtml
- Error.cshtml
- Web.config
- Web.config
- Web.Debug.config
- Web.Release.config
- Readme.txt
DojoDataGrid.zip
- DojoDataGrid.sln
- DojoDataGrid
  - App_Data
  - bin
    - DojoDataGrid.dll
    - DojoDataGrid.pdb
    - EntityFramework.dll
    - EntityFramework.xml
  - Content
    - Site.css
    - themes
      - base
        
        images
        
        ui-bg_flat_0_aaaaaa_40x100.png
        
        ui-bg_flat_75_ffffff_40x100.png
        
        ui-bg_glass_55_fbf9ee_1x400.png
        
        ui-bg_glass_65_ffffff_1x400.png
        
        ui-bg_glass_75_dadada_1x400.png
        
        ui-bg_glass_75_e6e6e6_1x400.png
        
        ui-bg_glass_95_fef1ec_1x400.png
        
        ui-bg_highlight-soft_75_cccccc_1x100.png
        
        ui-icons_222222_256x240.png
        
        ui-icons_2e83ff_256x240.png
        
        ui-icons_454545_256x240.png
        
        ui-icons_888888_256x240.png
        
        ui-icons_cd0a0a_256x240.png
        
        jquery.ui.accordion.css
        
        jquery.ui.all.css
        
        jquery.ui.autocomplete.css
        
        jquery.ui.base.css
        
        jquery.ui.button.css
        
        jquery.ui.core.css
        
        jquery.ui.datepicker.css
        
        jquery.ui.dialog.css
        
        jquery.ui.progressbar.css
        
        jquery.ui.resizable.css
        
        jquery.ui.selectable.css
        
        jquery.ui.slider.css
        
        jquery.ui.tabs.css
        
        jquery.ui.theme.css
  - Controllers
  - DojoDataGrid.csproj
  - DojoDataGrid.csproj.user
  - Global.asax
  - Global.asax.cs
  - Models
    - AccountModels.cs
    - Blog.cs
    - BlogModel.Context.cs
    - BlogModel.Context.tt
    - BlogModel.cs
    - BlogModel.Designer.cs
    - BlogModel.edmx
    - BlogModel.edmx.sql
    - BlogModel.tt
    - RestHttpVerbFilter.cs
  - packages.config
  - Properties
    - AssemblyInfo.cs
  - Scripts
  - Views
    - _ViewStart.cshtml
    - Account
    - Home
      - generateSomeBlog.cshtml
      - Index.cshtml
    - Shared
    - Web.config
  - Web.config
  - Web.Debug.config
  - Web.Release.config
- Help.htm
- Help
  - demo.png
  - edmx.sql.png
  - error.png
  - executeSql.png
  - ok.png
  - sql.png
- packages
  - EntityFramework.4.1.10331.0
    - EntityFramework.4.1.10331.0.nupkg
    - lib
      - EntityFramework.dll
      - EntityFramework.xml
  - jQuery.1.5.1
    - Content
      - Scripts
        
        jquery-1.5.1.js
        
        jquery-1.5.1.min.js
    - jQuery.1.5.1.nupkg
  - jQuery.UI.Combined.1.8.11
    - Content
      - Content
        
        themes
        
        base
        
        images
        
        ui-bg_flat_0_aaaaaa_40x100.png
        
        ui-bg_flat_75_ffffff_40x100.png
        
        ui-bg_glass_55_fbf9ee_1x400.png
        
        ui-bg_glass_65_ffffff_1x400.png
        
        ui-bg_glass_75_dadada_1x400.png
        
        ui-bg_glass_75_e6e6e6_1x400.png
        
        ui-bg_glass_95_fef1ec_1x400.png
        
        ui-bg_highlight-soft_75_cccccc_1x100.png
        
        ui-icons_222222_256x240.png
        
        ui-icons_2e83ff_256x240.png
        
        ui-icons_454545_256x240.png
        
        ui-icons_888888_256x240.png
        
        ui-icons_cd0a0a_256x240.png
        
        jquery.ui.accordion.css
        
        jquery.ui.all.css
        
        jquery.ui.autocomplete.css
        
        jquery.ui.base.css
        
        jquery.ui.button.css
        
        jquery.ui.core.css
        
        jquery.ui.datepicker.css
        
        jquery.ui.dialog.css
        
        jquery.ui.progressbar.css
        
        jquery.ui.resizable.css
        
        jquery.ui.selectable.css
        
        jquery.ui.slider.css
        
        jquery.ui.tabs.css
        
        jquery.ui.theme.css
      - Scripts
        
        jquery-ui-1.8.11.js
        
        jquery-ui-1.8.11.min.js
    - jQuery.UI.Combined.1.8.11.nupkg
  - jQuery.Validation.1.8.0
    - Content
      - Scripts
        
        jquery.validate.js
        
        jquery.validate.min.js
        
        jquery.validate-vsdoc.js
    - jQuery.Validation.1.8.0.nupkg
  - jQuery.vsdoc.1.5.1
    - Content
      - Scripts
        
        jquery-1.5.1-vsdoc.js
    - jQuery.vsdoc.1.5.1.nupkg
  - Modernizr.1.7
    - Content
      - Scripts
        
        modernizr-1.7.js
        
        modernizr-1.7.min.js
    - Modernizr.1.7.nupkg
  - repositories.config

/// <reference path="jquery-1.7.1.js" />
/// <reference path="jquery-ui-1.8.20.js" />
/// <reference path="jquery.validate.js" />
/// <reference path="jquery.validate.unobtrusive.js" />
/// <reference path="knockout-2.1.0.debug.js" />
/// <reference path="modernizr-2.5.3.js" />

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

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

Written By

Nikfazan

Software Developer (Senior)

United Kingdom

“If you can't explain it simply, you don't understand it well enough.”
Albert Einstein

DataGrid View with "CRUD operations" using Dojo DataGrid, JsonRest Store, Entity Framework, SQL Server, ASP.NET MVC Web API

License

Comments and Discussions