Home All Groups Group Topic Archive Search About
Author
24 Nov 2005 3:38 PM
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

Author
24 Nov 2005 3:46 PM
Karl Seguin
You must specify the DataTextField and DataVlaueField

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

Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/


Show quoteHide quote
"Rodrigo Ferreira" <rjrferre***@gmail.com> wrote in message
news:O0Hsb0Q8FHA.1028@TK2MSFTNGP11.phx.gbl...
> 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
>
Are all your drivers up to date? click for free checkup

Author
24 Nov 2005 3:58 PM
Rodrigo Ferreira
Ok! Thanks!

Show quoteHide quote
"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
escreveu na mensagem news:eImdf5Q8FHA.740@TK2MSFTNGP11.phx.gbl...
> You must specify the DataTextField and DataVlaueField
>
> ddlCategoria.DataSource = db1.devolvedataset(strsql);
> ddlCategoria.DataValueField = "designacao";
> ddlCategoria.DataTextField = "designacao";
> ddlCategoria.DataBind();
>
> Karl
> --
> MY ASP.Net tutorials
> http://www.openmymind.net/
>
>
> "Rodrigo Ferreira" <rjrferre***@gmail.com> wrote in message
> news:O0Hsb0Q8FHA.1028@TK2MSFTNGP11.phx.gbl...
>> 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
>>
>
>

Bookmark and Share