Changing FilterExpressio n

[David]

I cannot get my aspx page (ASP.Net 2.0) to remove the FilterExpressio n on a
SqlDataSource. Can someone tell me what I am doing wrong? Below is the
SelectCommand:

<asp:SqlDataSou rce ID="SqlClosedRe ason" runat="server" ConnectionStrin g="<%$
ConnectionStrin gs:WcccuConnect ionString %>"

SelectCommand=" SELECT NULL As seq_nbr, '-none-' As reason, 1 As active UNION
SELECT [seq_nbr], [reason], [active] FROM [activity_closed _reasons]"

FilterExpressio n = "active={0} ">

<FilterParamete rs>

<asp:ControlPar ameter ControlID="txtA ctive" PropertyName="T ext"
Name="pactive" DefaultValue="1 " Type="Byte" />

</FilterParameter s>

</asp:SqlDataSour ce>

In my VB code at the top of the page I am doing the following:

SqlClosedReason .FilterExpressi on = ""

When the page tries to open for a specific record, it gives me the following
error:

Databinding methods such as Eval(), XPath(), and Bind() can only be used in
the context of a databound control.

If I comment out the setting of the FilterExpressio n the error goes away.

p.s. This is populating a DropDownList.

David

[Alvin Bruney [MVP]]

Remove the sqldatasource and re-add it to the form. Run it without the
filter, then add the filter if you need to. This is a *vanilla install
technique.

--
_______________ _________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------
"David" <dl*****@lifeti meinc.comwrote in message
news:O7******** ******@TK2MSFTN GP04.phx.gbl...

>I cannot get my aspx page (ASP.Net 2.0) to remove the FilterExpressio n on a
SqlDataSourc e. Can someone tell me what I am doing wrong? Below is the
SelectComman d:

<asp:SqlDataSou rce ID="SqlClosedRe ason" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:WcccuConnect ionString %>"

SelectCommand=" SELECT NULL As seq_nbr, '-none-' As reason, 1 As active
UNION SELECT [seq_nbr], [reason], [active] FROM [activity_closed _reasons]"

FilterExpressio n = "active={0} ">

<FilterParamete rs>

<asp:ControlPar ameter ControlID="txtA ctive" PropertyName="T ext"
Name="pactive" DefaultValue="1 " Type="Byte" />

</FilterParameter s>

</asp:SqlDataSour ce>

In my VB code at the top of the page I am doing the following:

SqlClosedReason .FilterExpressi on = ""

When the page tries to open for a specific record, it gives me the
following error:

Databinding methods such as Eval(), XPath(), and Bind() can only be used
in the context of a databound control.

If I comment out the setting of the FilterExpressio n the error goes away.

p.s. This is populating a DropDownList.

David

[David]

Nope. Still a problem.

David

"Alvin Bruney [MVP]" <www.lulu.com/owcwrote in message
news:e7******** ******@TK2MSFTN GP05.phx.gbl...

Remove the sqldatasource and re-add it to the form. Run it without the
filter, then add the filter if you need to. This is a *vanilla install
technique.

--
_______________ _________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------
"David" <dl*****@lifeti meinc.comwrote in message
news:O7******** ******@TK2MSFTN GP04.phx.gbl...

>>I cannot get my aspx page (ASP.Net 2.0) to remove the FilterExpressio n on
a SqlDataSource. Can someone tell me what I am doing wrong? Below is the
SelectCommand :

<asp:SqlDataSo urce ID="SqlClosedRe ason" runat="server"
ConnectionStri ng="<%$ ConnectionStrin gs:WcccuConnect ionString %>"

SelectCommand= "SELECT NULL As seq_nbr, '-none-' As reason, 1 As active
UNION SELECT [seq_nbr], [reason], [active] FROM
[activity_closed _reasons]"

FilterExpressi on = "active={0} ">

<FilterParamet ers>

<asp:ControlPa rameter ControlID="txtA ctive" PropertyName="T ext"
Name="pactiv e" DefaultValue="1 " Type="Byte" />

</FilterParameter s>

</asp:SqlDataSour ce>

In my VB code at the top of the page I am doing the following:

SqlClosedReaso n.FilterExpress ion = ""

When the page tries to open for a specific record, it gives me the
following error:

Databinding methods such as Eval(), XPath(), and Bind() can only be used
in the context of a databound control.

If I comment out the setting of the FilterExpressio n the error goes away.

p.s. This is populating a DropDownList.

David

[David]

I forgot to mention that the sqldatasource is in a dropdownlist in a
FormView - if that matters.

David

"Alvin Bruney [MVP]" <www.lulu.com/owcwrote in message
news:e7******** ******@TK2MSFTN GP05.phx.gbl...

Remove the sqldatasource and re-add it to the form. Run it without the
filter, then add the filter if you need to. This is a *vanilla install
technique.

--
_______________ _________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------
"David" <dl*****@lifeti meinc.comwrote in message
news:O7******** ******@TK2MSFTN GP04.phx.gbl...

>>I cannot get my aspx page (ASP.Net 2.0) to remove the FilterExpressio n on
a SqlDataSource. Can someone tell me what I am doing wrong? Below is the
SelectCommand :

<asp:SqlDataSo urce ID="SqlClosedRe ason" runat="server"
ConnectionStri ng="<%$ ConnectionStrin gs:WcccuConnect ionString %>"

SelectCommand= "SELECT NULL As seq_nbr, '-none-' As reason, 1 As active
UNION SELECT [seq_nbr], [reason], [active] FROM
[activity_closed _reasons]"

FilterExpressi on = "active={0} ">

<FilterParamet ers>

<asp:ControlPa rameter ControlID="txtA ctive" PropertyName="T ext"
Name="pactiv e" DefaultValue="1 " Type="Byte" />

</FilterParameter s>

</asp:SqlDataSour ce>

In my VB code at the top of the page I am doing the following:

SqlClosedReaso n.FilterExpress ion = ""

When the page tries to open for a specific record, it gives me the
following error:

Databinding methods such as Eval(), XPath(), and Bind() can only be used
in the context of a databound control.

If I comment out the setting of the FilterExpressio n the error goes away.

p.s. This is populating a DropDownList.

David

[Alvin Bruney [MVP]]

Sorry for misreading your post. The reason you are having this error is
because a filter expression is implicitly bound to a parameter list and the
empty filter is breaking that guarantee.

There are a couple approaches you can take depending on what you want to do.
I suspect you want the grid to come up initiallly unfiltered and then use
the drop down to filter the grid? If this assumption is correct, you can do
this thru the declarative source control by adding an empty list item to the
dropdown as the selected, first item. However, you won't be able to put a
"Select Active Items" as the first option in the list box.

You can ignore the declarative syntax and use the codebehind to get around
this limitation. Air code:
if (!IsPostBack)
{
SqlDataSource1. FilterExpressio n = string.Empty;
System.Web.UI.W ebControls.Para meter pc = new Parameter();
SqlDataSource1. FilterParameter s.Add(pc);
}
else
{

//clear is required
SqlDataSource1. FilterParameter s.Clear();
ControlParamete r cprViewState = new ControlParamete r();
cprViewState.Co ntrolID = DropDownList1.I D.ToString();
cprViewState.Pr opertyName = "SelectedValue" ;
cprViewState.Na me = "ViewState" ;
cprViewState.Ty pe = TypeCode.String ;
SqlDataSource1. FilterExpressio n = "Title='{0} '";
SqlDataSource1. FilterParameter s.Add(cprViewSt ate);

GridView1.DataB ind();

}
--
_______________ _________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------
"David" <dl*****@lifeti meinc.comwrote in message
news:e1******** ******@TK2MSFTN GP04.phx.gbl...

>I forgot to mention that the sqldatasource is in a dropdownlist in a
FormView - if that matters.

David

"Alvin Bruney [MVP]" <www.lulu.com/owcwrote in message
news:e7******** ******@TK2MSFTN GP05.phx.gbl...

>Remove the sqldatasource and re-add it to the form. Run it without the
filter, then add the filter if you need to. This is a *vanilla install
technique.

--
______________ __________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------
"David" <dl*****@lifeti meinc.comwrote in message
news:O7******* *******@TK2MSFT NGP04.phx.gbl.. .

>>>I cannot get my aspx page (ASP.Net 2.0) to remove the FilterExpressio n on
a SqlDataSource. Can someone tell me what I am doing wrong? Below is
the SelectCommand:

<asp:SqlDataS ource ID="SqlClosedRe ason" runat="server"
ConnectionStr ing="<%$ ConnectionStrin gs:WcccuConnect ionString %>"

SelectCommand ="SELECT NULL As seq_nbr, '-none-' As reason, 1 As active
UNION SELECT [seq_nbr], [reason], [active] FROM
[activity_closed _reasons]"

FilterExpress ion = "active={0} ">

<FilterParame ters>

<asp:ControlP arameter ControlID="txtA ctive" PropertyName="T ext"
Name="pactive " DefaultValue="1 " Type="Byte" />

</FilterParameter s>

</asp:SqlDataSour ce>

In my VB code at the top of the page I am doing the following:

SqlClosedReas on.FilterExpres sion = ""

When the page tries to open for a specific record, it gives me the
following error:

Databinding methods such as Eval(), XPath(), and Bind() can only be used
in the context of a databound control.

If I comment out the setting of the FilterExpressio n the error goes
away.

p.s. This is populating a DropDownList.

David