How to change the SelectMethod of ObjectDataSource programatically?

Question

Suppose I have a given ObjectDataSource, this objectdatasource "SelectMethod" property is set to "GetProjectsByUsername" of a class Project and accepting one parameter.

 <asp:ObjectDataSource ID="GetProjectsDataSource" runat="server" SelectMethod="GetProjectsByUsername"
    TypeName="BusinessLayer.Project">
    <SelectParameters>
        <asp:ControlParameter ControlID="hiddenUsername" Name="username" PropertyName="Value"
            Type="String" />
    </SelectParameters>
</asp:ObjectDataSource>

Now, Is it possible to change the SelectMethod property of this ObjectDataSource to a method that accepts two parameters during OnInit method? for example

MethodName : GetProjectByUsernameDeptCd()
Parameters : Username , DepartmentCode

I would like to change the select method by User Roles. I've tried to search SO and Internet but it seems that I have no luck on it. Anyway I wanted to do like:

if ( Role is Admin )
Use the default SelectMethod and Parameters that is declared in ASPX
else
Change the SelectMethod to "GetProjectByUsernameDeptCd"
Set parameter1 = value1
Set parameter2 = value2

Or I was thinking if there are other better ways to do this.

Thank You and Best Regards, Sherwin

score 5 · Answer 1 · answered Apr 25 '11 at 05:53

Yes, you can do this in the OnSelecting event of the ObjectDataSource in a code-behind file.

Ex.

protected void ObjectDataSource1_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
    {
        ObjectDataSource1.SelectMethod = "<YourSelectMethod>";
        e.InputParameters.Clear(); // this is a different method with new parameters.
        e.InputParameters.Add("Param1", "Value1");
        e.InputParameters.Add("Param2", "Value2");
        e.InputParameters.Add("Param3", "Value3");
    }

For more details please read below articles : 1. http://weblogs.asp.net/rajbk/pages/426642.aspx

Hope this will help..

Happy Programming!

Hi thanks, but I think changing the ObjectDataSource property in OnInit method is much faster. — Sherwin, Apr 25 '11 at 08:31

score 3 · Accepted Answer · answered Apr 25 '11 at 00:48

3

Try this

 GetProjectsDataSource.SelectMethod = "GetProjectByUsernameDeptCd";
 Parameter p1 = new Parameter("parameter1 ",TypeCode.String);
 Parameter p2 = new Parameter("parameter2 ",TypeCode.String);
 GetProjectsDataSource.SelectParameters.Add(p1);
 GetProjectsDataSource.SelectParameters.Add(p2);

answered Apr 25 '11 at 00:48

Bala R

107,317
23
199
210

Hi thanks, I will try this one. This one should be also done in OnInit of the page class right? – Sherwin Apr 25 '11 at 01:00
Hey thanks, can't believe this is so easy. >.< I was thinking of invoking delegates lol. – Sherwin Apr 25 '11 at 01:38

score 0 · Answer 3 · answered Apr 25 '11 at 00:46

0

Have you tried the C# codebehind? Instead of defining it in the aspx markup, go to the codebehind file, and do it there.

answered Apr 25 '11 at 00:46

John Batdorf

2,502
8
35
43

Well, basically I was asking on how to this in codebehind. :) – Sherwin Apr 25 '11 at 01:15

How to change the SelectMethod of ObjectDataSource programatically?

3 Answers3