Part 14- Insert data into database using jQuery AJAX in ASP.NET MVC application

[@aapkanigam]

Can we reach 1000 likes on this video. Share this video among your friends and Give your suggestions on which topic I should make videos. Thanks

[@VijayKumar-qw1wn]

you are awsome, u reach 100000 likes , god bless u

[@riyazbasha7982]

I am working in mvc and angular,shocked to see ur videos,these all are real time videos...good work ashish keeepp it up...and i am willing the angular2

[@sachingreat222]

Very nice explanation. Thank you for sharing this video and your efforts

[@mocococo2877]

Hello great video and great series of videos. Thank you. I think the reason you can not delete a row in Employees table is not that you have foreign key from Departments table. Employees is a child in this case and you can delete a child without deleting a parent. In your video N 13 you showed that EmployeeID is a foreign key in Sites table. That makes Sites a child. If you have enforced those relations with primary - foreign key then you can not delete Employee without deleting the corresponding Sites row or rows. I.e. you can not delete a parent row only, as children rows will become orphaned and nothing will point to them and they will become a redundant baggage.

[@aapkanigam]

+Moco Coco yeah you are absolutely right ..thanks for the explanation.My perspective was to deliver simple overview of sql without going in detail, In this way audience can focus on MVC only. May be I will be having sql tutorial also in which I would go in detail.

[@sambaskw]

explaining super...

[@sunpreetsingh5143]

very very very awsm tutorial ....BIG THANKS ASHISH JI

[@duncanmcdonald5250]

I would have liked an explanation as to WHY using JQuery/AJAX to trigger the save action in the controller is a better method than the one used in the previous tutorials.

[@kirankumari-nz8lr]

I loved this video .Very easy explanation keep doing good work .Thanks

[@aapkanigam]

+kiran kumari Thanks for your valuable feedback

[@tayyabjatoi8644]

Very Wonderful...!!

[@sagorfox7042]

Thanks a Lot Sir

[@aniljain50]

Its simple and awesome. Kee up the good work.

[@aapkanigam]

+Anil Jain thanks ..keep learning and sharing

[@ayoforyou448]

many thak's

[@ramreddy4441]

Good Work.....Very Nice (but in Identity field after 5 th record it show 1002 like dis,y it is coming ?)

[@aapkanigam]

+ram reddy thanku .. this is due to when you re -start your Sql server instance then .. the auto increment value will jump to 1000 if column is of int type . For bigint type it will jump to 10000. ITS Microsoft sql server feature which is horrible..

[@veeramuthudotnetveera]

Nice Video sir.But i need to post html textbox data to xml file node using jquery ajax? please help me.. Thank you.

[@redodht]

Very clearly. Thanks for the video

[@aapkanigam]

+Nguyen Truong thanks!

[@aliraza66-h1b]

awesome waiting of these kind of videos with JQ

[@aapkanigam]

Thanks for ur valuable feedback.Sure we'll try to give you best.keep learning and sharing..

[@giftatte4052]

You are good man!, Love your videos... Keep it up

[@aapkanigam]

+Gift Atte thanks ..keep learning and sharing

[@yogeshgangwar8307]

is it works only with razor view ? in my case ,it's not working.

[@neflinkyle8540]

You are Amazing!

[@sachingreat222]

Nice Explanation

[@MuhammadMustafa-kc3ep]

Ashish in your Program Form Validation is not working without Input type sumit kindly help me to fix this problem please

[@betalaprasanth2420]

thanks sir for this easy and good tutorial .... i am having a problem ..my $.ajax () code is not working .. simple jquery is working but not ajax code

[@mohsen5732]

Wonderful tutorial.

[@navzme]

Thanks for awesome video

[@tomyang7788]

so once the ajax post request fires, will the newly entered data be added to the existing database ?

[@aapkanigam]

+Tom Yang yes

[@dmcnamee2010]

Hi great video, I am trying to populate a dropdown in the modal from another table, can you help me ? Thanks Daryl

[@aapkanigam]

part 36 will help you thanks!

[@dmcnamee2010]

Got it sorted thanks

[@maihassan3602]

Thank you so much for the help. This is amazing

[@aapkanigam]

Thanks Mai

[@aapkanigam]

+Mai Hassan Thanks for your feedback..keep learning and sharing to those who love to learn mvc

[@saurabhmishra3641]

Thx Sir

[@MuhammadMustafa-kc3ep]

i am using bootstrap validator with ajax asp.net mvc pop modal form

[@tomyang7788]

so what does the controller associated with the url Test/Index actually do ?

[@aapkanigam]

+Tom Yang it will load index page by hitting index method of Test controller

[@RahulMishra-qq8yy]

Hi Ashish, Thanks a lot for your videos. these are realy needfull. i have an issue while submitting my form in controller model "EmployeeViewModel model" is showing blank not showing the data that i fill in form.

[@CemreTurgut]

Hi. Can you fix that problem?

[@nadezdajanjetovic9310]

Hi Ashish, can you make video tutorial when user click on button to fill text field with value (in my case textbox have to contain number when users click on button) on form of website? I am trying to pass result of method from my Controller to View using jquery when users click on button. Thanks for help!

[@aapkanigam]

+Nadezda Janjetovic you want to set value to textbox ? .. you can use $("#textboxId").val ("write any text here") .

[@nadezdajanjetovic9310]

Yes. This is my method in Controller: public int returnLastIDFromDatabase() { fpisEntities db = new fpisEntities(); Listlista = db.Supplier.ToList(); int lastID = 0; foreach (Supplier s in lista) { lastID= s.SupplierID; lastID++; } return lastID; } So i want when user click on button "Make new supplier" , website texbox have to fill with new id from my method in Controller. Method in Controller return last unique id from database of object Supplier, so system generate automatic new primary key.

[@aapkanigam]

+Nadezda Janjetovic return JsonResult instead of int .example - Return Json (yourlastId, jsonRequestBehavior.AllowGet) In ajax response you will get this id. For getting last Id why have you done looping.. its one line code .please watch part 13 insert data into multiple table . There I have shown how to get latest Id then insert that into other table .

[@nadezdajanjetovic9310]

I will try that,Thanks a lot for help!

[@annuverma936]

what about validation on this page u removed validation code

[@aaronaaronaaron5922]

you really, really Rock!!!!!!! Thanks man.

[@dumindar]

Thank you!

[@musabuthelezi]

Hi! i hope I will get a reply sooner. I was following your video, and i am also trying to insert into the database. I am not sure why it is not taking the values. so when i put the debugger and data="" is always like that. help! how do i solve this

[@aapkanigam]

+Nhlakanipho Musa Buthelezi Have you tried the shared code . Please find the link in description

[@musabuthelezi]

Thankns Let me try that

[@tauhidulislam6163]

Hi, thanks for tutorial, how to find loader image under content folder??

[@aapkanigam]

+Tauhidul Islam you can download it from google and place into that folder

[@JP-pb6kn]

"Okah" Ashish .... "Okah"

[@narendarsingh4672]

Great

[@dgtal2926]

Is there a way to download the source without installing all that spam in my computer?

[@dgtal2926]

Never mind, I found the way. Good tutorial. Thanks

[@kiranrao4553]

What is the way? Can help me ?

[@saurabhmishra3641]

why i am facing 500 internal server error

[@samzviews6315]

hii ashish why validation is not working if am calling action using ajax hit pls anser as soon as fast

[@aapkanigam]

+Sheshmani Pandey Sam you can find the code from blog. Get link from description

[@samzviews6315]

ashish understand what i am asking u just run your code of this video only and left any fields blank and submit u will see validation error is not showing ........that is what i am saying

[@aapkanigam]

+Sheshmani Pandey Sam 1.Have you given the reference of unobtrusive.js and jQuery.js file. They should be in correct order. 2. Make sure to use Required validator above model property 3. For displaying error use validationMessageFor in view 4. Make sure to not use two jquery file reference . 5. Inspect your code using fire bug of your browser and find if you are getting and console error. Hope this would work . If you still get error then tell me that.

[@aapkanigam]

+Sheshmani Pandey Sam watch part 29 for validation using jquery.

[@samzviews6315]

Technotips - Ashish can u pls tell me the correct sequence of jquery references

[@anjalysivan175]

Its not working...i have a problem while submitting my form in controller model is showing blank data that i fill in the form.. why??? this problem is only getting for using ajax ..

[@aapkanigam]

Are you getting any error in browser console?

[@prashantsingh-lt4rc]

@@aapkanigam no error in console in data it is passing null

[@gipek]

venkat is det yu?

[@bilalyousuf6814]

validation is not working in this way

[@aapkanigam]

+Bilal Yousuf part 11 and 29 may be helpful for you

[@adeelzahid9622]

OK

[@Game-vi6if]

Ashish you have so much knowledge but you need to improve your speaking skills.

[@sagorfox7042]

i think its not important and its enough to us for learn... though its needed for him later....