Error to read datetimepikers

Mfwamba Tshimanga

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?'

6 Replies

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

Vulpes11y ago
Accepted answer
Try instead:

this.companyTableAdapter.Fill(this.DataSet2.company,datetimepicker1.Value, datetimepicker2.Value);
Mfwamba Tshimanga11y ago
Vulpes, thank so much. But you are a quick resolver. This is a great sinal.
Mfwamba Tshimanga11y ago
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 Biswas11y ago
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 Krishna11y ago
Hi,

Could you provide your code please.
Hari Krishna11y ago
Hi,

Could you provide your code please.