How to Search date by two DateTimePickers

Question

When I select date 3-5-18 to 3-17-18. The result is show only 3-5-18 to 3-16-18. And when I select 3-5-18 to 3-5-18 the result shows nothing on the Gridview.   My Coding   System.Data.SqlClient.SqlConnection cn= new System.Data.SqlClient.SqlConnection(); cnConnectionString=HR_And_Payroll.Propertys.Settings.Default. MyCon; cn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType=CommandType.Text; cmd.CommandText=" Select * Where Date >=@Date1 And Date cmd.Parameters. AddWithValue("@Date2", dateTimePicker2.Value);   Please anyone help me

Nitin Sontakke · Accepted Answer

The reason for the this is your [Date] column (very very bad name for the column by the way, use some imagination, give some proper name as in [InvoiceDate], [ContactDate], etc.) is of data type date time, which means it has time as well as date in it.   So your @Date1 and @Date2 parameters should also be date time. After you get the date from datetimepicker, you should somehow add time to that date as well. All I will say is your query should look like as follows:  select *   from [dbo].[tblTableName]   where [Date] between  '2018-03-05 00:00:00'  and  '2018-03-05 23:59:59' ;   Hope you get the point. You can try above query in Query analyzer to check.    I notice your select query is also wrong.