Custom SQL Server Provide HowTo

[Paul Nascimento]

(Search forums: Done)
(Look through tutorials: Done)
(Browse online examples: Done)
(Look at giant tutorial PDF: Done)

Hi all.
I'm looking for a complete, stand alone, start to finish, example of how to implement the Scheduler, with multi-value resources. I've found lots of bits and pieces here and there in the examples and so forth that seem to always assume knowledge of yet other things, but nothing *complete* and *stand alone*.

Thanks a bunch for your patience!

Paul

[Peter]

Hello Paul,

Please, find attached a complete, stand alone demo of RadScheduler with Multi-valued resource provider. Let me know if you have further questions.


Regards,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Paul Nascimento]

Hi Peter,
Thanks for the quick reply. I took your code and put it into a new project. It compiled fine, but it's having a problem opening the DB connection. I don't use sqlexpress, maybe that's the problem?

In any case, if I could access that mysterious "*.mdf" data file and find out what the schema and data are, I could perhaps replicate that in my Sql Server database, which is what I wanted to do in the first place.

Thank!

[Peter]

Hi Paul,

In Visual Studio, if you double click the Telerik.mdf file, this will cause Server Explorer to automatically open a connection so you can view the tables.


Greetings,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Paul Nascimento]

I tried that, it gives me a message about having to have SQL Server 2005 express installed. I'm doing this on my development machine at work, and don't want to install Express (there's a chance it will mess up my Sql 2008 installation - I've seen similar things happen before)

[T. Tsonev]

Hello Paul,

In this case attach the database to your SQL Server instance and change the connection string to point to your server instance.

I hope this helps.

Best wishes,
Tsvetomir Tsonev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Dan]

Hi,
  I'm trying to load this demo and am getting the following error.  Can you give me a hint as to what might be wrong?

Thanks!
Don



 

Server Error in '/multivaluedresourceprovider' Application.

---

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Expecting non-empty string for 'providerInvariantName' parameter.

Source Error:

Line 113: <radScheduler defaultAppointmentProvider="Integrated"> Line 114: <appointmentProviders> Line 115: <add name="MultiValuedResourcesProvider" type="MyDbSchedulerProvider" connectionStringName="TelerikConnectionString" persistChanges="true" />Line 116: </appointmentProviders> Line 117: </radScheduler>

Source File: C:\Users\donharri\Desktop\multivaluedresourceprovider\web.config    Line: 115

---

Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4955


And now this message if it helps to elucidate anything:

 

Server Error in '/multivaluedresourceprovider' Application.

---

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Expecting non-empty string for 'providerInvariantName' parameter.

Source Error:

Line 113: <radScheduler defaultAppointmentProvider="Integrated"> Line 114: <appointmentProviders> Line 115: <add name="MultiValuedResourcesProvider" type="MyDbSchedulerProvider" connectionStringName="TelerikConnectionString" persistChanges="true" />Line 116: </appointmentProviders> Line 117: </radScheduler>

Source File: C:\Users\donharri\Desktop\multivaluedresourceprovider\web.config    Line: 115

---

Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4955

[Peter]

Hello Don,

Please, try deleting  '</appointmentProviders>' at Line 116 in your web.config file.


Kind regards,
Peter
the Telerik team

[Dan]

Ok, I tried that but as might be expected, the computer issues warnings because </appointmentProviders> is the end tag of <appointmentProviders>.  So, on the off chance that you meant to remove the entire  <appointmentProviders>  section, I did so and received the following message:

 

Server Error in '/' Application.

---

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: An error occurred creating the configuration section handler for telerik.web.ui/radScheduler: Could not load file or assembly 'Telerik.Web.UI, PublicKeyToken='blahblahblahRemovedForSecurityPurposes'  or one of its dependencies. The system cannot find the file specified.

Source Error:

Line 27: Line 28: <sectionGroup name="telerik.web.ui"> Line 29: <section name="radScheduler" type="Telerik.Web.UI.RadSchedulerConfigurationSection, Telerik.Web.UI, PublicKeyToken=blahblahblahRemovedForSecurityPurposes" allowDefinition="MachineToApplication" requirePermission="false"/>Line 30: </sectionGroup> Line 31:

Source File: C:\Programming\WebbApp\MyWebApp\web.config    Line: 29

Assembly Load Trace: The following information can be helpful to determine why the assembly 'Telerik.Web.UI, PublicKeyToken='blahblahblahRemovedForSecurityPurposes' could not be loaded.

WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

---

Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4955


Thank you,

Don

[Peter]

Can you open a support ticket and send us your web.config file?

Kind regards,
Peter
the Telerik team