Hello Frank,

In my humble opinion, there is no event for that since dropdownlist itself is not our control.
I suggest you to use select parameter which you can change the value by using postback on dropdownlist itself. To know about how to select by using parameter, please kindly follow this current thread.

Regards,
Handy

Hi Handy,

Thank you very much for your reply. I am using parameters in other areas of my webscheduler development project so I am very familiar with your suggested solution.

However, I am not certain parameters will work in my scenario since using parameters appears to be  based on a SINGLE query. What I want to do is utilize TWO different queries.

How would I accomplish this if I were using an Intersoft dropdown list control? Is is even possible to invoke Events query 1 when user selects dropdown option 1 and invoke Events query 2 when user selects dropdown option 2?

There are basically TWO different select statements and I am not aware of any way to have two different select staements in the same sql query based on a parameter?

Thanks - Frank

Hello Frank,

Using our dropdown is also the same as your current dropdown control. The problem is, dropdown is not the part of our WebScheduler control.
That's why I said you can use this dropdown as parameter.
Based on what you said, it seems your case is different from our previous customer.
In my humble opinion, use dropdown only as options to change the query.
We have server side selecting event in ISDataSource. I think you can interrupt and change the query based  on your dropdown value in this event. Hope this helps.

Regards,
Handy 

Hi Handy,

Thank you for your prompt response.

You stated:

"use dropdown only as options to change the query
We have server side selecting event in ISDataSource. I think you can interrupt and change the query based on your dropdown value in this event"

This is EXACTLY what I have been trying to do with no success! In the events table adapter it does not appear that I can use compound queries as I get an error "The Declare SQL construct or statement is not supported" so it does not allow me to utilize two different queries or sub queries in the same single query.

I am able to use query 1 by itself and set the parameter on the ISDataSource Events table fine, and I am able to use query 2 by itself and set the parameter on the ISDataSource Events table fine, however I am NOT able to add a compound query for query 1 AND query 2 without getting the above error.

I also do not see a server side selecting event in the ISDATASOURCE anywhere, I have checked from top to bottom.

Can you adivise further?

Thanks! - Frank

Hello Frank,

After I discussed with our developers, I think there are two possible ways for you to do that.
1. Create a another table in your dataset. You can also fill the same datatable to the new table.
After that, everytime you Postback the option, you need to change the datamember property of the current events/resource/etc.
2. Or still use parameter. But you need to handle those queries in one StoreProcedure.  

Regards,
Handy

Hi Handy,

I was able to get it working using your option #1 above. Thank you!

I do have one remaining issue in my configuration. When a user one clicks a color bar, I am trying to "hide" the "Edit Event" button on the fly out dialog. I am able to hide the entire Edit Event dialog completely through the "OnEventSelected" client side event.

However, I would like to show the Edit Event dialog so the user can see the details, but not allow them to click the Edit Event button. Can the Edit Event button be hidden somehow?

Attached is a screen shot. Is this possible?

Thanks - Frank

Hello Frank,

Why don't you disable data editing from the first time? If not, you can also get the element of Callout and set display none for the button. To get the Callout element, simply use below code.

  function WebScheduler1_OnCallOutShow(controlId, action) {
            		    var WebScheduler1 = ISGetObject(controlId);
            		    var el = WebScheduler1.GetCallOutElement();
            		    if (el != null)
            		        if (el.style.display == "")
            		        //find until the button element and the display none
            		    return true;
        }

Regards,
Handy

Hi Handy,

I was able to resolve my issue simply by disabling the editing feature, (had not considered that one, thanks for pointing it out!).

Thank you for all your help. Your forum support is truly top notch!

Frank