DataTables ASP.NET MVC 5 Part 2

by

Hi, again this is Part 2 from DataTables ASP.NET MVC 2.

In Part 1, I showed you how to add all data required.

Now let's try to finish what we start together.

Now will try to add new Controller and Call it StudentController.

 

The most important one is, what I highlight it (Yellow).

First one is declared our Interface,

  private readonly IStudent repositoryStudent;

building contractor.

 public StudentController(IStudent repoStudent)
        {
            repositoryStudent = repoStudent;
        }

 

This one our main job :)

  public ActionResult DataTablesJQueryJSON()
        {

         } 

ActionRsult will return JSON data to HTML page.

 [WebMethod]
        [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
        public ActionResult DataTablesJQueryJSON()
        {
            List<Student> model = new List<Student>();
            model = repositoryStudent.GetStudent; 
            var UserData = new object[model.Count];
            int j = 0;
            foreach (var i in model)
            {
                UserData[j] = new object[] {i.ID, i.FirstName ,i.LastName, i.City};
                j++;
            }
           
            return Json(UserData, JsonRequestBehavior.AllowGet);
        }

 

In last ActionResult, we read data from StudentRepository.

Store it in a model variable.

UserData to store our data after convert it to Object (ordering Important).

Create New View Call it DataTablesJQuery.

After adding HTML Table show be same what ActionResult will return,

I mention it before, ordering is important. 

The Big Boss our JavaScript code with AJAX will call DataTablesJQueryJSON method.

All that will be send to the #example HTML table.

To be Shown like this. 

 

Look at the previous Photo,

look, how many free features you add with simple code. 

 

Source Code

Youtube Videos

if you have any question,

Please, write it in the comment.

DataTables ASP.NET MVC 5 Part 1

by

Hi,

Today I'm going to write Article about very useful tool,

DataTables.net, many of us having trouble when trying to display data in  HTML page.

 it's important to have filtering, paging, and searching box.

OK, any developer can write it down, but today there are many tools make it easier same DataTables.net,

what we will show in this tutorial.

its look good, and easier when coding it.

So let's start with new ASP.NET MVC 5 project.

Follow the photos ;) 

 

Choose MVC,

 

Next Step, Add DataTables From NuGet packages.

 

If you don't want o use it from NuGet just add it as CDN.

So, Now we need data to send it to our HTML page and display it in DataTables

First, we need to create new Class in Models folder and call it Student.

 

Next Step, Create Folder Call it Services will put inside it,

a new class (IStudent class).

 

 

After Create our Interface, we need to create Repository Folder with StudentRepository class.

In StudentRepository Class, I have fake data just to show you how it will be in our HTML page.

sure you can Use data from your SQL Server database, using Entry Framework.

 

See you in Part2