|
WebSchedule.NET Databinding
The WebSchedule binds to a dataset the same way the WinForms component does. For
an explanation of this procedure click here.
The WebSchedule allows you to build an ASP.NET application and connect it directly
to a SQL Server database to serve an application to your users with robust scheduling
capabilities while storing all of their information almost with ease.
Internet (or browser-based) appointment scheduling and data storage go hand-in-hand.
The latter making the former much more useful. The default Gravitybox SQL Server
layout provides you with the ability to store appointments, categories, providers,
and rooms.
The code snippet was created in an ASP.NET WebForm with a WebSchedule on it named
"Schedule1". It demonstrates how to declare a controller, make a connection,
pull data, and bind a dataset. It connect to a local database with a database connection
string. The code will pull back all appointments for account "123" between
Jan 1, 2005 and Jan 5, 2005.
|
Dim controller As New Gravitybox.Controls.ScheduleDomainController controller.ConnectionString
= _ "data source=localhost;database=Gravitybox;uid=sa;pwd=45@QRThc; Dim ds As
System.Data.DataSet = _ controller.GetScheduleDataSet("123", #1/1/2005#,
#1/5/2005#) Schedule1.DataSource = ds
|
After the dataset is returned, it is bound to the WebSchedule. The WebForm then
render to the calling client with the appropriate appointments displayed on it.
That is it! There is nothing more you have to do to show a web page with appointments
loaded from a database.
|
|