problem with dropdownlist

Question

0.00/5 (No votes)

See more:

ASP.NET

how to fetch data from database in dropdownlist..plz help me?

Posted 21-Jun-12 22:06pm

Member 9027483

Add a Solution

Comments

db7uk 22-Jun-12 4:17am

Now this is far to general a question. What have you tried? What database are you referring to? What language are you using? All of this really helps because lack of information will mean lack of solution (or right solution). "Improve Question"

3 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)

Sandeep Mewara · Answer 1 · 2012-06-21T22:58:00

:doh:

Pick a good book or join a class to learn. If you cannot do either, just look for good learning resource on ASP.NET on web to start with. (Do tell me if you are unable to find good resource, I will share the links.)

For now, you would need to know a little about ADO.NET on how to fetch data from database. Once you know that, all you need to do is bind the datatable fetched to the dropdown and bind it.
Look at these:
Populate DropDown List from Database in ASP.NET & C#[^]
Binding DropDownList With Database in ASP.NET[^]

Vani Kulkarni · Answer 2 · 2012-06-21T22:41:00

Hello,
As you have tagged your question with ASP.Net, I am assuming that you are using ASP.Net and C# as your code behind and according I am writing the code below. See if it helps you.

Lets consider that ddlData is the DropDownList defined in aspx page, tblCompanies is the table from which you want to fetch data.

C#

protected void Page_Load(object sender, EventArgs e)
{
   if (!IsPostBack)
   {
      loadDropDown();
   }
}

public void loadDropDown()
{
   string strSelectString = @"select * from tblCompanies";
   SqlConnection conn = new SqlConnection("Server=SSK- PC\\MSSQL2008;database=*******;User ID=******;Password=*********;"); // Use your connection string here.
   conn.Open();
   SqlCommand cmd = new SqlCommand(strSelectString, conn);
   SqlDataAdapter adapter = new SqlDataAdapter(cmd);
   DataSet data = new DataSet();
   adapter.Fill(data);
   conn.Close();

   if(data.Tables[0]!= null && data.Tables[0].Rows.Count > 0)
   {
      ddlData.DataSource=data.Tables[0];
      ddlData.DataValueField = "CompanyId";
      ddlData.DataTextField = "CompanyName";
      ddlData.DataBind();
   }
}

Prosan · Answer 3 · 2012-06-21T22:43:00

this is a simple example for bind a dropdownlist to datatable

C#

private void FillDropDownList(DataTable dt)
{
    ddl.DataSource = dt.DefaultView;
    ddl.DataValueField = "DataValueFieldName";
    ddl.DataTextField = "DataTextFieldName";
    ddl.DataBind();
    ListItem item = new ListItem("Select", "-1");
    ddl.Items.Insert(0, item);
}

problem with dropdownlist

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0