Hello,

You will need to select by using parameter in your query. The parameter should be specific "Resources". Here is my attached sample. I am using parameter session to show you that the resources would select only the parameter i set. Hope this helps.

Regards,
Handy

Hello Naaz,

It does not matter. You only configure your query to select more than one parameter in your select Resources. Then, add parameters that you would like to use. Please see my attached sample, I assign two sessions as the parameter.

Regards,
Handy

Dear Handy,

Thank you so much for the great response. Is this application if the Parameter is in difference in number.

I have two managers. One manager is having 4 employees working under him and one manager is having 3 employees working under him and each and everyone want to see the schedule of his employees. It can be implemented at run time. i mean can i pass the paramater at runtime. The query which i was trying is something like that

SELECT ID, ResourceName, Description, Location, ResourceColor
FROM Resources
WHERE (ID IN (?))

If i pass one parameter it works file but i can't pass more then one parameter in it. Could you please advise what is the best approach to achieve what i am looking. I have a login. As far as the person logon i am getting a string of resource working under him like 2,3,5,7 or 1,4,6 etc...

Please guide me how to pass the query at runtime..

Many Thanks,
Naaz

Hello Naaz,

It is not possible to do that directly. As you can see in previous project, in my dataset for table Resources, you can see what query I used.
The problem is you could not dynamically change its parameter.

e.g 
My custom select method is:

SELECT        ID, ResourceName, Description, Location, ResourceColor
FROM            Resources
WHERE        (ID = ?) OR (ID = ?)

My suggestion is, provide some parameters to be called in your query.
e.g

SELECT        ID, ResourceName, Description, Location, ResourceColor
FROM            Resources
WHERE        (ID = ?) OR (ID = ?) OR (ID = ?) OR(ID = ?) OR(ID = ?) OR(ID = ?) OR(ID = ?)

Then, validate in your login information. If user has 3 parameters such as 1,2 and 3, You will need to substring "," and split each values. After that, add each values into the parameter.

e.g 
in ISDataSourceSelecting serverside event, define

 e.InputParameters[0] = 1;
 e.InputParameters[1] = 2;
 e.InputParameters[2] = 3;

 It will run the query like this:

SELECT        ID, ResourceName, Description, Location, ResourceColor
FROM            Resources
WHERE        (ID = 1) OR (ID = 2) OR (ID = ?) OR(ID = 3) OR(ID = null) OR(ID = null) OR(ID = null)

Regards,
Handy

Hello Handy,

Can you please send me this application with framework 2.0 support. I have vs2008 and i am using FW 2

Many thanks and waiting

Naaz

Hello Naaz,

Ok, Thank you for the confirmation. I could not mark this as the aswer because this a discussion thread. 

Regards,
Handy