Dropdownlist for year, month, day, time

Trifon Dinev

17y17.7k.NET

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

JaK17y ago
Can someone tell me how to extract the date from sqlDataSource.

I like this. I think I have the idea of how to format the data to combine the three date fields when inserting and updating using the _updating and _inserting functions.

How to I first capture the date field to use your solution:
Datetime date = [whatever date you retrieve from database]
Carmen17y ago
I usually do this by creating seperate dropdown lists for year, month, day. You can set up the dropdown lists and initialize them. The when you retrieve the date info from you db you can get the controls to select the corresponding date on page_load.
Datetime date = [whatever date you retrieve from database]
DropDownListTime.Text = Convert.ToString(date.Time);
DropDownListDateDay.Text = Convert.ToString(date.Day);
DropDownListDateMonth.Text = Convert.ToString(date.Month);
DropDownListDateYear.Text = Convert.ToString(date.Year);
alternatively, to grab the date values a user might select with your dropdown lost you can do:
DateTime date = Convert.ToDateTime(DropDownListDateDay.Text + " " + DropDownListDateMonth.Text + " " + DropDownListDateYear.Text + " " + DropDownListTime.Text);
Trifon Dinev17y ago
But I am reading a timestamp from database table and want to be sure that I'll choose what is needed to show, depending from the data into the database.
Pradeep Mishra17y ago
hello just bind day month & year in different dropdownlists   & set the field as a date time

private void monthsbind()
    {
        try
        {
            for (int i = 1; i <= 12; i++)
            {
                ListItem item = new ListItem();
                item.Text = new DateTime(1900, i, 1).ToString("MMMM");
                item.Value = i.ToString();
                ddlMonth.Items.Add(item);
                ddlMonth.SelectedValue = Convert.ToString(DateTime.Now.Month);
            }
        }
        catch (Exception E)
        {
            Response.Write(E.Message.ToString());
        }
    }

    private void yearbind()
    {
        try
        {
            for (Int32 i = Convert.ToInt32(DateTime.Now.Year) - 4; i <= Convert.ToInt32(DateTime.Now.Year) + 10; i++)
            {
                drpYear.Items.Add(i.ToString());
            }
            drpYear.Items.Insert(0, "Select Year");
            drpYear.SelectedValue = Convert.ToString(DateTime.Now.Year);
        }
        catch (Exception E)
        {
            Response.Write(E.Message.ToString());
        }
    }