How to read a specific field in ADO.NET Entity Data Model Object on Postback event

Question

0.00/5 (No votes)

See more:

I have a dropdownlist that is populated from a database as:

Controller

C#

PayrollDb pdb = new PayrollDb ();
var addBranchGui = new branch();
addBranchGui.BranchTypes = new SelectList(pdb.branchtypes,"Id", "Type");

View

HTML

<p>Branch Type:@Html.DropDownListFor(x => x.BranchType, Model.BranchTypes, "Choose an option")</p>

This codes correctly populates the dropdownload list. Problem arises when user selects an option in the dropdownlist and submits the form and I catch the input data on [HttpPost action method and insert it into a database table, it is the "Id" field that gets inserted when I want the "Type" field to be inserted.

I can understand that on Postback event, browsers is reading "Id" field. Can someone please guide me how I can command the browser to give me the "Type" field so I can insert that into database.

Posted 8-Dec-15 8:39am

rf_libra

Add a Solution

Comments

Suvendu Shekhar Giri 8-Dec-15 14:49pm

share the relevant code where you are fetching data from the form for insertion.

[no name] 8-Dec-15 15:18pm

Answer is:

addBranchGui.BranchTypes = new SelectList(pdb.branchtypes,"Type", "Type");

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

rf_libra · Answer 1 · 2015-12-08T09:23:00

In the SelectList constructor, you are specifying Id as the data value field for the dropdown.

C#

addBranchGui.BranchTypes = new SelectList(pdb.branchtypes,"Id", "Type");

So it will render the dropdown like this

HTML

<select name="BranchType">
   <option value="2">HeadOffice
   <option value="4">Branch
</option></option></select>

So change it to use Type as the datavalue field.

C#

addBranchGui.BranchTypes = new SelectList(pdb.branchtypes,"Type", "Type");

This will render a SELECT element with same value for the option value and the option text

HTML

<select name="BranchType">
   <option value="HeadOffice">HeadOffice
   <option value="Branch">Branch
</option></option></select>

Now when user posts the form, you will get the text value(the type) in BranchType field.

How to read a specific field in ADO.NET Entity Data Model Object on Postback event

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us