How to pass parameter to DataSet via user control?

[Guest]

Hi,

I've defined an ObjectDataSource and a parameterized DataSet. I would like
it if I could pass the parameter value that describes the query that creates
the DataSet as part of a user control declaration. Here's how the parameter
is described in the context of my ObjectDataSource:

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetArticlesByWhomever"
TypeName="WhateverTableAdapters.WhateverTableAdapter">
<SelectParameters>
<asparameter DefaultValue="83" Name="PersonID" Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>

The query that's part of the DataSet has a standard @Parameter string, and
I've verfied that it is working with the DefaultValue I'm passing.

Can somone tell me how to set a differnet Parameter value using a value
passed from a User Control and/or programmatically?

Thanks,

-KF

 

[Guest]

Answering my own question: here's 3/4 of the answer. I am still figuring out
how to pass a parameter directly from the user control to the query that
defines the ObjectDataSource -- if someone could answer that, I'd appreciate
it. For anyone looking for a simple example of how ObjectDataSource can be
parameterized, example follows.

-KF

Steps:
1) Configure your ObjectDataSource query to accept a parameter
2) Include a <asp:ControlParameter ... (nested as a SelectParameter) that
includes a default value you wish to pass and a binding to a ControlID.

Elaborating that:
1) SELECT Contentitems.Con_Title, ...
WHERE ( (Contentitems.Sta_StatusID <> 666 ) AND ...
(Persons.Per_PersonID = @PersonID)


2)
<asp:ObjectDataSource ID="odsArticlesByStaff" runat="server"
OnSelecting="ObjectDataSource1_Selecting"
SelectMethod="GetArticlesByUwnewsStaff"
TypeName="ArticlesByUwnewsStaffTableAdapters.uwnStaffArticlesTableAdapter">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" DefaultValue="83"
Name="PersonID"
PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>
<asp:ObjectDataSource ID="odsUwnewsStaff" runat="server"
SelectMethod="GetNewsReleaseAuthorsDT"
TypeName="uwnews_NewsReleaseAuthorsTableAdapters.DataTable1TableAdapter">
</asp:ObjectDataSource>
<aspropDownList ID="DropDownList1" runat="server"
DataSourceID="odsUwnewsStaff" DataTextField="Per_SurName"
DataValueField="Per_PersonID">
<asp:ListItem Value="83">Name1</asp:ListItem>
<asp:ListItem Value="1">Name2</asp:ListItem>
</aspropDownList>
<asp:Button ID="Button1" runat="server" Text="submit" />