forum

Home / DeveloperSection / Forums / Populating drop down list from the database

Ask Question

Populating drop down list from the database

Anonymous User 1704 17-Nov-2014

I used this c# code to add items in dropdownlist(ddlSub) from the table sub_info. But what I want is to add the value of the items in dropdownlist(ddlSub) from the same table which also has a column named sub_id of datatype varchar(50). 

private void bind_ddlSub()
{
 
    ddlSub.Items.Insert(0, "-Choose-");
    datatable_object = methodClassFunc.getData("select sub_name from sub_info");
    for (int i = 0; i <= datatable_object.Rows.Count - 1; i++)
    {
        ddlSub.Items.Add(Convert.ToString(datatable_object.Rows[i]["sub_name"]));
    }
}

asp.net asp.net 
Updated on 17-Nov-2014
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Sumit Kesarwani

Sumit Kesarwani

17-Nov-2014
Hi Jay, 

You can use the ListItem object to add text and value for a dropdownlist item.

string subname =datatable_object.Rows[i]["sub_name"];
string subid = datatable_object.Rows[i]["sub_id"];
ddlSub.Items.Add(new ListItem(subname,subid));
Or you can bind your datasource like this:
ddlSub.DataSource = datatable_object;
ddlSub.DataTextField = "sub_name";
ddlSub.DataValueField = "sub_id";
ddlSub.DataBind();

Liked By