Part 11- Insert data into database in ASP.NET MVC | Submit a Form and Save Record | HD Video

[@SergeyChaschin]

Lad, please, either pause your Avast during your videolectures or provide a dislaimer that this video may be harmful for people with heart problems (or they can get those at 6:51). I've lost a month of life at 6:51 and still have this bell ringing in my head. Speaking about the lecture itself -- thanks a lot, well done. But a thrilling one :).

[@aapkanigam]

Oh sorry for the inconvenience.. at starting, I did not have idea about how it can put impact on people and left it as it is. Please don't watch part 10 also .. it's more hilarious😂

[@carloscatral]

😂😂😂😂

[@GlassScissors]

Great tutorial, but Ashish you scared the living !@$% out of me with that Avast notification. :D

[@saurabhvarma29]

@@aapkanigam speaker per tha laptop....main bhi ek baar darr gya tha..hahahahhahaha

[@AyoubElAlaouiX_O]

@@aapkanigam You can actually add a note on the video so the viewers can watch out

[@seanpereira5824]

This is just what I needed to get my confidence back..god bless you mate..do this with music in ur ears..works like a charm bro!!

[@dafringe]

Excellent tutorials, thus far. Thank you for taking the time to make these videos!

[@aapkanigam]

Thanks .. keep learning and sharing

[@albasula216]

Damn the noise ...I actually was watching this in 1am ...falling asleep...well, I am awake and scared hahaah

[@sambaskw]

Super dear...

[@veeramuthudotnetveera]

It s very useful for me.i am expecting more videos like this. Thank you

[@aapkanigam]

+veera muthu thanks . Please refer playlist. There are 37 videos on mvc

[@numairazher1755]

Thanks!... you helped me to solve an error!

[@marcinedoza7507]

Thank you very much Ashish, this really help me alot.

[@aapkanigam]

Thanks keep learning and sharing 🙏

[@olabodebowoto1442]

Thanks a lot.very informative and precise training approach.

[@aapkanigam]

Thanks ..keep learning and sharing

[@ilkerdoner]

sir really perfect Tutorials thank you for that u r really big king :)))

[@Rajesh-rg6fw]

I saw a lot of videos but this is really nice. 100 out of 100. I have a request, please make the same page using MVC,Restfull web api and with the ajax call.

[@josereynelchauxperez947]

Excelente material, muchas gracias !!!

[@Savariya91]

Perfect tutorial

[@rodelcrisosto499]

6:51 This thing shocked the hell out of me. 🤣

[@iftekharahmad4966]

ya it is very usefull for me...sir

[@againstallodds611]

thank you. It is very helpful.

[@aapkanigam]

+Againstallodds Thanks ..keep learning and sharing

[@a1checkm8]

Thank You, worked perfectly.

[@a1checkm8]

How would i insert multiple rows of data with a single submit button?

[@excellins]

nice video. thanks for this

[@danielnallapujoseph]

Thank you - Helped me a lot

[@aapkanigam]

+Daniel Nallapu if u find this useful then please share it ..

[@navzme]

Thanks for awesome video

[@TheTallyhoviper]

Hey Ashish, Thanks a lot for Good Tutorial, I'm Sory i have a little Problems, when i use try and catch code, its return me this Errors when i click submit. "System.Data.Entity.Validation.DbEntityValidationException: Validation failed for one or more entities. See 'EntityValidationErrors' property for more details. " Can you give me some advice for this erros, i've been searching for the solutions and those solution wasnt works for me.

[@razvanboldor1758]

Yeeeeeeahhh, veeeery goooood maaaan !

[@canadaimmigrationlife]

Hey did you find the solution ?

[@ayoforyou448]

many thak's

[@Pendyalakirit]

Hey, Could you explain to me what is MVC Tutorial Entities in the controller?

[@fkkk287]

yes, please...

[@abhinavkumar8271]

Very good

[@prayogamaturangga4494]

Please silent that avast notif. it almost kill me at 3 AM By the way thanks, sooo useful

[@mucahidakyar766]

Thank you so much for your videos I have a question ,when i write part of "int latestEmpId = emp.EmployeeID;" i take error of dupplicate to primary key what should i do?

[@timmarapao8005]

same problem

[@betalaprasanth2420]

Don't write that code if you have declared as primary key and used Identity

[@ruchimodi2214]

thank you for the video tutorials.it is really great help I have doubt for the same employee_id. one time record is inserted but second time it shows error.What to do for the same.

[@aapkanigam]

+Ruchi Modi Make sure your employeeId should be set auto incremented while creating db table. part 26 will help you to create db table

[@Ruhgtfo]

Cool

[@heshammhawach]

When i go to my table definition it doesnt show the same class like yours it shows a partial class " public partial class ShippingDetails" is it okay to use it anyways?

[@abdulmateen9037]

wtf was that avast notification...scared the hell out of me

[@yogeshsinghrawat5093]

sir when i try to save my record its done only one time...coz the id become zero then after it was been error when i was enter another data..the exception name is=DbupdateException was unhandled by user

[@aapkanigam]

+yogesh rawat you cant update the autogenerated primary key ..make sure you are not updating id

[@yogeshsinghrawat5093]

sir it shows only like employeeId Name DepartmentId Address 0 rob 3 London iam trying to that id is the latest id ...bt it can't...

[@EduardoHernandez-ux6gg]

going two models insert?

[@abdulmubeen5246]

hello sir, all are goes right.till maka a form. when i add @using(html.beginform("save","controller",formmethod.post()). it throws an error i.e: argument 3 cannot convert from anonymous type string class string placeholder to string.

[@keanemgl]

Hi. When submit record i got this error Violation of PRIMARY KEY constraint 'PK_Employee'. Cannot insert duplicate key in object 'dbo.Employee'. The duplicate key value is (0).

[@aapkanigam]

+Ariunbat Ulambayar make your primary key column auto incremented. watch part 26 to create table and setting keys

[@keanemgl]

i set id autoinc and reinserted employee edmx and it worked TY

[@jimbroottanjimbru418]

Hey, could you please make a tutorial on creating a "Simple audio recorder and save it to database". Just need "Start and Stop" button. Thanks :)

[@aapkanigam]

+Jimbroottan Jimbru I have worked on creating audio record but I was using licenced script . I hope I would get thats free version and make tutorial on that

[@jimbroottanjimbru418]

Thank you. When you finished. Please let me know

[@kuldeepkumar-en1fk]

Sir, why you create employeeviewmodel class because i have already employee class

[@aapkanigam]

+kuldeep kumar coz employee class is volatile .. when you modify table schema then you have to update your model properties using EF. So its good to create viewmodel which will be dedicately used by view. Hence your view page will not be effected after updating model from entity framework

[@saikiranmaddipatla]

please post upload large video files into database and retriving in asp.net mvc

[@wahajzafar6568]

Hi Mr,Ashish i am facing a big problem in that actually i am working with 3 to 4 forms in single view cs.html file the form is present in modals (pop-up's) its giving me div element error what can i do?

[@aapkanigam]

Part 15 and 20 can help you

[@shazzThing]

what is MVCTutorialEntities in the project i cant understand?? please reply fast i am waiting for your answer.

[@isaacige]

That's the name of the Entity relationship framework

[@bhaskarkholiya8125]

hii, ashish sir why i am getting EmployeeID as 0, as my Employee table is already having 5 records, record is insert as first row in table

[@aapkanigam]

+Bhaskar Kholiya please check its datatype. Is it int?

[@bhaskarkholiya8125]

yes,

[@bhaskarkholiya8125]

yes, also i made my primary key as identity now code is not inserting values for identity column

[@aliridhohabsyi1242]

Hi Ashish i got a problem with insert data cause that's Cannot insert explicit value for identity column in table 'Employee' when IDENTITY_INSERT is set to OFF. i have already set of the EmployeeID to auto increment with set "yes" the identity specification on sql server. Please help what should i do ??

[@aapkanigam]

+Ali Ridho Habsyi part 26 might help you to create table with primary key and setting autoincrement, and foreign key

[@muhammadazeem7395]

I just want to ask, what is Employees in this db.Empolyees.Add.(emp); ??

[@bhaskarkholiya8125]

hii, ashish sir why i am getting EmployeeID as 0, as my Employee table is already having 5 records, record is insert as first row in table , also i made my primary key as identity now code is not inserting values for identity column

[@wymowaiyan6505]

Did you specify identity specification = true?

[@trr5088]

How can I update the previous MVCTutorial database to the one used in Lesson 11. I have tried running the scrip with the provided code but always say that information is already present. When trying to build this project I get an error involving a foreign key, so I must be doing something wrong on this. Can anyone offer suggestions?

[@aapkanigam]

please first drop your database then run the script.Also you need to refresh you entity framework .

[@raihan8935]

while i click on submit button it's inserting data at the top of my database, why is this happening. please comment for help because i can enter only one data shows exception while inserting another.

[@aapkanigam]

make sure your table id is set to auto increament.

[@mohitjoshi7587]

I have done the code same as told by you but I m getting an exception of EntityValidationException. Kindly provide solution to solve this exception.

[@mohitjoshi7587]

Kindly reply ASAP because I need solution on urgent basis

[@babugenerous9034]

how pass array of data to controller from form i.e one transsection have many product like this. how i do it ??

[@adeelclever98]

I am getting an exception at throw statement "System.Data.Entity.Validation.DbEntityValidationException: Validation failed for one or more entities. See 'EntityValidationErrors' property for more details. "

[@4030yes]

me too, do you found the solution?

[@shiyin5413]

Hi there, i follow your steps, but my record doesnt save... i cannot find the error please help me

[@shiyin5413]

when i hover to the model, i cannot get the parameter like you do... what is the problem

[@aapkanigam]

+shi yin did you try the code available on blog?you can get the code link from video description. That might help you

[@shiyin5413]

I didn't use the database exactly like yours..i got mine...but all the steps are all the same..just the data is not the same..is there anyway to track the error?

[@shiyin5413]

i still having the same problem...entity framework just not saving without error

[@aapkanigam]

+shi yin are u able to debug code

[@akifstagram6831]

Guys, Can someone explain why do we make it equal "latestEmpId" to "emp.EmployeeId" ?

[@Hawkingxx]

MVCTutorialEntities WHAT IS?

[@aapkanigam]

Checkout you connection string name and create the object with same name. It's the name of the class that consists db sets for each entity

[@Hawkingxx]

+Technotips - Ashish I thought that was it and finally I adapted it to my own code but not in the same way. thanks you, i progress so much in my programm. i have question ¿Is not it necesary to use query for insert?

[@aapkanigam]

Yes , entity framework has different way to insert data .. you need to use only entity queries to insert update delete etc

[@Swayybot]

AVAST VIRUS DATABSE HAS BEEN UPDATED

[@Triveni-01]

how to insert data using asp.net mvc without using entity framework and it has to store in database please help me anyone,,,,,for

[@aapkanigam]

Using ado .net you can save the data.

[@doratoadriano]

How many "OK" you have said!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@namnguyenvan1711]

the sound is not good I am quite disappointed

[@false4207]

Wtf with the anti virus stuff. Come on man!!! Lame