Click here to Skip to main content
11,705,212 members (44,741 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: ASP.NET MVC
How To Add or Update Multiple Rows And Save With One Button Save Click ?

I want to be able to add or edit multiple rows then when i press save button , All changes will appear in The DataBase Smile | :)
Posted 3-May-14 23:05pm
Edited 3-May-14 23:12pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Hey Buddy,

You can refer to the following article:

Editing Multiple Records in MVC
Rate this: bad
Please Sign up or sign in to vote.

Solution 3

You can use an EditorTemplates for this. The below example shows the normal form posting example. You can ajaxify it if you need by using the serialize method and sending form values.

Assuming You need to Edit the List of Student Names for a course. So Let's create some viewmodels for that

public class Course
public int ID { set;get;}
public string CourseName { set;get;}
public List Students { set;get;}

public Course()
Students=new List();
public class Student
public int ID { set;get;}
public string FirstName { set;get;}
Now in your GET action method, you create an object of our view model, initialize the Students collection and send it to our strongly typed view.

public ActionResult StudentList()
Course courseVM=new Course();
courseVM.CourseName="Some course from your DB here";

//Hard coded for demo. You may replace this with DB data.
courseVM.Students.Add(new Student { ID=1, FirstName="Jon"});
courseVM.Students.Add(new Student { ID=2, FirstName="Scott"});
return View(courseVM);
Now Create a folder called EditorTemplates under Views/YourControllerName. Then create a new view under that called Student.cshtml with below content

@model Student
Layout = null;

@Html.HiddenFor(x => x.ID)
@Html.TextBoxFor(x => x.FirstName ) Now in our main view (StudentList.cshtml), Use EditorTemplate HTML helper method to bring this view.

@model Course


<input type="submit" id="btnSave" />
This will bring all the UI with each of your student name in a text box contained in a table row. Now when the form is posted, MVC model binding will have all text box value in the Students property of our viewmodel.

public ActionResult StudentList(Course model)
//check for model.Students collection for each student name.
//Save and redirect. ((PRG pattern)
This post has a similar MVC program which uses editor template and handles the form posting similar to the above example. You may check the sample sourcecode in the post for reference.

Ajaxified solution

If you want to Ajaxify this, you can listen for the submit button click, get the form and serialize it and send to the same post action method. Instead of redirecting after saving, you can return some JSON which indicates the status of the operation.

e.preventDefault(); //prevent default form submit behaviour
//do something with the response from the action method,

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 535
1 OriginalGriff 244
2 ppolymorphe 116
3 CPallini 82
4 Inimicos 60
0 OriginalGriff 8,988
1 Sergey Alexandrovich Kryukov 8,272
2 CPallini 5,189
3 Maciej Los 4,726
4 Mika Wendelius 3,606

Advertise | Privacy | Mobile
Web02 | 2.8.150819.1 | Last Updated 22 Jan 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100