How to populate dropdown list from database?

[Merdaad]

I saw an example of this which talked about assigning valueTextField and
DataTextField. So I have twenty items coming back from the database(I use a
dataadapter), do I need to go thru a loop to assign each item in the Dropdown?
Is there a way to just assign the datasource to a dataset (that's filled
with data)?

Thanks a lot

Merdaad

[Luis Esteban Valencia]

--
LUIS ESTEBAN VALENCIA
MICROSOFT DCE 2.
MIEMBRO ACTIVO DE ALIANZADEV
"Merdaad" <Me*****@discus sions.microsoft .com> escribió en el mensaje
news:5A******** *************** ***********@mic rosoft.com...

I saw an example of this which talked about assigning valueTextField and
DataTextField. So I have twenty items coming back from the database(I use a dataadapter), do I need to go thru a loop to assign each item in the Dropdown? Is there a way to just assign the datasource to a dataset (that's filled
with data)?

Thanks a lot

Merdaad

[Luis Esteban Valencia]

private void cargarProveedor es()

{

SqlDataAdapter myadapter = new SqlDataAdapter( "select idproveedor,
nombreproveedor from proveedores order by nombreproveedor asc",
sqlConnection1) ;

DataSet myds = new DataSet();

myadapter.Fill( myds);

comboproveedore s.DataSource= myds;

comboproveedore s.DataTextField ="nombreproveed or";

comboproveedore s.DataValueFiel d = "idproveedo r";

comboproveedore s.DataBind();

}
--
LUIS ESTEBAN VALENCIA
MICROSOFT DCE 2.
MIEMBRO ACTIVO DE ALIANZADEV
"Merdaad" <Me*****@discus sions.microsoft .com> escribió en el mensaje
news:5A******** *************** ***********@mic rosoft.com...

I saw an example of this which talked about assigning valueTextField and
DataTextField. So I have twenty items coming back from the database(I use a dataadapter), do I need to go thru a loop to assign each item in the Dropdown? Is there a way to just assign the datasource to a dataset (that's filled
with data)?

Thanks a lot

Merdaad

[Merdaad]

Thanks that worked great.

"Luis Esteban Valencia" wrote:

private void cargarProveedor es()

{

SqlDataAdapter myadapter = new SqlDataAdapter( "select idproveedor,
nombreproveedor from proveedores order by nombreproveedor asc",
sqlConnection1) ;

DataSet myds = new DataSet();

myadapter.Fill( myds);

comboproveedore s.DataSource= myds;

comboproveedore s.DataTextField ="nombreproveed or";

comboproveedore s.DataValueFiel d = "idproveedo r";

comboproveedore s.DataBind();

}
--
LUIS ESTEBAN VALENCIA
MICROSOFT DCE 2.
MIEMBRO ACTIVO DE ALIANZADEV
"Merdaad" <Me*****@discus sions.microsoft .com> escribió en el mensaje
news:5A******** *************** ***********@mic rosoft.com...

I saw an example of this which talked about assigning valueTextField and
DataTextField. So I have twenty items coming back from the database(I use

a

dataadapter), do I need to go thru a loop to assign each item in the

Dropdown?

Is there a way to just assign the datasource to a dataset (that's filled
with data)?

Thanks a lot

Merdaad