How do I show a selected date data from a SQL Server database in a DataGridView?

How do I show a selected date data from a SQL Server database in a
DataGridView?

How do I show a selected date data from a SQL Server database in a
DataGridView?
I tried but that shows all data from database.
Here is the code which triggers when I click the button to show
SqlDataAdapter da = new SqlDataAdapter("select currDate,WtrNm,Type,No from
WtrTblAllot", con);
DataSet ds = new DataSet();
da.Fill(ds);
dgvWtrAllot.DataSource = ds.Tables[0];