help regarding date time picker

Question

hi In my windows application form have 2 labels(startdateenddate) 2 datetime picker 2textboxesdatagridview(in that datagridview gather the data from sql server table) and one submit button. when i run the applicationi will give startdate and enddate using datetimepicker.then the gridview shows data's with in the range of start date and end date.what can i do.please help me. thanks & Regards Gokilavasan.M

Satyapriya Nayak · Answer

Hi Gokilavasan Use these queries to filter data str = select * from employee where CreatedDate between ' +dateTimePicker1.Value.Date.ToString() + ' and ' + dateTimePicker2.Value.Date.ToString() + '; Or str =select * from employee where CreatedDate>=' + dateTimePicker1.Value.Date.ToString() + ' and CreatedDate Thanks