Part 13- Insert data into MULTIPLE TABLES in an ASP.NET MVC application

Good

nice work dear friend

Im really really battling with trying to update/edit this, can anyone help me...im so desperate for help

Ashish, did it break ACID properties or not like somehow by any chance if system shuts down between the transaction of two table like if it add record only in employee table and shuts down so it creates extra or unecessary row in employee table correct me if i am wrong plz help me out with this if u have any solution

Hi Ashish, I need your help.
You added 3rd table Site and made relationship with employee. Now how can we show site name with employee details when we click on any employee ?

Your tutorial is the best to help the beginners, it helped me in my university project.

thanks you Ashish, you doing a great work. Simple and straightforward

@Technotips - Ashish
How come you are adding Test in url:"/Test..." I do not understand where have you defined it. Do you have this file downloadable?
How can we use ajax controller without defining <form>?

this was really helpfull many thak's

This was really helpful to me, Thank you so much - John, I will subscribe

I was having a nightmare with a Uni project and this tutorial was everything I needed to overcome the problem. Many thanks

How i can save data in multiple tabels in plane mvc no any entity model plz tell me.

how to assign view page ?,give the sytax for html helper of two table in one view page

NOW how to view them ?

hi ashish love this tutorial but update the multiple tables is giving me error that primary key siteId__EmployeeId conflicting somehow please how did you do the database coz when i did my own database i created EmployeeId with identity(1,1) and so for SiteId

Why are you calling the properties in your EmployeeViewModel //Custom attribute

Hi I have a problem When insert data it has been inserted in to database but Ajax is not success when I debug it throw return undefined but data already go to database and when I debugged controller I saw it return some value I don't know what happened and I use only one table so I have been wrote code for a table

Hi Ashish Please can you show how you create the relationship for the database because when i create my own i was having this following error on my database when i want to initialize first value into site table.
This is how i created my database:Please anyone to show me the answer if am wrong,
create table Site
(
SiteId int primary key NOT NULL,
EmployeeId int NOT NULL references Employee,
SiteName varchar(30) NOT NULL
);

insert into Site(SiteId,EmployeeId,SiteName) values(1,1005,'google.com');

This is the error i got:
Msg 547, Level 16, State 0, Line 8
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__Site__EmployeeId__239E4DCF". The conflict occurred in database "MVCTutorial", table "dbo.Employee", column 'EmployeeId'.
The statement has been terminated.

super

Awesome Video....Keep posting other videos.....

Please tell me how to disable back button of browser after inserting record.

hello, i got this problem, could you explain to me please?

Se produjo una excepción de tipo 'System.InvalidOperationException' en System.Web.Mvc.dll pero no se controló en el código del usuario

Información adicional: El elemento ViewData con la clave 'DepartmentId' es de tipo 'System.Int32' pero debe ser de tipo 'IEnumerable<SelectListItem>'.

-------------------------------
the problem is located at the index view

@Html.DropDownListFor(model=>model.DepartmentId, ViewBag.DepartmentList as SelectList, "Select", new { @class="form-control"})

i have tried everything and nothing

Very useful tutorial

Very useful tutorial

Very useful tutorial

Hello Ashish first thank you for your support in this corse .. everything is so helpful .. i have problem .. to models with one to many relationship .. how i can update from one view for example first model is car details and second is car options many options so i have two kind of data in one view single and IEnumerable how i can fix that please

Technotips - Ashish: Field EmployeeId in table Employee is primary key. How you add EmployeeId = 1005 ?

Hi Ashish. This runs perfectly for me. However, I get an error when I try editing. Any tips?

Thanks for awesome video

How can you do the same without using entity framework?

Ashish, you are an amazing guy in our world. I respect you. Your ASP .NET MVC tutorials really helped me a lot. Best Regards: Attila from Hungary, Europe

Hi, This video is so helpful, can you update video on how to edit data in multiple tables. Thank you.

Hi, I run this and it's working but every record inserted twice into employee and site tables can you help plz ??

Hi. How are you inserting employee ID?

Re-record and show all files missing to many steps or just add all file pages to your blog.

Hi Ashis Getting Error while Inserting into "Site" Table ..Could you please help??

Hi Ashis..a small Query.......Please help........Is there any relationship define between Employee and Site ID while generating Model class from Data Base as like previous(Between Employee and Department ) ?

Hi Ashish, any thoughts on saving data into multiple SQL db tables which the data is derived from multiple HTML tables that are dynamically created? I'm currently getting all the data using a model and viewbags along with info the user will provide. My thought was to build array's of the data and pass it to the controller with json or ajax.

Hi Ashish ,how you add Site table from database to MVCTutorialModel

Error 1 Non-invocable member 'ProjectDataAccess.customer.email' cannot be used like a method. C:\Users\DeLL\documents\visual studio 2013\Projects\WebService1\WebService1\Controllers\CustomerController.cs 45 39 WebService1
need help..

thank you very much

Its very good tutorial. but i need to get div values view to contoller model class.. please help me.. Thank you..

Hi, ashish its better to teach how to create the tables that which we are going to use this video, for ex: you used new table here called Sites, is there any relation b/w sites & Employees table?

Excelente Tutorial

in this vedio which one is forign key ? i mean only departmentID or both departmentID and EmployeeID?

hi sir your video is vary great can you teach how to loagin 3rd party thr login in mvc application