Hi
I am looking at the sample and there is no recurrence as part of the example. Looking through the documentation on WebScheduleGenericDataProvider it says:
"The data model for WebSchedule has changed since the addition of WebScheduleGenericDataProvider. First thing you will notice is that the Recurrence table is removed and additional fields are added to the Activity and Resource table. The following table lists the required fields for the different types of data to function correctly in WebSchedule."
I want to create the tables in my own SQL Server database, using the default table names would be ok. Can you please offer some guidance as I am somewhat confused as I also want to implement the Recurrence functionality.
Thank you.
David
Hello David,
Below there is an online sample regarding using WebScheduleGenericDataProvider with AccessDataSource
http://samples.infragistics.com/2010.3/WebFeatureBrowser/contents.aspx?showCode=true&t=WebSchedule/WebSchedule_GenericDataProvider_DataSource.aspx~srcview.aspx?path=~srcview.aspx?path=WebSchedule/WebSchedule_GenericDataProvider_DataSource.src
The database regarding this sample can be found here if you have installed the Samples on your machine:
C:\Users\Public\Documents\Infragistics\NetAdvantage 2010.2\ASP.NET\Samples\App_Data\WebScheduleGenericDataProviderSample
If you meet difficulties regarding decoding the Recurrence pattern please take a look at the below forum post:
http://news.infragistics.com/forums/p/37591/218024.aspx#218024
Let us know if you need further assistance regarding this
Hi Tsvetelina
I do not think you have answered my question. The resource table in exists in your sample but according to the documentation below:
The data model for WebSchedule has changed since the addition of WebScheduleGenericDataProvider. First thing you will notice is that the Recurrence table is removed and additional fields are added to the Activity and Resource table. The following table lists the required fields for the different types of data to function correctly in WebSchedule."
This conflicts with the sample?
Thank you for the update.
You are right. The Resources table exists in my sample and according to the documentation Recurrence table is removed and additional fields are added to the Activity and Resource table.
These are two different tables.If you look at the sample
You will see that it is using WebScheduleGenericDataProviderSample.mdb
This database contains 2 tables. In Activities table there is field RecurrencePattern.
It contains the Recurrence information which was contained in the Recurrence table :
DayOfWeekMaskUtc;UtcOffset;DayOfMonth;MonthOfYear;PeriodMultiple;Period;EditType;
EndAfterDays;LastReminderDateUtcTicks;
This is the format.
If you open WebSchedule2.mdb you will see that Recurrence table persists in this database.
It contains exactly the same fields as the RecurrencePattern (from the WebScheduleGenericDataProviderSample database)
Please let me know if you feel that I haven't answered your question.
Hello Tsvetelina
Thank you, I understand now! What is the preferred methodology if I am going to connect to SQL Server, as you have pointed me to Access examples.
Thanks again.
With the generic Data Provider, you don't need to be tied to any schema, the important thing is to define the mappings between Appointment / Resource properties, and actual Data Store. You can bind to DataSet, IEnumerable, SQL, ObjectDataSource, etc. Here are some examples to get you started:
http://help.infragistics.com/NetAdvantage/ASPNET/2010.3/CLR4.0/?page=WebSchedule_WebScheduleGenericDataProvider_CRUD_Statements_for_SQL_Data_Source.html
http://help.infragistics.com/Help/NetAdvantage/ASPNET/2010.3/CLR4.0/HTML/WebScheduleGenericDataProvider_About_WebScheduleGenericDataProvider.html
If you want to use the SQL WebSchedule provider , keep in mind that it relies on a very specific schema, and that's why we ship stored procedures and SQL scripts in the actual installation, which you run and it builds the above tables for you.
The below forum post explains how this can be done:
http://news.infragistics.com/forums/p/11575/44706.aspx#44706
Let me know if you need further assistance regarding this.
Thank you!