fill and filter datagridview by stored procedure

[eugz]

Hi All.
I create stored procedure to fill datagridview

SELECT Emp_id ,ADate ,Position, FName ,LName
FROM Employee

Now I modified form insert in menu DateTimePicker field to filter DGV. How to change stored procedure to filter DGV?
Thanks.

[jmcilhinney]

You would add a where clause with a parameter to the sproc:

WHERE ADate = @ADate

Then you'd add a parameter to the Command you're using to execute the sproc:

myCommand.Parameters.Add("@ADate", SqlDbType.DateTime)

then you'd set the parameter value from your DTP:

myCommand.Parameters("@ADate").Value = myDateTimePicker.Value.Date