Im assuming your pickReport.Text value would equal just a date correct? (05/26/2013). My answer is provided based on the limit information/what i can gather from your code snippet.
The problem probably lies in the fact that your trying to compare a
DateTime
to a
Date
.
Example: 05/26/2013 05:00:000 does not equal 05/26/2013...know why? because the Time portion of the latter 05/26/2013 by default for a DateTime comparison is 12 am. So you are asking if 05/26/2013 05:00:000 is equal to 05/26/2013 12:00:000 which it does not.
So to remedy this you would need to cast your date time field in your sql query as Date.
Example:
Select
Rate,
Crates,
Weight,
Hens,
Discount,
PreviousAmount,
Payment,
AmountLeft
from
ChickenPurchaseOrders C inner join Accounts A on C.Fid=A.Fid
where
C.Date='05/26/2013'
Would then become
Select
Rate,
Crates,
Weight,
Hens,
Discount,
PreviousAmount,
Payment,
AmountLeft
from
ChickenPurchaseOrders C inner join Accounts A on C.Fid=A.Fid
where
CAST(C.Date AS Date) ='05/26/2013'
Also another note, you are using inline sql which will leave you open to sql injections. It would be best if you parameterize your query.
C# Sql Params:
http://www.dotnetperls.com/sqlparameter[
^]
But if you must do inline sql, for the love of maintenance at least use
string.Format("SELECT * FROM Table Where Filed = '{0}'", fieldName.Text);
You will save yourself an aneurism looking for mis-matched single quotes in a complex query.