Shovan Saha

Shovan Saha

  • NA
  • 321
  • 86.9k

Database search

Jul 29 2017 11:25 AM
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.      

Answers (1)