Data Binding Technology-how to bind columns in a table to the dropdownlist Control

Void Page_load ( Object Sender, system. eventargs E)
{
If ( ! Ispostback)
{
// Create database connection strings and SQL statements
String Connstr = System. configuration. configurationsettings. deleettings [ " Connectionsqlserver " ];
String Query =   " Select * from products " ;

// Execute database statements and fill data in the able
Sqlcommand mycommand =   New Sqlcommand (query, New Sqlconnection (connstr ));
Sqldataadapter myadapter =   New Sqldataadapter (mycommand );
Datatable dt =   New Datatable ();
Myadapter. Fill (DT );

// Data Binding dropdownlist Control
Dropdownlist1.datasource = DT;
Dropdownlist1.datatextfield =   " Productname " ;
Dropdownlist1.datavaluefield =   " Unitprice " ;
Dropdownlist1.databind ();
}
}