Is there something similar to http://help.infragistics.com/Help/NetAdvantage/NET/2007.3/CLR2.0/html/WebSchedule_Connecting_WebSchedule_to_a_Database_in_Visual_Studio_2005.html but
for the MS SQL database?
I have been trying to get schedule working with a SQL DB and I am having quite a bit of difficulty. Here are the things that I have done, create a SqlDataSource, WebScheduleSqlClientProvider, WebScheduleInfo and a WebMonthView. On the back end I created a database by impoting from the Access database that was provided in the samples. Are there scripts available to create the needed stored procedures?
Here is the error I get: Could not find stored procedure 'Resource_SelByName'.
here is my code:
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ScheduleConnectionString3 %>" SelectCommand=";"></asp:SqlDataSource>
<ig_scheduledata:WebScheduleSqlClientProvider ID="WebScheduleSqlClientProvider1" runat="server" StyleSetName="" StyleSetPath="" StyleSheetDirectory="" WebScheduleInfoID="WebScheduleInfo1" DataSourceID="SqlDataSource1"></ig_scheduledata:WebScheduleSqlClientProvider>
<ig_sched:WebScheduleInfo ID="WebScheduleInfo1" runat="server" StyleSetName="" StyleSetPath="" StyleSheetDirectory=""></ig_sched:WebScheduleInfo>
<ig_sched:WebMonthView ID="WebMonthView1" runat="server" WebScheduleInfoID="WebScheduleInfo1"></ig_sched:WebMonthView>
</div>
The data types and logic are different in Transact-SQL than they are in Access, so migrating from an Access .mdb will not work. There is an install SQL script included that contains all DDL (data definitions) and DML (stored procedures), you should run that.
See this help topic for more information on where to find the install script and answers to questions about deploying to MS SQL in general,
http://help.infragistics.com/Help/NetAdvantage/NET/2007.3/CLR2.0/html/WebSchedule_Deploying_to_Microsoft_SQL_Server.html
Thank you