# MVC 4 SQL database

Question

my model contains 1. Role_Id (primary_kye autoincrement(11)) 2. Status (dropdown bar) 3. Role_Description (text box) Problem is i hv got the value of list taken from other table column and when i select dropdown list item and enter text box value..and then save....but when i see my database...value in not inserted....

Bikesh Srivastava · Answer

Hi Kunal I 've resolved your query. see controller.I've added one other action [HttpPost] public ActionResultInsertItem(Role_Master_ModelmdFormCollectionfr) { vartemp=fr[ Status_Description ]; using (FTSdatabaseEntitiesd= new FTSdatabaseEntities()) { try { Role_Master_Tabletd= new Role_Master_Table(); td.Role_Description=md.Role_Description; td.Role_Id=md.Role_Id; td.Status=temp; d.Role_Master_Table.Add(td); d.SaveChanges(); } catch (Exceptionex) { } FTSdatabaseEntitiesdd= new FTSdatabaseEntities(); { ViewBag.Status_Description= new SelectList(dd.Status_Master_Table StatusId  Status_Description  Remarks ); return View( Role ); } } } Problem was dropdown value is not found properly in your action. Resolved....... Mark as answer if it resolved your query.

Manas Mohapatra · Answer

Debug the code first whether you are getting correct value in your code. Secondly share your code...

Manas Mohapatra · Answer

It seems it is not mentioned any controller name action in BeginForm() and you need to pass the model as to action so that you will get data in that object. Please follow link to implement the same: http://stackoverflow.com/questions/14124324/submitting-form-and-pass-data-to-controller-method-of-type-filestreamresult

Kunal Gupta · Answer

heres i have share the code

Kunal Gupta · Answer

and view is: @model vijay_dotnet.Models.Role_Master_Model @{ ViewBag.Title = Role; } @using (Html.BeginForm()) { @Html.AntiForgeryToken() @Html.ValidationSummary(true) Role Master Role Description : @Html.TextBoxFor(m => m.Role_Description) @Html.DisplayName(Status) @Html.DropDownList(Status_DescriptionSelect Status) } @Html.ActionLink(Back to List List) @section Scripts { @Scripts.Render(~/bundles/jqueryval) }

Kunal Gupta · Answer

and model is: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; namespace vijay_dotnet.Models { public class Role_Master_Model { public int Role_Id { get; set; } public string Role_Description { get; set; } public string Status { get; set; } public IEnumerable Status_Description { get; set; } //public IEnumerable Status_Description { get; set; } } }

Kunal Gupta · Answer

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using vijay_dotnet.Models; namespace vijay_dotnet.Controllers { public class RoleController : Controller { // // GET: /Role/ public ActionResult Role() { FTSdatabaseEntities d = new FTSdatabaseEntities(); { ViewBag.Status_Description = new SelectList(d.Status_Master_Table StatusId Status_Description Remarks); return View(); } } } }

Bikesh Srivastava · Answer

Hi Kunal Can you share your code ????????

#, MVC 4, SQL database