bind drop down list

[Sonali.NET[MVP]]

'Code to populate datareader
'...

while dataread.read()
ddl.items.add(new listitem(dataread("StudentName").ToString , dataread("StudentID").ToString))
end while

HTH



----- Original Message -----
From: "Julia" <pauldiamond@ukonline.co.uk>
Newsgroups: microsoft.public.dotnet.framework.aspnet
Sent: Sunday, July 13, 2003 12:27 PM
Subject: bind drop down list

> I am just starting .net and am looking for an example of binding a
> dropdown(combo) to an sql server database.
>
> I want the dropdown to be populated with StudentName in the text and
> StudentID in the value.
>
> Because I only need to read the data I think I should be using the
> datareader but am not sure.
>
> Thankyou
>
>
>

[Jos]

Julia wrote:

> I am just starting .net and am looking for an example of binding a
> dropdown(combo) to an sql server database.
>
> I want the dropdown to be populated with StudentName in the text and
> StudentID in the value.
>
> Because I only need to read the data I think I should be using the
> datareader but am not sure.
>
> Thankyou

[url]http://msdn.microsoft.com/library/en-us/dv_vbCode/html/vbtskCodePopulatingDr[/url]
opDownListOrListBoxControlUsingDataReaderVisualBas ic.asp
(remove linebreaks)

For the Dropdownlist, set DataTextField="StudentName" and
DataValueField="StudentID"

--

Jos Branders