Edit And Update Modal In ASP.NET MVC

Run your application you will see All the data from database in grid like this,



When we will click on Edit link it will redirect to EDIT View and look like that,



Here you edit the data and click on Save button you will see updated value.

Updating Datamodal

Step 1: Now if we click on Save button it gives error because the edit method is using “[HttpGet]” attribute which means that this action resulting in Edit method is only accepting get request.

For updating the Edit value in database, first create the stored procedure for updating on, So Stored procedure will be like following,

Create procedure UpdateStudentInfo,

1. @StudentID int,
2. @StudentName nvarchar(50),
3. @Gender nvarchar(10),
4. @SchoolName nvarchar(50)
5. as
6. Begin
7. Update StudentInfo Set
8. StudentName = @StudentName,
9. Gender = @Gender,
10. SchoolName = @SchoolName
11. Where StudentID = @StudentID
12. End
Step 2: Now go to the BussinessLayer Library project and in BusinessLogic.cs class add a save function, For saving the data into databse.

1. public void SaveStudentInfo(Student student)
2. {
3. string connectionString =
4. ConfigurationManager.ConnectionStrings["Connect"].ConnectionString;
5. using(SqlConnection con = new SqlConnection(connectionString))
6. {
7. SqlCommand cmd = new SqlCommand("UpdateStudentInfo", con);
8. cmd.CommandType = CommandType.StoredProcedure;
9. SqlParameter studentId = new SqlParameter();
10. studentId.ParameterName = "@StudentID";
11. studentId.Value = student.StudentID;
12. cmd.Parameters.Add(studentId);
13. SqlParameter studentName = new SqlParameter();
14. studentName.ParameterName = "@StudentName";
15. studentName.Value = student.StudentName;
16. cmd.Parameters.Add(studentName);
17. SqlParameter Gender = new SqlParameter();
18. Gender.ParameterName = "@Gender";
19. Gender.Value = student.Gender;
20. cmd.Parameters.Add(Gender);
21. SqlParameter schoolname = new SqlParameter();
22. schoolname.ParameterName = "@SchoolName";
23. schoolname.Value = student.StudentClass;
24. cmd.Parameters.Add(schoolname);
25. con.Open();
26. cmd.ExecuteNonQuery();
27. }
28. }
Step 3: Go to Student Controller and add a Edit post method for updating the value. Method code will like following,

1. [HttpPost]
2. public ActionResult Edit()
3. {
4. if (ModelState.IsValid)
5. {
6. Student student = new Student();
7. UpdateModel < Student > (student);
8. BusinessLogic BL = new BusinessLogic();
9. BL.SaveStudentInfo(student);
10. return RedirectToAction("Index");
11. }
12. return View();
13. }
Step 4: Now run your application and click on edit button change the value and save it .. you will see updated value.

After saving edited value it will look like this: