Setting up TMS Web Planner and Access Database [TMS Tut Part 1]
First: create the database named Planner.accdb, create a table named Scheduler inside with the ff fields:
Field: ID Type: AutoNumber
Field: Subject Type: Text
Field: Notes Type: Text
Field: StartTime Type: Date/Time
Field: EndTime Type: Date/Time
We will add necessary fields later. As for now that would do fine for a prototype.
Second: create an empty C# web application project in Visual Studio.
Make sure your TMS Web Planner Controls has already been integrated with Visual Studio Toolbox.
On your solution explorer right click and create a new folder named "Planner", add an empty ASP item on that folder name it "Planner.aspx"
Right-click on Planner.aspx file and select design. Drag and drop an Access DataSource object under Toolbox on Visual Studio.
Now configure the Access DataSource and connect it to the Planner.accdb file. I suggest you put the access database inside the App_Data folder on this project, for ease of deployment later on.
Next! drag and drop a DayController from the TMS Controls. I find the DayController suitable for this tut, but you can set any controller for the planner, depends on what you would like to achieve.
For our main object, drag and drop a WebPlanner object to the design. Set the Controller property on the properties tab to our DayController.
Alright! we're set for the code behind! Yay!
Field: ID Type: AutoNumber
Field: Subject Type: Text
Field: Notes Type: Text
Field: StartTime Type: Date/Time
Field: EndTime Type: Date/Time
We will add necessary fields later. As for now that would do fine for a prototype.
Second: create an empty C# web application project in Visual Studio.
Make sure your TMS Web Planner Controls has already been integrated with Visual Studio Toolbox.
On your solution explorer right click and create a new folder named "Planner", add an empty ASP item on that folder name it "Planner.aspx"
Right-click on Planner.aspx file and select design. Drag and drop an Access DataSource object under Toolbox on Visual Studio.
Now configure the Access DataSource and connect it to the Planner.accdb file. I suggest you put the access database inside the App_Data folder on this project, for ease of deployment later on.
Next! drag and drop a DayController from the TMS Controls. I find the DayController suitable for this tut, but you can set any controller for the planner, depends on what you would like to achieve.
For our main object, drag and drop a WebPlanner object to the design. Set the Controller property on the properties tab to our DayController.
Alright! we're set for the code behind! Yay!
Comments
Post a Comment