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

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";
}
InsertData
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
class="form-horizontal">
stdimg
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
class="form-group">
@Html.LabelFor(model => model.empname, htmlAttributes: new { @class = "control-label col-md-2" })
class="col-md-10">
@Html.EditorFor(model => model.empname, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.empname, "", new { @class = "text-danger" })

class="form-group">

@Html.LabelFor(model => model.empsalary, htmlAttributes: new { @class = "control-label col-md-2" })

class="col-md-10">

@Html.EditorFor(model => model.empsalary, new { htmlAttributes = new { @class = "form-control" } })

@Html.ValidationMessageFor(model => model.empsalary, "", new { @class = "text-danger" })

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.

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/

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/

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

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

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

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();
}

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

@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????

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

10 Replies

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

Jignesh Kumar6y ago
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.
0
Rajanikant Hawaldar6y ago
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/
0
Rajeesh Menoth6y ago
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/
0
Laxmidhar Sahoo6y ago
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
0
Rahul Patil6y ago
@Laxmidhar Sahoo all inserted records are displayed but my table have 0 records. means my table has no records.
0
Laxmidhar Sahoo6y ago
hey you mean some of the records are displayed or no recors
0
Rajeesh Menoth6y ago
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();
    }
0
Rahul Patil6y ago
problem is that my record is not displayed in the database???
0
Rahul Patil6y ago
@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????
0
Laxmidhar Sahoo6y ago
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
0