<data:TaxationAuthorityInfoDataSource runat="server" ID="SummaryDS"
SelectMethod="GetPaged">
<Parameters>
<data:SqlParameter Name="WhereClause" UseParameterizedFilters="false">
<Filters>
<data:TaxationAuthorityInfoExpressionBuilder Column="DatePlaced" BuilderExpression="AppendRange">
<Parameters>
<asp:ControlParameter Name="From" ControlID="__Page" PropertyName="FilterDateFrom" DefaultValue="01/01/2200" />
<asp:ControlParameter Name="To" ControlID="__Page" PropertyName="FilterDateTo" DefaultValue="01/01/1990" />
</Parameters>
</data:TaxationAuthorityInfoExpressionBuilder>
<data:TaxationAuthorityInfoExpressionBuilder Column="CurrencyCode" ControlID="ddlCurrency"
BuilderExpression="AppendLike" />
<data:TaxationAuthorityInfoExpressionBuilder Column="TaxAuthorityId" ControlID="ddlTaxAuthority"
BuilderExpression="AppendEquals" />
<data:TaxationAuthorityInfoExpressionBuilder Column="TicketStateId" ControlID="ddl_State"
BuilderExpression="AppendEquals" />
</Filters>
</data:SqlParameter>
</Parameters>
</data:TaxationAuthorityInfoDataSource>
NOTE: property must return string, must give a format of date string.
public string FilterDateTo
{
get
{
if (dtmTo.SelectedDate.HasValue)
{
var d = dtmTo.SelectedDate.Value.AddDays(1).AddSeconds(-1).ToString("yyyyMMdd HH:mm:ss");
return d;
}
else
return DateTime.Now.AddMonths(1).ToString("yyyyMMdd HH:mm");
}
}
public string FilterDateFrom
{
get
{
if (dtmFrom.SelectedDate.HasValue)
{
var d = dtmFrom.SelectedDate.Value.ToString("yyyyMMdd HH:mm");
return d;
}
else
return DateTime.Now.AddMonths(-1000).ToString("yyyyMMdd HH:mm");
}
}