Issue With Insert Record In Database In Mvc(Asp.NET)

Question

I have table in SQL Server management studio and then going to Visual Studio -> Server Explorer -> Add connection, my table is added successfully.

Problem is data is not inserted into SQL Server when I press a create button then not any error shown, I think the record is created but when I refresh in SQL Server Management Studio, in the table, the record is not displayed...

Table: empls
empid int primary key
empname varchar(50)
empsalary varchar(50)
empage int

Class:

[Table("empls")]
public class stdimg
{
[Key]
public int empid { get; set; }
public string empname { get; set; }
public string empsalary { get; set; }
public int empage { get; set; }
}

Context class is the bridge between the database and application:

using System.Data.Entity;
public class studcontext:DbContext
{
public DbSet stds { get; set; }
}

HomeController:

public class HomeController : Controller
{
studcontext _context = new studcontext();
[HttpGet]
public ActionResult InsertData()
{
return View();
}
[HttpPost]
public ActionResult InsertData(stdimg studs)
{
_context.stds.Add(studs);
_context.SaveChanges();
ViewBag.message = "data inserted successfully";
return View();
}
}

InsertData.cshtml:

@model ImageUploadUsingMvc.Models.stdimg
@{
ViewBag.Title = "InsertData";
}
<h2>InsertData</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>stdimg</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
<div class="form-group">
@Html.LabelFor(model => model.empname, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.empname, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.empname, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.empsalary, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.empsalary, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.empsalary, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.empage, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.empage, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.empage, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Create" class="btn btn-default" />
</div>
</div>
</div>
}
<div>
@Html.ActionLink("Back to List", "Index")
</div>
<script src="~/Scripts/jquery-1.10.2.min.js"></script>
<script src="~/Scripts/jquery.validate.min.js"></script>
<script src="~/Scripts/jquery.validate.unobtrusive.min.js"></script>

I already created a database in SQL Server Management Studio, and adding a database in my project successfully. But when I click on the create button, the code does not generate any errors, but after a refresh of my database, the record is not shown....

I put the viewbag.message="record successfully" the message did not display and record not display in SQL Server?

Can someone please help? What am I doing wrong?

Jignesh Kumar · Answer

Hey, Scenario 1 You gave [Table("empls")] as alias to your table stdimg. Which table are you checking in database. Check you Scenario 2 check you web config which database is referring in connectionstring name. After checking database name in config verify your table name.

Rajanikant Hawaldar · Answer

https://www.c-sharpcorner.com/UploadFile/8ef97c/mvc-5-0-application-using-entity-framework-db-first-approach/ https://www.c-sharpcorner.com/UploadFile/4b0136/database-first-approach-in-mvc-5-working-with-database/

Rajeesh Menoth · Answer

Hi, Please refer the following example then you will come to know what mistake you have done in the code. Reference: https://www.c-sharpcorner.com/UploadFile/4b0136/database-first-approach-in-mvc-5-part-2/

Laxmidhar Sahoo · Answer

I think the record is not inserted .Because the empid may duplicate for each time that is nullIn your tale dispay no auto incremet column but primary

Rahul Patil · Answer

@Laxmidhar Sahoo all inserted records are displayed but my table have 0 records. means my table has no records.

Laxmidhar Sahoo · Answer

hey you mean some of the records are displayed or no recors

Rajeesh Menoth · Answer

Hi, First of all put a "try catch" in the following code and see you are getting any error in the catch block for the following code. [HttpPost] public ActionResult InsertData(stdimg studs) { _context.stds.Add(studs); _context.SaveChanges(); ViewBag.message = "data inserted successfully" ; return View(); } If above code is inserted then the value should be appear in the db then you can return the value from the database to your respective view. But the current code is nothing to return from the db. [HttpGet] public ActionResult InsertData() { return View(); }

Rahul Patil · Answer

problem is that my record is not displayed in the database???

Rahul Patil · Answer

@Laxmidhar Sahoo context.stds.ToList() I put this index method and all records should be displayed?? but when I refresh my table all records not display????

Laxmidhar Sahoo · Answer

hey first thig you did not call ViewBag.message in the InsertData.cshtml .Secong thig try to place the code in try catch block ad display the error message for InsertData function