Asp.Net MVC CRUD Operations Using Datatable

[@CodAffection]

goo.gl/bPcyXW : Buy me a Coffee bit.ly/3Z5uWUR : jQuery DataTable Full Tutorial with Asp.Net MVC bit.ly/36IA1cH : AspNet Core MVC CRUD bit.ly/3Pn2S7y : Expense Tracker App in AspNet Core MVC bit.ly/403lUVC : MVC Login & User Registration bit.ly/3muhseC : CRUD without EF in AspNet Core MVC bit.ly/2yEPlpB : Convert MVC App to Single Page bit.ly/39B6xdh : Image Upload in AspNet Core MVC bit.ly/30fPDMg : More MVC Tutorials

[@rolandryder5811]

Instablaster.

[@ebrahimmoharrami1234]

The film was Ali. I went step by step and did not encounter any problems. Thank you very much

[@NateSavk]

Thank you so much! this is the first time I don't end up giving up on a tutorial because nothing works even if you follow every freaking exact step. And even if I did encounter some inconveniences, I was able to figure them out on my own which makes me feel proud AF XD I am using this example for an university project, thank you sooooo very much!!! You saved my butt from failing miserably, very detailed tutorial. Saludos all the way from Costa Rica! Keep on sharing your knowledge, you have no idea how many of us you're helping :)

[@jayeshmhatre259]

This is one of the best video on youtube. I have completed that crud project without any single error . I have subscribed your channel 05/07/2024 . Thank you so much buddy.❤

[@CodAffection]

Glad you found it helpful.

[@davidjoseguzmanarenales1367]

Excellent video man! I have followed the video step by step. Right now, I'm in the 28:35 minute, and all works without any problem. Thank you.

[@sudheerm.s6792]

16:15 where from you get "Employees" property. It is not mentioned anywhere .

[@cewisham]

I did this tutorial. There is a lot of information covered here. It was very helpful and nicely presented. Thank you.

[@robertomancino5517]

This video is one of the best I see so far. THANK YOU SO MUCH,

[@jessebusuulwa1154]

This is one tutorial on Asp.Net MVC I have found very easy to follow. Thanks so much. I will have to watch it again.

[@CodAffection]

Thanks for the comment, Glad you found the video helpful.

[@alicenguyen7355]

Your video channel is very rich I still always watching. Thank you.

[@CodAffection]

Glad you found it helpful. thanks for the wonderful feedback!

[@alicenguyen7355]

@@CodAffection I really enjoyed this. Thank you for sharing. Be well.

[@shathishrajk7828]

The video is very useful and made in such a way that we can elaborate our application to any extent from this. Thank a lot, it saved a lot of time.

[@CodAffection]

Glad you found the video helpful and thanks for your wonderful feedback.

[@raymanbacchus]

This was an amazing video where I learned a lot. You spoke clearly and slowly enough for everyone to understand and you also spoke into the microphone loud enough so people could hear. Thank you for this. It was an amazing education into creating my own CRUD grids instead of relying on other very expensive options.

[@CodAffection]

Glad you found it helpful. Thanks for your wonderful feedback.

[@mashup4047]

Thank you soo much for your most valuable content ever,I done the ERP project because of your this video...2024/9/28

[@CodAffection]

most appreciated.

[@mufy9004]

No words... Excellent.. 😍 Thank you so much.. ❤️

[@maniammaiprakash5170]

Really really a great tutorial....Very useful for beginners...Thank u soooooooooooo much.

[@bigbob2364]

nice I copied your table format exactly and now I will get a

[@muhammadburhan2309]

very helpful tutorial on MVC with frontend !!

[@96stefancar]

If your validation doesn't work properly, try typing "if ($(form).validate().valid()){...}" in SubmitForm function instead of "if ($(form).valid()){...}". That worked for me. Great job anyway!

[@skyblueinfinity1271]

very useful sir thank you so much, by far the best asp.net mvc video I have viewed

[@CodAffection]

thanks for the comment.

[@lescinqlune]

You deserve a lot of thanks for these tutorials!

[@mfhislamic]

Very good video for learning. Keep posting this type of videos.

[@CodAffection]

glad you found the video helpful. let me know if you have any video suggestion related to asp.net mvc.

[@alimosaad6107]

Great explanation, keep going up and don't stop successful 💪, you are the best 👍

[@akashmahant2657]

It is a really helpful video for MVC beginner

[@CodAffection]

Glad to hear that.

[@leavedrakealone1801]

at 25:22 in my visual studio, htmlAttributes does not come up. Please help

[@justaboutanything8506]

Great tutorial, those who disliked, show us what best you have which made you dislike this tutorial

[@chanchilaru]

jquery.validation files are not being added after creating the view in min 9:10 any clues why? im having problems doing the validation of the form later on the video

[@CodAffection]

validation script files are added inside Layout page(_Layout.cshtml).so we don't need to add these script references.

[@chanchilaru]

buti think that jquery.validation and jquery.unobtrusive.validation js files must be referenced in Layout page. Mi problem is that this file is missing in the Scripts folder

[@chanchilaru]

anyway i just downloaded this files and added manually, and now its working. I dont know why they werent there, jquery ui was istalled previously with nugget as u suggested. Thanks for the help.

[@leavedrakealone1801]

bro where did you download the missing files. I am having same issue. Thanks

[@leavedrakealone1801]

@@chanchilaru Where did you download the missing files bro. I am having same issue.

[@cheseltonanto669]

The tutorial was soo good. And it works most of all Can you tell me how to add multiple tables in datatable with each table joined using foreign key

[@deltademon5705]

For those who want to add image $(document).ready(function () { $('#countryNameTable').DataTable({ "ajax": { "url": "/Admin/CountryName/GetData", "type": "GET", "datatype": "json" }, "columns": [ { "data": "NameOfCountry" }, { "data": "ImagePath", "render": function (data, type, row) { return ''; } } ] }); });

[@ajaythomasmathews8995]

Bro, you did a great job and also, you made my life easy today. Thanks again. God bless.

[@WangAndrew]

Thank. But on 37:10, after adding the "new {onsubmit="return SubmitForm(this)"}", the "AddorEdit" action is not fired when submit. Instead, the "Index" is fired. Don't know why ...

[@anandseniyar8814]

Even I come across a similar situation, in my case the Insert operation is successful, however success message is shown in Index page and not in the AddOrEdit view.

[@CodAffection]

pls download the demo project source code and try. it would be helpful to understand the actual project in your project.

[@ruwanc2003]

Excellent Tutorial, Thank you very much

[@theunlock3869]

thank you very much very good content it works very well I was able to create a small project right away.

[@mrVetronom]

Thanks, great stuff. From what I was trying, for some reason, the use of variable "dataTable" did not help. Instead of "dataTable.ajax.reload();", I used "$('#employeeTable').DataTable().ajax.reload();"

[@grzegorzsokalski7328]

both Your ways doesn't work for me... :(

[@sanimridha7725]

thanks $('#employeeTable').DataTable().ajax.reload(); this worked for me

[@JatinSharma-gm5ki]

I use this method also...

[@drakimawork7988]

Great job with this project. Also I have never seen anyone use C# code within a script tag in the cshtml file before, very clever technique.

[@CodAffection]

I am glad you found the video helpful

[@ishaganar1187]

Just awesome ❤️ nothing can be better than this 💯😍

[@amohsyn]

Excellent work and i salute to you efforts you put in for this awesome demo. Keep doing bro.

[@JatinSharma-gm5ki]

Thank you sir !!!!! your video very helpful for beginners..

[@jesuscubedo9988]

Excelente video, aprendi mucho, me gusataria ver un video tablas relacioadas, gracias por el aporte, saludos

[@expertknowledge9857]

Thanks sir, I learn new things from this vedio

[@hichamo-sfh177]

great cours ! is this stack available only for .Net Mvc .. or for .Net Core Mvc too ..?

[@maxlimgj]

why if id ==0 then return view?at 51:00, I dont really understand the jquery and ajax, is there a link/ tutorial where I can learn them?

[@YT_FutureCodeX]

Thanks Sir for your great explanation with step by step implementation.

[@CodAffection]

Glad you liked it

[@2005Azm]

This had been a complete delight !! thank you so much !

[@CodAffection]

My Pleasure :)

[@sunhi1032]

getting as error at 15:50 as "DbModel: type used in a using statement must be implicitly convertible to 'system.idisposable' "

[@rajkumarbuddha866]

using (Employee.Model.Models db = new Employee.Model.Models()) { List empList = db.Employees.ToList(); return Json(new { data = empList }, JsonRequestBehavior.AllowGet); }

[@chidieberelevi3344]

Thanks so much. Lovely explanation. Very understandable.

[@CodAffection]

Glad it was helpful!

[@AlexandreBarbosaIT]

Hi @CodAffection, I am having problem in the DBModel namespace (not found) for my attempt to copy what you did at the point 15:50 in your video

[@akashgupta2971]

Did you get a solution?

[@akashgupta2971]

Did you get any solution for this?

[@alqamasadiq8659]

This is really great tutorial. Very much informative.

[@DennisHun]

Thank you for this video ! This amazing video for MVC beginners :)

[@benjocempron4334]

Thank you sir, this tutorial is amazing and great! congrats!

[@danielvillanueva4909]

Great Video!! Please continue to make videos like this!

[@CodAffection]

sure. thanks for the comment.

[@shafikkhatib9119]

Thank You Sir. Helps a lot. But you havent shown Search of records

[@azzassfa]

Excellent tutorial. thanks for putting it up.

[@peterluo1776]

Well done. Very good video. Thanks you sir.

[@waqar8544]

submitForm = function (form) { $.validator.unobtrusive.parse(form); Try this if you are facing validation error..............it solved my problem

[@ElMalditoAmo]

Dude, this is so cool, just what I was looking for. Thank you!

[@CodAffection]

I'm glad you found the video helpful.

[@tareksnow]

Very Very Very informative, detailed, and helpful! Great job!

[@CodAffection]

Thank you!

[@prakashlekshmanan4568]

Thanks for the excellent tutorial. It will be great if you could a demo for relational tables like customer and its many contact

[@pavithranarayanan9435]

I was glad that I got a perfect video to learn...thank you Sir....I have a doubt Sir...I'm using VS 2019 and I'm unable to find the ADO.NET Entity Data Model...please help me with this issue Sir

[@CodAffection]

Take what is necessary from this tutorial here : kzbin.info/www/bejne/d3nUeqWAlLWfhrs

[@pavithranarayanan9435]

@@CodAffection Yeah will look into it Sir, Thanks!

[@frankduku1963]

This tutorial is very educative. Can you please do some tutorials on this article including stored procedures in the database? Thank you.

[@CodAffection]

I have done few tutorial with stored procedure also. let me know, what exactly you are looking for ?

[@dattatreyakulkarni541]

Super, do one menus video using asp.net mvc

[@tomyang7788]

at 15:03 should not be url be the route of the controller ?

[@CodAffection]

didn't get you ? any problem with url ?

[@kodjokenin3785]

Can you use Data table technique to call stored procedure? I like to see that..🙏

[@rammarvaro1010]

For the bootstrap on DataTables... i used Bootstrap 3 like you did and the style was really awkward! updated both script and link in VStudio to bootstrap 4 and it worked perfectly fine!

[@CodAffection]

I'm glad you found the video helpful.

[@metea.890]

Same here Bootstrap 3 was meme i turned to 4 worked fine

[@TheInspiration152]

Hello Sir. Thank you. Hope you have video on how to create dropdown list, check box populated in database and date . Thank you.

[@IrizLegaspi]

Thank you! love your videos! Just curios how to make the salary in currency (price/amount) format.

[@ngkhanh6956]

This is amazing, thanks you. So helpful to beginners like me

[@CodAffection]

thanks for the comment.

[@imadabab]

Thanks a lot for this excellent tutorial. Appreciate it. I have subscribed.

[@CodAffection]

Thanks for the sub!

[@yasheshshah7129]

In my program, Datatables.net/Css.min.js ....is not found. ERROR @ first output @ 17:45 What should i do? Please help

[@khanyangxabani8297]

Great video! Please create a similar project to this using JQuery datatables for ASP.NET Core.

[@thuyphamtruong3293]

Thank you, very helpful but have you try to click edit button second time after changed success the data in Edit View not reload.

[@CodAffection]

Any error message in console window ?

[@thuyphamtruong3293]

There is no error message, have you go the same issue with you project ?

[@kelbinlin287]

Very nice and detailed Tutorial, Thank you!!!

[@lorelyle]

very helpful! and easy to understand! really helped me in my project!

[@rahul.kanojia]

Thanks bro. You have saved a lot of time..................

[@CodAffection]

Glad you found it helpful.

[@bigbob2364]

Do you recommend learning javascript first or can you pick this up without learning javascript?

[@mehmetsukrumumbucoglu9541]

This video tutorial is really guiding, thanks for that. I would be happy if you can help me have a question. . I would like to do a survey application. The questions of this questionnaire consist of multiple choice and / or text fields. I've created a survey for this part just enters the survey name and description. I'll do the question later. As I said, the options of the questions should be multiple choice or they should contain a text field and create a dynamic structure. Then I plan to select a questionnaire and pair it with the questions. My question is how do I make the question and answer option dynamic? So you can think of it like category and subkateori. Wonder your help.

[@pradeepvelavali9321]

Thanks very much helpful. Great Job 👍

[@MrXhabi]

Thanks Great Tutorial. Would be great if you can add one dropdown and a date column in your future videos.

[@CodAffection]

Noted

[@gouravtike4559]

Validation failed for one or more entities. See 'EntityValidationErrors' property for more details. error is showing I corrected the unobtrusive also pls help

[@tahirraza1732]

Thanks man.. ur tutorials helped alot.. plz do some tutorial on Multiple file upload or image or something like add new row or file uploader at run time and then save the record in database . or if u've any article regarding this plz let me know or share the link here. Thnx in advance

[@jethwamayur05]

Video is very good just have one question - how can i hide the buttons for some rows based on some data which is not in column

[@luislobe]

Muy bueno, me ayudo mucho, gracias y saludos desde México

[@CodAffection]

de nada :)

[@jameswachira5713]

woow..excellent tutorial. Good job bro.

[@sunilkurian6682]

Thanks!!... this is a superb session.

[@klugandavid166]

DotNet Mob, I am grateful for your explanations so far, when using list you made use of "Employees" (reference video playtime at 16:12) but it is not working for me. I am getting the error Dbset does not contain a definition for 'ToList' I want to ask what is the identity of "Employees" when you were creating "empList". Thank you!!!

[@CodAffection]

try after adding following using statement. using System.Linq;

[@klugandavid166]

Sir please the using System.Linq statement is already in my file...Please can you explain to me the use of "Employees" because I don't understand what is means over there either a tables instance name or something.....I am working on another project with explanations from your video... I am grateful!

[@klugandavid166]

at 16:12 Sir you use db.Employees......where is that name:"Employees" coming from... I need clarification. You have helped me a lot with your tutorials

[@klugandavid166]

I think my mistake happens for the fact that in creating the class I have to declare something of type IEnumerable, but I can only somehow tell what the problem might be but don't have any idea about the solution. I need your help. Thank you Sir.

[@chrisdanevalla3293]

Thanks for sharing this! A big help for our IMS project :)

[@8maF0]

The bootstrap and css that you are referring online can it be downloaded offline and mapped in a local folder?

[@sunandanaik9359]

Very helpful and grateful of you sir..thank you

[@tonybalde4298]

When I press F5 it doesn't load the same layout It shows only the texts, without the table on min -> 17:48

[@sudarshanbelose1912]

I have the same issue.

[@tonybalde4298]

@@sudarshanbelose1912 Did you solved it?

[@sudarshanbelose1912]

@@tonybalde4298 Yes, you have to reference the JS files on your page to get the styling like this solution has

[@tonybalde4298]

@@sudarshanbelose1912 Thanks I’ll try it 3 years later 😂

[@vskvicky7212]

@sudarshan plz help me i m having the same problem

[@onurkodak3960]

You are very successfull Thank you...

[@salihacur3201]

Thank you, I like this tutorial, it was helpful.

[@marvinbendicio7350]

Good day sir, I would like to ask: Dbcontext.Employee.cs Datamodel is auto generated when created (Add>New>item>ADO.net EF: DBModels.edmx). So when you update your database on (SQL SERVER) like you add another table or new columns in future) then you have to "Update Model From Database(right click somewhere on .edmx[Diagram])" so that your database is updated on the solution project. Employee.cs is being reset. all the Data Annotations on data model class is gone/removed by the automated process thing. Does it make sense ? so for that, you have to apply data annotation again.

[@marvinbendicio7350]

This is the comment section of the auto generated csharp file: // // This code was generated from a template. // // Manual changes to this file may cause unexpected behavior in your application. // Manual changes to this file will be overwritten if the code is regenerated. //

[@sagarshrestha448]

Thank you for this tutorial. If i need to work with multiple tables do I need to add multiple ADO.NET Entity Data model or I can just add one Entity Data model with multiple tables??

[@CodAffection]

single entity model with multiple tables.

[@sagarshrestha448]

Thank you. Also what do i need to do if i need a drop down list on the popup form with data from another table?

[@CodAffection]

try this kzbin.info/www/bejne/m5qXlYKKpKd5rtU

[@VijayKumar-yw6vn]

One model with any number of tables.

[@BladeSlayerr]

Thank you for this great tutorial, you've explained it very well. Not sure if it helps anyone, but it you create or edit a row and instead of seeing the table you see {"success":true,"message":"Saved Successfully"}, it's best to download the project he added in the description and compare the codes (that way you will know where you were mistaken). i had this issue and my mistake was in function SubmitForm(form) in Index.cshtml. i wrote *if ($(form). **_valide_** ()){* and not *if ($(form). **_valid_** ()){* . the issue was that i wrote *.valid* with an *E* at the end - like so *.valide* . hope it helps anyone. *P.S. if you are asking yourselves how i've added a bold and italic effect to the comment - see here: onlinesense.org/youtube-comments-bold-italics-strikethrough/

[@jenniferpayano4380]

I keep getting that message also, and have compared everything but it doesn't work for me, i still get the messsage

[@leavedrakealone1801]

I still get the message bro.. Success True Message. I copied from his project. Can you tell us what you changed?

[@darayaj]

thank you for you time. I have a problem: When I press the "Add New" button, it does not lift the popup. The error is as follows: TypeError: formDiv.dialog is not a function at Object. Maybe because .NET 5 has new versions, please help. Thanks!.

[@CodAffection]

You still have the problem? Please download the demo project and see whether the is there also. If it is working, then compare it yours. If nothing helps let me know.

[@bennsolo]

Very good tutorial, you have explained each and every step amazing. Thanks for your time and wonderful tutorial. Do you have any tutorial on using the Editor.Datatable?

[@ryanf.clarian4309]

Thank you for the tutorial video. :)

[@RajeevRanjan-oh3qq]

When i create DbModel object i.e. using(DbModel db=new DbModel()). It throws error CS1674.What to do.I have included every possible namespaces.

[@raheelyusuf6194]

Very Comprehensive! Appreciated.

[@jaylovett2237]

@Dotnet Mob very good tutorial. I have one small problem, that this example did not cover is keeping selected values in a drop down list, when I try to edit an exiting record. The DDL goes to the first item listed instead of keeping the selected value. Do you have an example of how to keep the selection when I edit and existing record?

[@CodAffection]

thanks for the comment, please watch this video to solve your problem : kzbin.info/www/bejne/m5qXlYKKpKd5rtU

[@lindaharris22]

Great tutorial! Especially for newbies!

[@CodAffection]

glad you found the video helpful. let me know if you have any asp.net video suggestion in future.