you can by using linq to do like this
DataContentDataContext db = new DataContentDataContext ();
var result = from p db.MyTableName
where p.FieldDate = Convert.ToDateTime(txtbox.text)
select p ;
if using SQL you can create stored procedure and then calle it execute your query
CREATE PROCEDURE Get_Data_By_Date
@Docs_Date datetime
AS
BEGIN
SELECT * from YourTable where docDate =@Docs_Date
END
GO