6: Building a Shopping Cart Application 143 in .NET

Creator Code 39 Extended in .NET 6: Building a Shopping Cart Application 143

Considering Some Basic Decisions 144 The User Interface145 The Product List page146 The Product Detail page 146 The Cart page146 The Check Out page148 The Completed page 152

Designing the Cart Database 153 The Customers table154 The Orders table155 The OrderItems table156 Creating the database 157 Adding some test data 159 Querying the database 159 Inserting order data into the database159 Connecting to the database 161 The Application s Folders 161 Designing the Classes 162 The Customer class162 The ShoppingCart class163 The CartItem class 164 The Order class 164 The OrderDB class 165 Building the Master page 165 Modifying the Product Detail Page 168 Building the Cart Page 171 The Cartaspx file 171 The code-behind file for the Cart page173 Building the Check Out Page 181 The CheckOutaspx file181 The code-behind file for the Check Out page 189 Creating the Customer Class 194 Creating the ShoppingCart Class 199 Creating the CartItem Class 203 Creating the Order Class 207 Creating the OrderDB Class 212

The Application s User Interface224 The Menu page 224 The Category Maintenance page224 The Product Maintenance page227 Designing the Application 229 Designing the Database 231 The Categories table 231 The Products table232 Creating the database 233 Adding some test data 234 SQL statements for the Categories table235 SQL statements for the Products table 236 Connecting to the database 237 The Application s Folders 238

Building the Master Page 238 Building the Menu Page 239 Building the Category Maintenance Page 240 The CatMaintaspx file 240 The code-behind file for the Catalog Maintenance page245 Building the Product Maintenance Page 249 The ProdMaintaspx file249 The code-behind file for the Product Maintenance page265

The Application s User Interface270 Designing the Application 271 Building the Database272 Designing the database272 Creating the database 274 Adding test data 274 SQL statements to retrieve the order data 275 Connecting to the database 276 Building the Master Page 276 Building the Order User Control 277 Building the Default Page 283 The Defaultaspx file 283 The code-behind file for the default page 284 Building the Print Order page286

Making Some Basic Decisions 289 The Content Management System s User Interface291 The Login page 292 The Home page292 The Department Home page 293 The Content List page294 The Content Detail page 295 Designing the Database 297 The Departments table297 The ContentTypes table 298 The ContentItems table 298 Creating the Database 299 Adding Test Data 301 SQL statements for working with the database 302 Connecting to the database 303 Creating the User Accounts 303 Building the Master Page 304 Building the Login Page307 Building the Home Page 308

Building the Department Home Page 309 Building the Content List Page 313 The Listaspx file 314 The code-behind file for the Content List page 317 Building the Content Detail Page 318 The Detailaspx file319 The code-behind file for the Content Detail page 325

Designing the Forum Application329 The User Interface for the Forum Application 331 The Forum Home page 331 The Threads page332 The Messages page 332 The New Thread page 334 The Post Reply page 334 Designing the Database 335 The Forums table 335 The Topics table 336 The Threads table 337 The Messages table338 Creating the Database 338 Adding Test Data 340 SQL statements for working with the database 341 Connecting to the database 342 Building the Master Page 342 Building the Forum Home Page343 The Defaultaspx page 344 The code-behind file for the Forum Home page346 Building the Threads Page 350 The Threadsaspx page350 The code-behind file for the Threads page353 Building the Messages Page355 The Messagesaspx page 355 The code-behind file for the Messages page 359 Building the New Thread Page 360 The NewThreadaspx page361 The code-behind file for the New Thread page 363 Building the New Message Page367 The NewMessageaspx page 368 The code-behind file for the New Message page371