Dropdownlist for year, month, day, time

Question

Hi,
I have a sql table
create table equipment(
id int not null auto_increment,
dtime timestamp not null,
door char(1) not null,
fire char(1) not null,
temperature char(1) not null
);
I want to use dropdownlist and using dtime (timestamp) to show year, month, day, time, so I can choose what data to be shown in a datagrid. All this depends from dtime field. How can I accomplish this in asp.net c#?
Thanks and regards,
Trifon.