How possible is (Never see it before in C#)

Israel

Hello!

I configure my dataset file like this:

SELECT [Date], [Name], [On_duty], [Off_duty], [Early], [Clock_In], [Clock_Out], [Absent], [Department], [Identificação], [NDays], [NDays_1], [Anexo] FROM [1]

where [date] between ? and ? and [name] = ?

and in my button is like this:

this._1TableAdapter.Fill(this.DataSet1._1, dataInicialConsPorNomes.Text, dataFinalConsPorNomes.Text, txtName.Text);

this.reportViewer1.RefreshReport();

Curiosly, the filter starts well from one date to another.
But not as recommended, for example if I filter from 2 of February 2015 to 10 of February of 2015. Its will not filter the 2 february's until 10 february 2015. But he will do from 3 of February to 10 of February 2015 (correct but not really because its missing one day).
Then Now when I ask for example 31st of January 2015 from 10 of February 2015. Its doesnt show nothing (only title without datas).
Which solution please.

5 Replies

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

Israel11y ago
Thank you to all to respond to my question. But the error comes from me. When I criate my table in Ms Access I didnt put the date's column Date's Type. I leave it (or forgot) in text's "Type" than to be "Date" type. Now its works. Thanx to all.
0
Vulpes11y ago
In your original query:

SELECT [Date], [Name], [On_duty], [Off_duty], [Early], [Clock_In], [Clock_Out], [Absent], [Department], [Identificação], [NDays], [NDays_1], [Anexo] FROM [1]
where [date] between ? and ? and [name] = ?

can you show the code where you're setting the three parameters.
0
Israel11y ago
See what I do to make filter from one day of the last month to the recent (or another month). Even like that its doesnt works (need solution for that please):

SELECT [Date], [Name], [On_duty], [Off_duty], [Early], [Clock_In], [Clock_Out], [Absent], [Department], [Identificação], [NDays], [NDays_1], [Anexo] FROM [1]
where [date] >= ? and ? and [name] = ?
0
Vikram Agrawal11y ago

Hi Israel,
Whatever Jignesh explained is absolutely right. You can verify it by removing name filter then check with 2nd February and as well as with 31st January.
I hope it will give you the correct result set.
Thanks
0
Jignesh Trivedi11y ago
Hi,
Between is alway return value expression is greater than or equal to the value of expression and less than or equal to the value of end expression.
you have also another filter "Name" . It might possible this condition is not true for 2nd feb....
hope this will help you.
+1