Search date by using DateTimePicker

[webwired72]

Hi, I am using C# and SQL Express 2005...

I have a table that has a datetime column, on the form I have placed a DateTimePicker and I would like to search by date, using that object, but am running into some snares... Here's my code...

        private void fillByDateToolStripButton_Click(object sender, EventArgs e)
        {
            try
            {
                this.ticketsTableAdapter.FillByDate(this.massageProDataSet.Tickets, ((System.DateTime)(System.Convert.ChangeType(ticketSearchDateTimePicker, typeof(System.DateTime)))));
            }
            catch (System.Exception ex)
            {
                System.Windows.Forms.MessageBox.Show(ex.Message);
            }

        }

I am getting this error...

Object must implement IConvertible.

 

[jmeckley]

what is ticketSearchDateTimePicker?
if this is a control you must get the value from the control, not just convert the control to a date time.
something like

DateTime date = ticketSearchDateTimePicker.SelectedDate;

if this is a string they use

DateTime date = DateTime.Parse(ticketSearchDateTimePicker);

if this is an object, just cast

DateTime date = (DateTime)ticketSearchDateTimePicker;

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[webwired72]

DateTimePicker is a control from the "Toolbox" in Visual C# IDE...

I tried converting it first like you suggested, but get this error...

Cannot convert type 'System.Windows.Forms.DateTimePicker' to 'System.DateTime'

 

[jmeckley]

of course not, DateTimePicker is a control. you need to get the date from the control. something like

DateTime date = ticketSearchDateTimePicker.Value;

Jason Meckley
Programmer
Specialty Bakers, Inc.