I have a SQL Table, have a three main field,
CNO Amount Date
LCKY001 1000.00 25/11/2011
LCKY001 1000.00 25/12/2011
LCKY001 2000.00 25/01/2012
LCKY002 3000.00 23/11/2011
LCKY002 2000.00 23/01/2012
Like this. I want to bind this data in DataGrid and I want to Display only Current Month Data.
Like this. How I do that. What is the Query I want to use. Please help this matter.