C#, visual studio 2015, MS Access database : the datagridview1 as below: | | |
ID | Entry Date | Status | FirstName | LastName | Father Name | Mother Name | ChildrenNo |
1 | 20/7/17 | Unmarried | Rohim | Mia | Ajgor | Korimona | |
4 | 23/7/17 | Unmarried | Kuddus | Mia | Abdullah | Zerina | |
5 | 24/7/17 | Married | Nitai | Pada | Sumon | Khodeja | 4 |
6 | 25/7/17 | Married | Salam | Istiak | Sahabuddin | Ojela | |
7 | 26/7/17 | Married | Alom | Mahabub | Mijan | Sahnaj | 3 |
8 | 27/7/17 | Married | Mitu | Kita | Samim | Sorifa | |
| | | | | | | |
| | | | | ComboboxStatus | datetimepricker1 | |
| | | | | btnFind | datetimepricker2 | |
| | | | | | | |
When I will select comboboxstatus as Married, dtp1 as 24/7/17, dtp2 as 27/7/17, If I press btnFind button then I get the result that ChildreNo column is not empty and datagridview will show the result as: |
| | |
| | | | | | | |
ID | Entry Date | Status | FirstName | LastName | Father Name | Mother Name | ChildrenNo |
5 | 24/7/17 | Married | Nitai | Pada | Sumon | Khodeja | 4 |
7 | 26/7/17 | Married | Alom | Mahabub | Mijan | Sahnaj | 3 |
| | | | | | | |
Please provide me any link or example or simple code. | | | |