Hi everybody. I am tryin to use SQL Server with a WebSchedule, but I don´t have idea with how to use it, I mean, for example add appointments. I want to know how to modify it to use SQL Server.
Thanks a lot.
There is a SQL install script that you can run (using osql or Studio Express) that will create a standard WebSchedule database, see the following help topic for where this install script is installed.
https://ko.infragistics.com/help/aspnet/webschedule-overview-of-the-stored-procedures-used-by-the-webschedule-data-providers
This next help topic walks through binding to an AccessDataSource and the WebScheduleOleDbDataProvider control. Just use a SqlDataSource control and the WebScheduleSqlClientDataProvider control instead and otherwise pretty much follow the same steps, connecting your SqlDataSource control to the SQL Server database you created with the install script I mentioned above.
https://ko.infragistics.com/help/aspnet/webschedule-connecting-webschedule-to-a-database-in-visual-studio-2005
For information on programmatically loading/updating/deleting appointments to/from the database outside of the normal UI presented by the WebSchedule views (doesn't much matter if its Access or SQL Server at this point because the Data Provider model is designed to abstract away this implementation detail), see several of the How-To's on this page.
https://ko.infragistics.com/help/aspnet/web-webschedule
When you are planning or ready to deploy to SQL server, read the background topics on the following page.
https://ko.infragistics.com/help/aspnet/web-deploying-webschedule-controls-and-components-landing
Well all these links are dead, was hoping to follow this, the controls are great and would really like to use them in vb.net but there seems to be little to no help at all.
I can hook everything up on the screen so one control updates another-one but what and how it gets data in to and out of the SQL is none existent!