How insert selected drop down value in database

suman goud

am binding values to drop down from database, but when am inserting selected value again in db am getting error 'object ref not set to instance of obj'

my model

public class ReceiptsViewModel

{

public String Branch { get; set; }

public string Currency { get; set; }

public SelectList CustomerListModel { get; set; }

public SelectList AccountListModel { get; set; }

}

controller

public ActionResult Index()

{

ReceiptsViewModel objCustomermodel = new ReceiptsViewModel();

TestDemoEntities objentity = new TestDemoEntities();

List objCus = (objentity.MasterNodes.Where(x => x.Type == "Master")).ToList();

MasterNode objCustomer = new MasterNode();

objCustomer.Name = "Select";

objCustomer.EmpID = 0;

objCus.Insert(0, objCustomer);

SelectList CustomerList = new SelectList(objCus, "EmpID", "Name");

objCustomermodel.CustomerListModel = CustomerList;

return View(objCustomermodel);

}

view

@Html.DropDownListFor(u => u.Account, Model.AccountListModel, new { @style = "width:150px;height:22px;", @id = "ddlAccount" })

am getting error here

Object reference not set to an instance of an object.

how to insert selected value in database

2 Replies

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

Rajendra Mote10y ago
Yur are using Entity framework. so you need to use Dbcontext to initialise then perform operation for further information check ViewModel + entity framwork dboperation
Bikesh Srivastava10y ago
Hi Suman,
You are doing something wrong,beacause you are not able get selected data from view.
on controller use like this.
publicActionResultRole()
{
FTSdatabaseEntitiesd=newFTSdatabaseEntities();
{
ViewBag.Status_Description=newSelectList(d.Status_Master_Table,"StatusId","Status_Description","Remarks");
returnView();
}
}
[HttpPost]
publicActionResultInsertItem(Role_Master_Modelmd,FormCollectionfr)
{
vartemp=fr["myval"];
using(FTSdatabaseEntitiesd=newFTSdatabaseEntities())
{
try
{
Role_Master_Tabletd=newRole_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=newFTSdatabaseEntities();
{
ViewBag.Status_Description=newSelectList(dd.Status_Master_Table,"StatusId","Status_Description","Remarks");
returnView("Role");
}
}
}
On view use like this code:-
class="col-md-3">
@Html.DropDownList("Status_Description",newSelectList(ViewBag.Status_Description,"Value","Text"),new{@onchange="setVal()"})
"hidden"id="myval"name="myval"/>
//////////////////////////////////////
"text/javascript">
functionsetVal()
{
$("#myval").val($("#Status_Descriptionoption:selected").text());
}