@manhnguyenv

Welcome to my blog!

DataTables Ajax

June 30, 2019 06:11

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

https://www.grapecity.com/blogs/create-web-application-performing-database-operations-using-javascript-web-api

https://www.bubt.edu.bd/assets/backend/DataTables-1.10.13/DataTables-1.10.13/extensions/Select/examples/initialisation/reload.html

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://dapper-tutorial.net/

https://riptutorial.com/dapper/example/15/basic-parameterized-sql

DataTables

https://blogs.msdn.microsoft.com/usisvde/2012/06/12/getting-started-on-line-of-business-html5-app-part-13-display-edit-in-datatables-jquery-plug-in/

https://www.c-sharpcorner.com/article/ajax-crud-operation-with-jquery-datatables-in-asp-net-mvc-5-for-beginners/

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

  "ajax": {
        url: "myUrl",
        type: "POST",
    },
   "language": {
        "zeroRecords": "No records available",
        "loadingRecords": "Loading...",
        "processing": "Processing..."
    },

SQL Server Management Objects (SMO) Tutorials

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms131540(v=sql.105)

https://docs.microsoft.com/en-us/sql/relational-databases/server-management-objects-smo/sql-server-management-objects-smo-programming-guide?view=sql-server-2017

https://www.codeproject.com/Articles/127065/SMO-Tutorial-of-n-Programming-data-storage-objec

https://dangvinhcuong.com/2015/05/18/mssql-smo-bo-thu-vien-lap-trinh-database-smo-sql-server-management-objects/

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

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/walkthrough-simple-object-model-and-query-csharp

// 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

https://stackoverflow.com/questions/10011780/prevent-caching-in-asp-net-mvc-for-specific-actions-using-an-attribute

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

$(document).ready(function() {
    $('#example').DataTable ({
        stateSave: true
    });
} );

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);

}

Blogs (Scott Lilly)

https://scottlilly.com/

https://github.com/ScottLilly/

Categories

Recent posts