How to bind data to dropdown?

Question

0.00/5 (No votes)

See more:

i have ddlCountryDropdown which is used to dispaly country name. I have table tblCountry which has coulmn name CountryName which i want to bind to ddlCountryDropdown at page load event.I am create one folder DTO in that i add class file MasterDTO.Cs in that i write below code using entity framework.but i don't how to bind data to dropdown at page_load event.please help me to solved my problems.

XML

public List<tblCountry> GetCountries()
       {

           List<tblCountry> d = null;
           using (var context = new HealthEntities())
           {
               d = context.tblCountries
                   .ToList<tblCountry>();

           }

           return d;
       }

Posted 6-Feb-13 23:47pm

Manohar Khillare

Add a Solution

2 solutions

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)

Wasim1989 · Answer 1 · 2013-02-07T00:02:00

Solution 1

try this..
add this code in your page_load event.

C#

MasterDTO obj = new MasterDTO;
ddlCountryDropdown.DataSourse = obj.GetCountries();
ddlCountryDropdown.DataTextField = "CountryName"; // for display
ddlCountryDropdown.DataValueField = "CountryId";  // for value u can bind country id if you have. other wise assign countryName.
ddlCountryDropdown.DataBind();

hope this will work...

Posted 7-Feb-13 0:02am

Wasim1989

Comments

Manohar Khillare 7-Feb-13 7:07am

This give me error "The underlying provider failed on Open." at MasterDTO.Cs
d = context.tblCountries.ToList<tblCountry>();

Wasim1989 7-Feb-13 7:13am

do you check your table properly mapped to your entityclass?

Wasim1989 7-Feb-13 7:17am

try this..
IQueryable<tblCountry> iList= dataModel.tblCountry;
List<tblCountry> countryList = iList.ToList();

Manohar Khillare 7-Feb-13 7:33am

where this code is need to place

Wasim1989 7-Feb-13 7:36am

public List<tblCountry> GetCountries()
{
using (var context = new HealthEntities())
{
IQueryable<tblCountry> iList= context.tblCountry;
List<tblCountry> countryList = iList.ToList();
return countryList;
}
}

Manohar Khillare 7-Feb-13 7:50am

again it showing me same error

Wasim1989 7-Feb-13 7:53am

you should refer those links which i posted in second answer.

Wasim1989 · Answer 2 · 2013-02-07T01:33:00

Solution 2

try this link.

* http://blogs.msdn.com/b/dataaccesstechnologies/archive/2012/08/09/error-quot-the-underlying-provider-failed-on-open-quot-in-entity-framework-application.aspx[^]

* http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/091b1eac-4ed6-43b8-b184-a713d1f2b9eb/[^]

Posted 7-Feb-13 1:33am

Wasim1989

Comments

Manohar Khillare 7-Feb-13 7:40am

Wasim sir i m not getting output.