how to bind dropdownlist with database value. [Resolved]

Hi...

Here i have give the code to bind the database value to dropdownlist.

ddlCategory.Controls.Clear();
ddlCategory.DataSource = dsCategory.Tables[0];
ddlCategory.DataTextField = "Category";
ddlCategory.DataValueField = "CategoryID";
ddlCategory.DataBind();

Regards,

Joewilliam, if this helps please login to Mark As Answer. | Alert Moderator

public void bind()

{

 sqldataadapter da=new sqldataadapter("select col1,col2 from table",cn);

dataset ds=new dataset();

da.fill(ds);

dropdownlist1.datatextfield="col1";

dropdownlist1.datavaluefield="col2";

dropdownlist1.datasource=ds;

dropdownlist1.databind();

}

Thanks&Regards
LakshmiNarayana Nalluri.

Joewilliam, if this helps please login to Mark As Answer. | Alert Moderator

Hi Joewilliam,

I have written this article just for you http://www.dotnetfunda.com/articles/article1435-how-to-bind-dropdownlist-with-database-value-.aspx and others who may have the similar scenario.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Joewilliam, if this helps please login to Mark As Answer. | Alert Moderator

dropdown1.DataSource = datasourcename.Tables[0];

dropdown1.DataTextField = "Name";

dropdown1.DataValueField = "ID";

dropdown1.DataBind(); 

...

Joewilliam, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

http://www.dotnetfunda.com/forums/thread4161-how-to-bind-database-table-to-dropdownlist-value.aspx

Regards,
Susan

Joewilliam, if this helps please login to Mark As Answer. | Alert Moderator