Change / set ObjectDataSourc e paramater at runtime?

[planetthoughtful]

Hi All,

I have an ASP.NET page that displays a GridView control based on an
ObjectDataSourc e control.

I'm wondering if it's possible to base the ObjectDataSourc e in question
on a parameter query, with the ability to set the parameter value at
run time (in the Page_Load event, perhaps?)?

Basically, I'd like to display records in the GridView based on values
typed into a text box. So, I guess I'm looking to base the
ObjectDataSourc e on a SELECT query similar to:

SELECT column1, column2, column3 FROM table1 WHERE column1 = @col1val;

Can anyone tell me if it's possible to set a parameter for an
ObjectDataSourc e at runtime, and how you'd do that if it is possible?

Many thanks in avance!

Much warmth,

planetthoughtfu l
---
"Lost in thought"
http://www.planetthoughtful.org

[Joe Mayo (C# MVP)]

Hi Planetthoughtfu l,

You can configure the ObjectDataSourc e to get its contents from a control on
the page. Select configure data source in the Gridview action list an run
through the wizard, selecting Control as the parameter type, or modify the
HTML like this:

<asp:ObjectData Source ID="ObjectDataS ource1" runat="server"
SelectMethod="G etCustomers"
TypeName="Custo mers">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="Text Box1" DefaultValue="* "
Name="filter" PropertyName="T ext"
Type="String" />
</SelectParameter s>
</asp:ObjectDataS ource>

Use something like this if you want to dynamically set it in code:

ObjectDataSourc e1.SelectParame ters[0].DefaultValue = "<your value>";

Joe
http://www.csharp-station.com

"planetthoughtf ul" wrote:

Hi All,

I have an ASP.NET page that displays a GridView control based on an
ObjectDataSourc e control.

I'm wondering if it's possible to base the ObjectDataSourc e in question
on a parameter query, with the ability to set the parameter value at
run time (in the Page_Load event, perhaps?)?

Basically, I'd like to display records in the GridView based on values
typed into a text box. So, I guess I'm looking to base the
ObjectDataSourc e on a SELECT query similar to:

SELECT column1, column2, column3 FROM table1 WHERE column1 = @col1val;

Can anyone tell me if it's possible to set a parameter for an
ObjectDataSourc e at runtime, and how you'd do that if it is possible?

Many thanks in avance!

Much warmth,

planetthoughtfu l
---
"Lost in thought"
http://www.planetthoughtful.org

[planetthoughtful]

You can configure the ObjectDataSourc e to get its contents from a control on
the page. Select configure data source in the Gridview action list an run
through the wizard, selecting Control as the parameter type, or modify the
HTML like this:

<asp:ObjectData Source ID="ObjectDataS ource1" runat="server"
SelectMethod="G etCustomers"
TypeName="Custo mers">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="Text Box1" DefaultValue="* "
Name="filter" PropertyName="T ext"
Type="String" />
</SelectParameter s>
</asp:ObjectDataS ource>

Use something like this if you want to dynamically set it in code:

ObjectDataSourc e1.SelectParame ters[0].DefaultValue = "<your value>";

Hi Joe,

Thanks for this answer! I managed to work my way around this problem in
the interim by using an SqlDataSource for the GridView, and explicitly
setting the SELECT statement with a variable value in the WHERE clause,
but it's great to know how to achieve the same thing using
ObjectDataSourc es as well!

Thanks again!

Much warmth,

planetthoughtfu l
---
"Lost in thought"
http://www.planetthoughtful.org