Introduction
In the last article I gave you a brief overview of CodeCharge Studio (CCS). In this article I will straight dive into the depths of this tool and we will build a Simple Poll Application using this tool. This tutorial will highlight how easily you can build a fairly complex database driven application. I will split this tutorial in to parts so that its easier for you to read ( and me to write ;) ).

Application Summary
Let's first summarize the functionality we are looking out for before we start creating the application. The application will be divided into two logical parts the first part will be the Poll User Control (Includable Page in CCS). This user control can be placed on any other page where you want to display the poll hence you reuse the user control code.
The second section contains of the administration section where only the administrator is allowed access. Through the admin section the administrator can easily add, update delete the poll items. The Poll application will be created in such a way that there can be multiple choices per poll. Also a user can only vote once per poll. And at a given time only one poll can be active.

In this article I will only cover the creating of the administration section. In the further parts I'll complete the next part.

Database Design
Before you start creating any application in CodeCharge Studio you need to first design the database. In this example I will be using MS Access database, you can actually use any database you like. The descriptions of the 4 tables are given below for our vote.mdb file :

1) Members - This table is used to keep the username and password of the administrators who will be allowed to access the admin section of the application.

2) Vote_Details - This table stores the details of each poll. Also there it sets the active poll.

3) Vote_Items - This table stores the choices related to each poll. As I mentioned before each poll will support multiple choices, hence this table is used to store the choices for the poll.

4) User_Votes - This table stores the details of each users vote. Since we want a user to only vote once per poll we store his IP Address every time he votes.

This completes the database design, the relationships between the tables is shown in figure 1 below.

Figure 1: Tables Relationships

Creating a New Project
Once the database is ready its time to start you designing your application in CodeCharge Studio. Start up CCS and you will be shown the Project Dialog (see figure 2). Select New Project and click OK to start with a new CCS project.

Figure 2: Project Dialog

Figure 3: Create new Project

In the first General project properties page, don't change any properties and click Next to come to the database setup page. Here click on the Create button to create a new connection to our vote.mdb database. The Add New Connection dialog is shown, set the Connection Name as VoteDB and Database as MS Access. Its very important to set up the database, since Code Charge Studio uses this information to construct SQL queries appropriately for the database.
Also in case you want to use another database connection on the production server or you want to use specific Managed Providers like SqlClient Managed Provider or the ODBC Managed Provider, switch to the Server tab in the Add New Connection dialog and setup the properties there.
For this example click the Build button and link to your vote.mdb database file. Once done click OK to add a connection to the project.

Figure 4: Add New Connection

Figure 5: Authentication Settings

Once you finish the above settings click Next to move to the next page where you are given a list of tables from the database. Add all the tables to the Selected tables collection. This page helps you select the tables for which you want the builder to auto-generate the pages. Since in my case, I want to create a page to administer all the tables I select all of them. Click Next to arrive to the pages configuration step.

Figure 6: Page Configuration

This step is a very important step, and it gives you one place access to configure all your pages. Play around with this step as much as you can to better configure your pages. I will be outlining very few customization options, you will have to find others yourself ;).
First click on the All link since we want to update the properties for all the pages. Select both properties on this dialog (figure 7), the Search, Grid & Record on One Page option allows easy configuration and viewing of all the relevant options on one page. Remember the Grid form is used to list the contents of a table, the search form is used to search the table and show relevant records in the Grid form and the Record form is used to insert, update or delete a entry.
To collate all the forms on one page is good when you know the amount of data is less. The second option of Include in Menu allows the pages to be listed in a Menu , which is added on all pages for easy navigation. Click OK to close the dialog.

Figure 7: All Page details

Now, we will start configuring individual pages. Set the CheckBoxes to as shown below (figure 8). Basically I have removed Search option for all pages, since the data will be less. Also I have removed the Record and Updatable checkboxes for the user_votes page, since usually we don't rig poll's, do we ?? :)
Hence you will just be able to browse the list of users polling, but not directly add or update their details.

Figure 8: Updated page properties

Figure 9: members Record form properties

Figure 10: Select Theme

Publishing the Project
Now that you have come so far, you would be definitely waiting to check out how the code works, well we no further delay we publish our project so that the pages are uploaded to the server, and the code is compiled. Press F9 or select Project menu -> Publish Project to bring up the Project Settings dialog. If you have a local server use the default options, else select FTP from the Location dropdownlist and provide the appropriate credentials for your server. Click OK to compile and publish the project. If the project publishing directory does not exist on the local server you are prompted to create it.

Creating a Virtual Directory
All ASP.NET applications live within a Virtual Directory, so just publishing to a new directory is not enough, you need to convert this directory into a Virtual Directory. Use the IIS Manager from Administrative Tools to create a new Virtual Directory out of your publishing directory. You can also refer to the 2nd point of below linked article to learn to create a Virtual Directory.
[ www.mastercsharp.com/article.aspx?ArticleID=60&&TopicID=2 ]
Please do not skip this step or your application will give errors!!

Testing the pages
Once you have published your project, and created a Virtual Directory you are ready to test you pages. Navigate to the URL http://localhost/PollApp/members_list.aspx in your browser. Also add a new member with the Name admin and Pass admin. Some of you might be slightly worried at this point that the password textbox shows the password in clear text, well Code Charge Studio has no way of knowing from the database schema that you require a password textbox. So you can open the members_list page in CCS and change the Format->type property of the textbox to password.
There will be room for more such small adjustments, most of them can be fixed by adjusting the appropriate properties in CCS.

Live Page
Once you have published the project, you can shift to using Live Page tab for each page. This helps to have a quick look at the actual page that you have coded. When you shift to Live Page, CCS generates the current page and the necessary common files and compiles them. In order for the Live Page to show faster CCS does not generate all the pages, hence if you navigate (redirect) to another page from Live Page it will give an error!!

Adding a Index Page
Let's add a simple page that will contain a link to all the Admin pages, so its easier to navigate to them. Choose New -> Page from the File menu, in the New Page dialog choose Blank Page and set its name as admin and click OK.
Open the admin page in CCS Design view, and from the Toolbox window switch to the HTML controls. Select the Add HyperLink control and add the links to all the Admin pages (figure 11). Once you add the links to all pages, save the project.

Figure 11: Add Hyperlinks

Figure 12: Restricted Property