Hi All,
My problem is like this ..
when i execute this code it's work fine.
SELECT * FROM [feesdetail] WHERE CONVERT(varchar(10),[DATE],103) = '03/04/2013'
NOW,
I want to achive date 03/04/2013 from my text box. For this i use this code . But i can't recive the data.
SelectCommand="SELECT * FROM [feesdetail] WHERE CONVERT(varchar(10),[DATE],103) = @DATE">
<SelectParameters>
<asp:ControlParameter ControlID="txtDOB" Name="DATE" PropertyName="Text"
Type="DateTime" />
</SelectParameters> Go to the complete details ...