How we can use ASP.NET MVC Framework check this post
In the above Post example I have used ADO.NET to insert the data in SQLServer Db (Student Table)
Now In this post I 'll Insert and Update Data in Student_Marks table(Student_id,Marks)in One More view
Using ADO.NET Entity framework.
1.) Creating the ADO.NET Entity Data Model
Check the below post to create ADO.NET Entity Data Model.
2.) We will Add Our Form AddStudentMarks within the same App
3.)Right click on Models Add new class StudentmarksModel.cs
4.)Code On StudentMarksModel.cs Create property corresponding to each Form Field + Write the Validation
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.Web.Mvc;
namespace TestMVCapplication.Models
{
public class StudentMarksModel
{
[DisplayName("Marks")]
[Required(ErrorMessage = "* Required")]
public string Marks { get; set; }
public string Student_Id { get; set; }
public IEnumerable<SelectListItem> StudentList { get; set; }
}
}
5.)We’ll then add a “StudentMarksController.cs” controller class to our project's Controllers folder that exposes two “AddStudentMarks” action methods.
The first action method is called when an HTTP-GET request comes for the /StudentMarks/Create URL. It will display a blank form for entering Student data.
The second action method is called when an HTTP-POST request comes for the /Studentmarks/Create URL. It maps the posted form input to a StudentMarks object, verifies that no binding errors occurred, and if it is valid will eventually save it to a database(Business Logic)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Data.Objects;
using TestMVCapplication.Models;
namespace TestMVCapplication.Controllers
{
public class StudentMarksController : Controller
{
//
// GET: /StudentMarks/
[HttpGet]
public ActionResult AddStudentMarks()
{
TestMVCEntities3 DBobj = new TestMVCEntities3();
//ViewData["StudentList"] = new SelectList(DBobj.Student, "Student_Id", "Name");
//return View();
//To set the Student Names in DropdownList
var model = new StudentMarksModel();
model.StudentList = new SelectList(DBobj.Student, "Student_Id", "Name");
return View(model);
}
[HttpPost]
public ActionResult AddStudentMarks(StudentMarksModel model)
{
//Add Data Using Entity Framework in ADO.NET
TestMVCEntities3 DBobj = new TestMVCEntities3();
int StudentId = Convert.ToInt32(model.Student_Id);
//Check If the reord exists with the Dropdownlist selcted value as Student_Id
var record = DBobj.Student_Marks.FirstOrDefault(m => m.Student_Id == StudentId);
//If record exists update it with the value entered in marks textbox
if (record != null)
{
Student_Marks e = (from e1 in DBobj.Student_Marks
where e1.Student_Id == StudentId
select e1).First();
e.Marks = int.Parse(model.Marks);
DBobj.SaveChanges();
}
//If record doesn't exists Insert the new record
else
{
Student_Marks sMarks = new Student_Marks();
sMarks.Student_Id = int.Parse(model.Student_Id);
sMarks.Marks = int.Parse(model.Marks);
DBobj.AddToStudent_Marks(sMarks);
DBobj.SaveChanges();
}
//To set the Student Names in DropdownList
var modelsend = new StudentMarksModel();
modelsend.StudentList = new SelectList(DBobj.Student, "Student_Id", "Name");
return View(modelsend);
}
}
}
7.)After we’ve implemented our controller, we can right-click within one of its action methods and choose the “Add View” command within Visual Studio – which will bring up the “Add View” dialog
Add AddStudentMarks.aspx view file for us under the \Views\StudentMarks\
8.)Design the form on AddStudentMarks.aspx using HTMlHelper Class
