Error to read datetimepikers

Question

Hi!

I need to filter data from my reportviewer's page with dates (datetimepicker1 and datetimepicker2). I receive this error messages (But when I use a textbox to make filter for name or products its works. Not for dates):

Then with my datetimepicker

Error1The best overloaded method match for 'LunaManager.DataSet2TableAdapters.gestaoTableAdapter.Fill(LunaManager.DataSet2.gestaoDataTable, string, System.DateTime?, System.DateTime?)

Error2Argument 3: cannot convert from 'string' to 'System.DateTime?'

Error3Argument 4: cannot convert from 'string' to 'System.DateTime?'

Vulpes · Answer

Try instead: this.companyTableAdapter.Fill(this.DataSet2.companydatetimepicker1. Value datetimepicker2. Value);

Mfwamba Tshimanga · Answer

Vulpes thank so much. But you are a quick resolver. This is a great sinal.

Mfwamba Tshimanga · Answer

Before I need to inform that I do configure in my xsd file like this: SELECT date name FROM company where date between ? and ? then on my button I put this: this.companyTableAdapter.Fill(this.DataSet2.company datetimepicker1 .Text  datetimepicker2 .Text ); this.reportViewer1.RefreshReport();

Dipankar Biswas · Answer

Hi.. you need to convert string To datetime like this.. string date = 01/08/2008 ; DateTime dt = Convert.ToDateTime(date); Console.WriteLine( Year: {0} Month: {1} Day: {2}  dt.Year dt.Month dt.Day); more help.. see this link.. https://msdn.microsoft.com/en-us/library/cc165448.aspx Thanks Dipankar Biswas

Hari Krishna · Answer

Hi Could you provide your code please.

Hari Krishna · Answer

Hi Could you provide your code please.