how to display the data from table to dropdownlist

Question

0.00/5 (No votes)

See more:

Hi experts..............

how to fill the data from table to dropdownlist in asp.net c#

I have a table in Sqldatabase as colleges, this colleges list must be displayed in dropdownlist using code.

This is my CollegeTable

CollegeCode CollegeName
HITS Hipoint engg college
WITS Wisdom engg college
SITS Shaaz engg college
PITS Padmavathi engg college

Now i want to display collegeCodes in dropdownlist using asp.net c# code.

Please help

Thanks in @dvance.

Posted 16-Apr-13 23:14pm

Ranjith Reddy CSE

Add a Solution

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

Tejas Vaishnav · Answer 1 · 2013-04-16T23:15:00

1) Get data from your database and fill it to datatable like dtCollege

C#

SqlConnection con = new SqlConnection("");//connection name
con.Open();
SqlCommand cmd = new SqlCommand("select * from College", con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dtCollege = new DataTable();
da.Fill(dtCollege);

2) set two properties of your dropdown list

C#

//If you need to display college name to dropdown list
   ddl.DataValueField= "CollegeCode";
   ddl.DataTextField= "CollegeName";

//OR

//If you need to display college Code to dropdown list
   ddl.DataValueField= "CollegeCode";
   ddl.DataTextField= "CollegeCode";

3) then assign data-source to your dropdown

C#

ddl.DataSource = dtCollege;
  ddl.DataBind();

4) Finally code looks like this with "----Select College-----"

C#

SqlConnection con = new SqlConnection("");//connection name
con.Open();
SqlCommand cmd = new SqlCommand("select * from College", con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dtCollege = new DataTable();
da.Fill(dtCollege);
//If you need to display college name to dropdown list
ddl.DataValueField= "CollegeCode";
ddl.DataTextField= "CollegeName";

//OR

//If you need to display college Code to dropdown list
ddl.DataValueField= "CollegeCode";
ddl.DataTextField= "CollegeCode";

ddl.DataSource = dtCollege;
ddl.DataBind();
ddl.Items.Insert(0,"---Select College----");

that's it, your dropdownlist is bind with your database table data.

Sisir Patro · Answer 2 · 2013-04-16T23:29:00

Solution 2

Hi,

1st get the data from the database by a stored procedure or simply a sql command. Then keep the data into a data table and feed the datatable data to the dropdownlist.

Code snipet here:

SqlConnection con = new SqlConnection("Data Source=localhost\\sqlexpress;Initial Catalog=test;Integrated Security=True");
            SqlDataAdapter da = new SqlDataAdapter("select * from hospital", con);
            DataTable dt = new DataTable();
            da.Fill(dt);
            DropdownList.DataSource = dt;
            DropdownList.DataTextField = "CURRENCY_SHORT_DESCRIPTION";
            DropdownList.DataValueField = "CURRENCY_SHORT_DESCRIPTION";
            DropdownList.DataBind();

Thanks

Posted 16-Apr-13 23:29pm

Sisir Patro

Comments

Ranjith Reddy CSE 17-Apr-13 6:07am

This is my code, it doesnot display SELECT option.

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

private void Fill_Departments()
{
SqlConnection con = new SqlConnection(_connString);
con.Open();
SqlCommand cmd = new SqlCommand("select * from College", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
DDLCollege.DataSource = dt;
DDLCollege.Items.Insert(0, "------ Select College -----");
DDLCollege.DataTextField = "CollegeCode";
DDLCollege.DataValueField = "CollegeName";
DDLCollege.DataBind();
}

Please help,

I want to desplay --- Select college ----

but it doesnot display, please chk my code.

codeninja-C# 17-Apr-13 7:54am

Hi,
try to add insert items into ddl after data binding data into ddl
DDLCollege.DataBind();
DDLCollege.Items.Insert(0, "------ Select College -----");
--Sj

[no name] 17-Apr-13 10:15am

Change your code to as follows:
SqlConnection con = new SqlConnection(_connString); con.Open();
SqlCommand cmd = new SqlCommand("select * from College", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable(); da.Fill(dt);
DDLCollege.DataSource = dt;
DDLCollege.DataTextField = "CollegeCode";
DDLCollege.DataValueField = "CollegeName";
DDLCollege.DataBind();
DDLCollege.Items.Insert(0, "------ Select College -----");

Naveen.Sanagasetti · Answer 3 · 2013-04-16T23:46:00

Hi,

try this code..

C#

SqlConnection con = new SqlConnection("connection string");// create connection string
con.Open();   // open the connection
SqlCommand cmd=new SqlCommand("Select CollegeCode, CollegeName from CollegeTable",con);
              // call the data from database 
SqlDataAdapter da=new SqlDataAdapter(cmd); // communicate between Dataset and DB
DataSet ds=new DataSet();
da.Fill(ds); 

//Bind the result set to DropDownList 
dropdownList1. DataSource=ds.Tables[0];  
dropdownList1.DisplayMember ="CollegeName"; 
dropdownList1.ValueMember ="CollegeCode"; 
dropdownList1.DataBind();

ListItem lstSelect = new ListItem();
lstSelect.Text = "----Select----->";
lstSelect.Value = "";
dropdownList1.Items.Insert(0, lstSelect);

if you want more information regarding this refer to the below link...

http://www.codersource.net/AspNet/AspNetArticles/DropDownListinASPNet.aspx[^]

Sreenivasa Reddy G · Answer 4 · 2013-04-17T18:59:00

Try This.........

Design the DropDownList like this..

XML

<asp:DropDownList ID="ddl" runat="server">
   <asp:ListItem >Select </asp:ListItem>

Code Like this..

SqlConnection con = new SqlConnection(YourDB_connString_Here);
con.Open();
SqlCommand cmd = new SqlCommand("select * from Emp", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
ddl.ClearSelection();
ddl.DataSource = dt;
ddl.DataTextField = "EmpCode";
ddl.DataValueField = "EmpName";
ddl.DataBind();

First Clear Selection then Bind Data to ddl then automatically it shows select in ddl

how to display the data from table to dropdownlist

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0