To Find missing dates in data-gridview.

Question

reg_date	dcotor_name	patient_name	reg_no	Kin_name
1/1/2014	rahul	manmohan	12534	sonia
3/1/2014	narendra	abc	54896	lalu
4/1/2014
10/1/2014

I have two datetimepickers in c# windows form application, when I select date as 01/01/2014 to 31/01/2014 it shows me the date on which doctor was present and other details in datgridview.I have inner join 3-4 tables to get above data. My is how to get missing dates i.e 2/1/2014,5/1/2014 and so on in which doctor was not present.

Keyur Patel · Answer

Hi Alan You can use common table expression and pass your date range. Please refer following links to find missing dates in sql. http://www.codeproject.com/Tips/328085/Find-Missed-Date-Ranges-using-SQL-Server https://www.simple-talk.com/sql/t-sql-programming/find-missing-date-ranges-in-sql/ http://stackoverflow.com/questions/20677472/sql-find-missing-date-ranges

Sunny Shaikh · Answer

can you please send your tables detail.

alan kumar · Answer

thanks for reply but my dates and other information are not coming from single table. I am getting dates and other information by inner join 3-4 tables so your recommended links will not work. Like dates reg_no from registration table then doctor name from doctor master table then patients details from patient table like this. My aim is to know absent dates of doctor in a particular period selected by to and from datetimepickers