Programmaticall y set FilterExpressio n and FilterParameter s of SqlDataSource

[fuchs.markus]

Hello,
on my page, I have a DetailsViewCont rol connected to a SqlDataSource.
Now when I dynamically set the FilterExpressio n and FilterParameter s -
for example in a OnClick-EventHandler of a button - the DetailsView
shows the filtered Data, but Deleting and Updating doesn't work
anymore. The DetailsView changes to EditMode, but after clicking on the
UpdateButton it shows the old data.
Am I missing something or is it just not possible or perhaps a beta
problem?

Here is my Button-Click-EventHandler:

protected void Button1_Click(o bject sender, EventArgs e)
{
SqlDataSource1. FilterExpressio n = "CompanyNam e LIKE '{0}'";
SqlDataSource1. FilterParameter s.Add("CompanyN ame", "A*");
}
And here my Page-SourceCode:

<asp:DetailsVie w ID="DetailsView 1" runat="server"
AllowPaging="Tr ue" AutoGenerateRow s="False"
DataKeyNames="C ustomerID" DataSourceID="S qlDataSource3"
Height="50px" Width="125px">
<Fields>
<asp:BoundFie ld DataField="Cust omerID"
HeaderText="Cus tomerID" ReadOnly="True" SortExpression= "CustomerID " />
<asp:BoundFie ld DataField="Comp anyName"
HeaderText="Com panyName" SortExpression= "CompanyNam e" />
<asp:BoundFie ld DataField="Cont actName"
HeaderText="Con tactName" SortExpression= "ContactNam e" />
<asp:BoundFie ld DataField="Cont actTitle"
HeaderText="Con tactTitle" SortExpression= "ContactTit le" />
<asp:BoundFie ld DataField="Addr ess"
HeaderText="Add ress" SortExpression= "Address" />
<asp:BoundFie ld DataField="City " HeaderText="Cit y"
SortExpression= "City" />
<asp:BoundFie ld DataField="Regi on" HeaderText="Reg ion"
SortExpression= "Region" />
<asp:BoundFie ld DataField="Post alCode"
HeaderText="Pos talCode" SortExpression= "PostalCode " />
<asp:BoundFie ld DataField="Coun try"
HeaderText="Cou ntry" SortExpression= "Country" />
<asp:BoundFie ld DataField="Phon e" HeaderText="Pho ne"
SortExpression= "Phone" />
<asp:BoundFie ld DataField="Fax" HeaderText="Fax "
SortExpression= "Fax" />
<asp:CommandFie ld ShowDeleteButto n="True"
ShowEditButton= "True" ShowInsertButto n="True" />
</Fields>
</asp:DetailsView >

<asp:SqlDataSou rce ID="SqlDataSour ce3" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:NorthwindCon nectionString5 %>"
DeleteCommand=" DELETE FROM [Customers] WHERE [CustomerID] =
@original_Custo merID"
InsertCommand=" INSERT INTO [Customers] ([CustomerID],
[CompanyName], [ContactName], [ContactTitle], [Address], [City],
[Region], [PostalCode], [Country], [Phone], [Fax]) VALUES (@CustomerID,
@CompanyName, @ContactName, @ContactTitle, @Address, @City, @Region,
@PostalCode, @Country, @Phone, @Fax)"
SelectCommand=" SELECT * FROM [Customers]"
UpdateCommand=" UPDATE [Customers] SET [CompanyName] = @CompanyName,
[ContactName] = @ContactName, [ContactTitle] = @ContactTitle, [Address]
= @Address, [City] = @City, [Region] = @Region, [PostalCode] =
@PostalCode, [Country] = @Country, [Phone] = @Phone, [Fax] = @Fax WHERE
[CustomerID] = @original_Custo merID" OnUpdated="SqlD ataSource3_Upda ted"
OnUpdating="Sql DataSource3_Upd ating">
<DeleteParamete rs>
<asp:Paramete r Name="original_ CustomerID" Type="String"
/>
</DeleteParameter s>
<UpdateParamete rs>
<asp:Paramete r Name="CompanyNa me" Type="String" />
<asp:Paramete r Name="ContactNa me" Type="String" />
<asp:Paramete r Name="ContactTi tle" Type="String" />
<asp:Paramete r Name="Address" Type="String" />
<asp:Paramete r Name="City" Type="String" />
<asp:Paramete r Name="Region" Type="String" />
<asp:Paramete r Name="PostalCod e" Type="String" />
<asp:Paramete r Name="Country" Type="String" />
<asp:Paramete r Name="Phone" Type="String" />
<asp:Paramete r Name="Fax" Type="String" />
<asp:Paramete r Name="original_ CustomerID" Type="String"
/>
</UpdateParameter s>
<InsertParamete rs>
<asp:Paramete r Name="CustomerI D" Type="String" />
<asp:Paramete r Name="CompanyNa me" Type="String" />
<asp:Paramete r Name="ContactNa me" Type="String" />
<asp:Paramete r Name="ContactTi tle" Type="String" />
<asp:Paramete r Name="Address" Type="String" />
<asp:Paramete r Name="City" Type="String" />
<asp:Paramete r Name="Region" Type="String" />
<asp:Paramete r Name="PostalCod e" Type="String" />
<asp:Paramete r Name="Country" Type="String" />
<asp:Paramete r Name="Phone" Type="String" />
<asp:Paramete r Name="Fax" Type="String" />
</InsertParameter s>
</asp:SqlDataSour ce>

Thanks in advance
Markus Fuchs

[Markus]

Hi all,
I've found a solution to my problem: If I leave the FilterParameter s
alone and write keys as well as values in the FilterExpressio n-String,
everything works properly.

MF