are there cmd.executescalar property for MVC? RSS

• • Reply
  

  esmerman

  Member

  24 Points

  73 Posts

  are there cmd.executescalar property for MVC?

  Mar 31, 2012 07:39 PM|LINK

  Hi,
  In my PersonController;
  
  // GET: /Person/Details/5
  public ActionResult Details(int id = 0)
  {
  tblPerson tblperson = db.tblPersons.Find(id);
  if (tblperson == null)
  {
  return HttpNotFound();
  }
  var gender = (from tblPerson in db.tblPersons
  where tblperson.Id == id
  select tblPerson.Gender).ToString();
  if (gender == "1")
  {
  ViewBag.GenderID = "Male";
  }
  return View(tblperson);
  }
  
  And Details.cshtml
  <div class="display-field">
  @Html.DisplayFor(model => model.Gender)
  </div>
  I want to display "Male" if gender is equal to 1, else display "Female" in my view page.
  Any help will be appreciated.

• • Reply
  

  ignatandrei

  All-Star

  137556 Points

  22120 Posts

  Moderator

  MVP

  Re: are there cmd.executescalar property for MVC?

  Mar 31, 2012 07:54 PM|LINK

  esmerman

  are there cmd.executescalar property for MVC?

  MVC is database agnostic.

  Please see http://msprogrammer.serviciipeweb.ro/2010/03/29/asp-net-mvc-orm-and-viewmodels/

  esmerman

  I want to display "Male" if gender is equal to 1, else display "Female" in my view page

  Put selectlist with 2 selectlistitem - Male 1,Female 0

  And next time please differentiate the subject question with the body question - make 2 threads.

  My .NET blog : http://msprogrammer.serviciipeweb.ro/ |2012 Programmer tools
• • Reply
  

  esmerman

  Member

  24 Points

  73 Posts

  Re: are there cmd.executescalar property for MVC?

  Mar 31, 2012 08:48 PM|LINK

  I'm sorry but i can not figure out how to Put selectlist with 2 selectlistitem - Male 1,Female 0

  Any more help please. 

• • Reply
  

  ignatandrei

  All-Star

  137556 Points

  22120 Posts

  Moderator

  MVP

  Re: are there cmd.executescalar property for MVC?

  Mar 31, 2012 09:04 PM|LINK

  var genre=new List<KeyValuePair<int,string>>()

  genre.Add(new KeyValuePair<int,string>>(0,'female'));

  genre.Add(new KeyValuePair<int,string>>(1,'male'));

  SelectList sl=new SelectList(genre,"Key", "Value");
  http://msdn.microsoft.com/en-us/library/dd505286.aspx#Y0

  My .NET blog : http://msprogrammer.serviciipeweb.ro/ |2012 Programmer tools
  • Marked as answer by esmerman on Mar 31, 2012 09:33 PM
• • Reply
  

  esmerman

  Member

  24 Points

  73 Posts

  Re: are there cmd.executescalar property for MVC?

  Mar 31, 2012 09:34 PM|LINK

  Thank you very much

  Best regards