|
-
February 15th, 2011, 12:12 AM
#1
SQLdatasource DATE filtering
Hello Guys,
Im just new to the .net worl i am using a SQLdatasource to populate a datagrid
but i also want to have a search function where i can filter a single specific date using sqldatasource.
Is this correct?
SqlDataSource1.FilterExpression = "[TARGET_DATE] = to_char(target_date,'mm/dd/yyyy') = to_char(to_date('" + txtSrchDate.Text.Trim() + "'),'mm/dd/yyyy')";
Please guys help me!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|