DropDownList

[Rodrigo Ferreira]

Hello,

How can i fill a dropdownlist with data returned by the database?

My code is:

string strsql = "SELECT designacao FROM categorias";
multiqual.bd db1 = new multiqual.bd();
ddlCategoria.DataSource = db1.devolvedataset(strsql);
ddlCategoria.DataBind();


Greetings,
Rodrigo Ferreira

 

[Karl Seguin]

You must specify the DataTextField and DataVlaueField

ddlCategoria.DataSource = db1.devolvedataset(strsql);
ddlCategoria.DataValueField = "designacao";
ddlCategoria.DataTextField = "designacao";
ddlCategoria.DataBind();

Karl

 

[Rodrigo Ferreira]

Ok! Thanks!

You must specify the DataTextField and DataVlaueField

ddlCategoria.DataSource = db1.devolvedataset(strsql);
ddlCategoria.DataValueField = "designacao";
ddlCategoria.DataTextField = "designacao";
ddlCategoria.DataBind();

Karl