kpax1684
February 14th, 2011, 11:12 PM
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!
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!