Add Record when clicked Save in modal popup

Hi Sachin . How i can Add record in database with below code. I am using Ado.Net.

@model IEnumerable
"button" class="btn btn-primary" data-toggle="modal" data-target="#myModal" onclick="clearTextBox();"> class="fa fa-plus"> Add New
" style="width:100%" id="tblLocation">
@Html.DisplayNameFor(model => model.Id)
@Html.DisplayNameFor(model => model.Description)
@Html.DisplayNameFor(model => model.IsActive)
Action
@foreach (var item in Model)
{
@Html.DisplayFor(modelItem => item.Id)
@Html.DisplayFor(modelItem => item.Description)
@Html.DisplayFor(modelItem => item.IsActive)
class='btn btn-primary btn-sm' id='btnEdit'>class='fa fa-pencil'> Edit
@if (item.IsActive.ToUpper() == "N")
{
class='btn btn-danger btn-sm disabled' id='btnDelete' style='margin-left:5px'>class='fa fa-trash'> Delete
}
else
{
class='btn btn-danger btn-sm' id='btnDelete' style='margin-left:5px'>class='fa fa-trash'> Delete
}
}
"~/Scripts/Appjs/Location.js">
class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
class="modal-dialog">
class="modal-content">
class="modal-header">
"button" class="close" data-dismiss="modal">"true">×class="sr-only">Close
class="modal-title">Add New Location

class="modal-body">

class="form-horizontal">

class="form-group">

class="control-label col-sm-3" for="Id">Id

class="col-sm-2">

"text" class="form-control form-control-sm" id="txtId" placeholder="Id">

step 1.

class="modal-footer">
"button" class="btn btn-primary" id="btnAdd"">Save
"button" class="btn btn-primary" id="btnUpdate" style="display:none;" onclick="Update();">Update
"button" class="btn btn-warning" data-dismiss="modal">Cancel

step 2.

step 3.

public ActionResult Save(Location model)
{
using(Sqlconnection con= new SqlConnection("yourConnectionString"))
{
SqlCommand cmd= new SqlCommand("insert into Location values(@Description,@IsActive)");
cmd.Parameters.AddWithValue(""@Description,model.Description);
cmd.Parameters.AddWithValue(""@IsActive,model.IsActive);
con.Open();
cmd.ExecuteNonQuery();
return redirectToAction("Index");
}
}

Note:- I am considering that the Id column is identity in the SQL server, if not then send the value of id as well.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.