February 1st, 2011, 12:44 AM
Hello TO all Guru out there..
I am new to the asp.net and sqldatasource..,
I have use the sqldatasource in a code and i want to filter the recods based in on the date, using below function
But I always got an error!.
SqlDataSource1.FilterExpression = "[TARGET_DATE] = to_char(target_date,'mm/dd/yyyy') = to_char(to_date('" + txtSrchDate.Text.Trim() + "'),'mm/dd/yyyy')";
can somebody help me..??
Click Here to Expand Forum to Full Width
This a Codeguru.com survey!