Intersoft Community - WebScheduler - Dynamically setting connection string to DataSet.xsd in ISDataSource event creates a problem

Dynamically setting connection string to DataSet.xsd in ISDataSource event creates a problem

jig214@yahoo.com — Fri, 21 Mar 2014 08:39:30 GMT

Hi Bernard,

Thanks for the response.

I have forwarded the project zip folder, DB script and error snapshots in a word document.

Please check and let us know the fix for our problem.

NOTE : We do not have any custom class to Insert , we are just using the same table adapters which were created by default (WebschedulerData.cs).

I have also sent you the schedulerDB which we are using for our events to store,resources etc.

It is plain DB which was created by the Webscheduler itself (no customizations)...

Problem statement is :

When user logs in, I would determine the connection string required for that user from our ClinicalDB and then in the ISDatasource_ObjectCreated event, I would apply that connection string dynamically.

So, you can just import that attached DB 3 times and rename them as

SchedulerDB_CLC1

SchedulerDB_CLC2

SchedulerDB_CLC3

With this step you will have your environment setup which is required to reproduce our problem.

Dynamically setting connection string to DataSet.xsd in ISDataSource event creates a problem

bernardx — Thu, 20 Mar 2014 22:38:49 GMT

Hi Jignesh Patel,

You can email your sample project to bernard@intersoftpt.com . Regarding to your scenario above, maybe there were incorrect function that causing WebScheduler to throw the exception from server. Is there any custom class for your insert method in your project? I will investigate your issue in here and I will wait for your sample. It might help us to determine where the problem comes from. Look forward to hear any feedback from you.

Regards,
Bernard

Dynamically setting connection string to DataSet.xsd in ISDataSource event creates a problem

jig214@yahoo.com — Thu, 20 Mar 2014 19:46:34 GMT

Hi Intersoft,

I have to get the connection strings from database based on the site login and apply retrieved data to ISDatascource which inturn display the events,resources etc in the WebScheduler.

So, i have written the required code in ISDataSource 's Object created event. This complete things works just fine, i mean... i would get the connection strings based on the login id and WebScheduler displays the resorces,events etc perfectly.

But, i am stuck with an unknown exception "Exception has been thrown by target of invocation" while creating an event, creating category etc (basically all insert statements)

Displaying,deleting all things works as expected...but only insertion is problem.

We have bought the WebUI studio licence and if you want our order id to provide premium support, please let us know. I would provide them seperately to any of your email. Also i have created a sample project with DB script to reproduce this issue which i can share with you too.

Your help is much anticipated...thank you.