Hi

I'll give an example for this :

DataTable dt new DataTable();
OleDbConnection con new OleDbConnection();
OleDbCommand com new OleDbCommand( Select * From Employees con);
OleDbDataAdapter da new OleDbDataAdapter();
da.SelectCommand com;
da.Fill(dt);
DropDownList1.DataSource dt;
DropDownList1.DataBind();

The achive the best performance in databiding always use

Dim _Li as ListItem

While _Reader.Read()

_Li new ListItem(_Reader(1) _Reader(0))

_dropdownList.Items.add(_Li)

End While

You can check with performance counter to check in real.

Cheers

Sanjar

niyazi.khan@gmail.com