Hi GUIDO22,
Thank you very much for your reply. I have solved that issue by using the following query,
string sdatecheck = "select * from leavemaster_table where (from_date <= #" + this.Txt_Fromdate.Text + "# and to_date >= #" + this.Txt_Fromdate.Text + "#) or (from_date <= #" +...