DataTables Ajax (edit)
Samples (C#)
https://drive.google.com/file/d/18QJAg6BoB77gixjKydGZsmsPQSu5-IEe/view (GOOD)
https://drive.google.com/drive/u/0/folders/1Gf89oMPZEfbjBuqduP8yG6SeX5V9hc0Z (nvmanhifi@gmail.com)
https://developer.okta.com/blog/2018/07/27/build-crud-app-in-aspnet-framework-webapi-and-angular
Samples (PHP)
https://www.tutorialrepublic.com/php-tutorial/php-mysql-crud-application.php
Samples (JAVA) - STOCK MANAGEMENT SYSTEM
https://fiware-tutorials.readthedocs.io/en/latest/crud-operations/index.html
CRUD - ASP.NET MVC 5 + AngularJS
https://github.com/glaucia86/crud-mvc5-ef-angularjs
https://github.com/anuraj/MVCAngularCRUDExample
CRUD - ASP.NET MVC 5 + Web API 2
https://github.com/SibeeshVenu/CRUD-MVC-WebAPI
CRUD - ASP.NET MVC 4
https://github.com/S3gillu/WeekSeven
CRUD - ADMIN + Restaurant Management System
https://github.com/mohamed-abdelalem/Resturant
CRUD - CRM
https://github.com/VanHakobyan/CustomerRelationshipManagement_CRM
CRUD - Open Source Code
https://github.com/topics/crud-application (GOOD)
https://npm.pkg.github.com/topics/datatables (GOOD)
https://github.com/topics/crud-sample (GOOD)
https://dzone.com/articles/crud-operation-in-aspnet-mvc-using-ajax-and-bootst (GOOD GOOD GOOD)
https://www.codaffection.com/angular-5-tutorial/angular-5-user-registration-web-api/ (GOOD GOOD GOOD)
https://garrylachman.github.io/ElectroCRUD/
CRUD - PizzaMVC (ASP.NET MVC 5 + TinyMCE + AJAX)
https://github.com/dwdkls/pizzamvc (GOOD)
CRUD - .NET Core
https://github.com/etrupja/CRUD-Core-MVC
https://github.com/go2ismail/ASP.NET-Core-2-MVC-CRUD-datatables-jQuery-Plugin (GOOD)
https://npm.pkg.github.com/go2ismail/POS---Point-Of-Sales
https://npm.pkg.github.com/LZorglub/DataTables.AspnetCore.Mvc
CRUD - Dapper + jTable
https://github.com/muddassirm/simple-mvc-crud
https://www.codeproject.com/Tips/1168151/CRUD-Screen-using-ASP-NET-MVC-dapper-and-jTable-in
Practices
Online Complaint Management System
https://github.com/emrecavunt/OnlineComplaintManagementSystem
Datatables SSP class for server side scripting: https://github.com/arksnorman/ssp
Working with AJAX, Performing CRUD opertaions & Embed DataTables with Complete Server side opertaion over ajax.
https://github.com/ArslanAmeer/Practicing-AJAX-JQuery
jQuery DataTables Demo using ASP.NET Core MVC and Dapper ORM
https://github.com/peterschlosser/DataTablesCoreMVCDapper
Dapper
Version 1.50.2 (.NET Framework 4.5)
https://riptutorial.com/dapper/example/15/basic-parameterized-sql
DataTables
https://www.sitepoint.com/working-jquery-datatables/
https://pusher.com/tutorials/realtime-table-datatables
https://github.com/christiannwamba/pusher-realtime-jquery-datatable
https://code.msdn.microsoft.com/Implement-Ajax-CRUD-a543a978
https://code.msdn.microsoft.com/How-to-implement-Advanced-84ce58e8
https://www.c-sharpcorner.com/article/using-datatables-grid-with-asp-net-mvc/
DataTables Row select/remove()/delete()
https://datatables.net/extensions/select/examples/api/cancellableEvents.html
https://datatables.net/examples/api/select_single_row.html
https://datatables.net/reference/api/row().remove()
https://datatables.net/reference/api/row().delete()
DataTable.AcceptChages()
DataTables Ajax (HAY)
https://datatables.net/examples/ajax/
https://datatables.net/forums/discussion/45352/how-to-solve-ajax-reload-undefined
https://datatables.net/forums/discussion/43669/datatables-ajax-reload-not-working
SQL Server Management Objects (SMO) Tutorials
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms131540(v=sql.105)
https://www.codeproject.com/Articles/127065/SMO-Tutorial-of-n-Programming-data-storage-objec
Do not use SQL-DMO in new development work; use SQL Server Management Objects (SMO) instead. You can obtain the SMO documentation by installing SQL Server 2008 R2 Books Online.
Generate SQL Server Table from C# Model Class
https://stackoverflow.com/questions/47239/how-can-i-generate-database-tables-from-c-sharp-classes
Generate C# Model Class from SQL Server Table
https://habilisbest.com/creating-c-model-class-from-sql-query
https://dzone.com/articles/convert-table-column-into-c-model-class
http://codinpk.blogspot.com/2014/03/generate-c-class-for-sql-server-table.html
Database Providers
https://docs.microsoft.com/en-us/ef/core/providers/
LINQ to SQL
// Attach the log to show generated SQL.
db.Log = Console.Out;
// Query for customers in London.
IQueryable<Customer> custQuery =
from cust in Customers
where cust.City == "London"
select cust;
Entity Framework 6
https://docs.microsoft.com/en-us/ef/ef6/modeling/code-first/migrations/
https://docs.microsoft.com/en-us/ef/ef6/modeling/code-first/workflows/new-database
If the database had not already been created this InitialCreate migration would not have been added to the project. Instead, the first time we call Add-Migration the code to create these tables would be scaffolded to a new migration.
using System.Data.Entity;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Data.Entity.Infrastructure;
namespace MigrationsDemo
{
public class BlogContext : DbContext
{
public DbSet<Blog> Blogs { get; set; }
}
public class Blog
{
public int BlogId { get; set; }
public string Name { get; set; }
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace MigrationsDemo
{
class Program
{
static void Main(string[] args)
{
using (var db = new BlogContext())
{
db.Blogs.Add(new Blog { Name = "Another Blog " });
db.SaveChanges();
foreach (var blog in db.Blogs)
{
Console.WriteLine(blog.Name);
}
}
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
}
}
Package Manager Console
Enable-Migrations
Add-Migration InitialCreate
Update-Database
If the database had not already been created this InitialCreate migration would not have been added to the project. Instead, the first time we call Add-Migration the code to create these tables would be scaffolded to a new migration.
Add-Migration AddBlogUrl
Update-Database
namespace MigrationsDemo.Migrations
{
using System;
using System.Data.Entity.Migrations;
public partial class AddBlogUrl : DbMigration
{
public override void Up()
{
AddColumn("dbo.Blogs", "Url", c => c.String());
}
public override void Down()
{
DropColumn("dbo.Blogs", "Url");
}
}
}
NoCache
http://taswar.zeytinsoft.com/disable-browser-cache-in-asp-mvc/
https://formativeinnovations.wordpress.com/2012/10/15/no-cache-for-iis-or-browser-mvc/
https://jonlabelle.com/snippets/view/csharp/no-cache-attribute
https://www.thewebflash.com/how-to-prevent-caching-in-asp-net-mvc/
Toggle inside DataTables
https://www.kvcodes.com/2017/03/bootstrap-toggle-inside-jquery-datatable/
State save
https://datatables.net/examples/basic_init/state_save.html
Reload/Refresh data
https://datatables.net/forums/discussion/55269/ajax-reload-not-working-with-server-side-processing
https://www.codeproject.com/Questions/1190431/Refresh-datatable-without-refreshing-page
https://stackoverflow.com/questions/12934144/how-to-reload-refresh-jquery-datatable
$(document).ready(function() {
$('#example').DataTable().ajax.reload();
}
Reload keep page
https://datatables.net/forums/discussion/55269/ajax-reload-not-working-with-server-side-processing
https://stackoverflow.com/questions/42905454/datatables-ajax-reload-loses-page
https://datatables.net/forums/discussion/20909/api-ajax-reload-loses-page
$(document).ready(function() {
$('#example').DataTable().ajax.reload(null, false);
}
