Multiple Row insert in Asp.net.core

Question

How can I insert multiple row in database and use ajax and it use query Asp.net.core

Siddharth Gajbhiye · Answer

public class DBM2BillingViewModel { public List databaseM2List { get ; set ; } [Display(Name = "Items" )] public string Name { get ; set ; } [Display(Name = "PO Item No." )] public int POItemNo { get ; set ; } [Display(Name = "Date of Effect" )] public DateTime DateOfEffect { get ; set ; } [Display(Name = "Baseline Volume" )] public float baselineVolume { get ; set ; } [Display(Name = "Billing Month" )] public string BillingMonth { get ; set ; } [Display(Name = "Monthly Device Count" )] public float DeviceCount { get ; set ; } } **Controller** //Get Method public IActionResult Create() { DBM2BillingViewModel dbm2billingVM = new DBM2BillingViewModel(); dbm2billingVM.databaseM2List = _context.databaseM2s.ToList(); return View(dbm2billingVM); } //Post Method [HttpPost] [ValidateAntiForgeryToken] public IActionResult Create(DBM2BillingViewModel model) { foreach (var dbm2 in model.databaseM2List) { DeviceBilling addModel = new DeviceBilling(); addModel.Name = dbm2.Name; addModel.TrackName = "Database M2" ; addModel.POItemNo = dbm2.POItemNo; addModel.DateOfEffect = dbm2.DateOfEffect; addModel.baselineVolume = dbm2.BaselineVolume; addModel.BillingMonth = model.BillingMonth; addModel.DeviceCount = model.DeviceCount; _context.deviceBillings.Add(addModel); } _context.SaveChanges(); return RedirectToAction(nameof(Index)); } enter code here View @model FinancantPro.Models.DeviceCountModel.DBM2BillingViewModel @{ ViewData[ "Title" ] = "Create" ; } class = "container" > class = "table table-striped border" > class = "table-info" > @Html.DisplayName( "Item Name" ) @Html.DisplayName( "PO Item No#" ) @Html.DisplayName( "Date Of Effect" ) @Html.DisplayName( "Baseline Volume" ) @Html.DisplayName( "Billing Month" ) @Html.DisplayName( "Device Count" ) @ for ( int i = 0; i { @Html.HiddenFor(d => d.databaseM2List[i].Id) @Html.DisplayFor(d => d.databaseM2List[i].Name) @Html.DisplayFor(d => d.databaseM2List[i].POItemNo) @Html.DisplayFor(d => d.databaseM2List[i].DateOfEffect) @Html.DisplayFor(d => d.databaseM2List[i].BaselineVolume) @Html.TextBoxFor(d => d.BillingMonth, new { @ class = "form-control" }) @Html.TextBoxFor(d => d.DeviceCount, new { @ class = "form-control" }) } class = "form-group" > "submit" class = "btn btn-primary" value= "Create" /> ************************** If I add list in View I am not able to resolve the Model Reference link: https://stackoverflow.com/questions/53452180/how-to-insert-multiple-rows-database-in-asp-net-core-2-1

Nazneen Saiyed · Answer

in Controlller [HttpPost] [ValidateAntiForgeryToken] public IActionResult Create(CreateModel model) { CreateModel addModel = new CreateModel(); addModel.param1 = model.param1; addModel.param2 = model.param2; addModel.param3 = model.param3; addModel.param4 = model.param4; _context.CreateModel.Add(addModel); _context.SaveChanges(); return RedirectToAction(nameof(Index)); }

Ecco Suprastyo · Answer

Hello, you can use method this for insert data : 1. In controller [HttpPost] [ValidateAntiForgeryToken] public IActionResult Create(CreateModel model) { CreateModel addModel = new CreateModel(); addModel.param1 = model.param1; addModel.param2 = model.param2; addModel.param3 = model.param3; addModel.param4 = model.param4; _context.CreateModel.Add(addModel); _context.SaveChanges(); return RedirectToAction(nameof(Index)); } 3. In Javascript function save(param1, param2 param3, param4) { var sendvalue = { MODEL: param1, MODEL: param2,MODEL: param3, MODEL: param4 }; $.ajax({ type: 'POST' , "url" : "/controllername/Create" , contentType: "application/json; charset=utf-8" , "datatype" : "json" , data: JSON.stringify(sendvalue), success: function (data) { alert( 'successfully saved' ); }, error: function () { alert( "Error while inserting data" ); } }); }

Multiple Row insert in Asp.net.core

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)