ASP.Net Classifieds Starter Kit

  • Technology: ASP.Net 2.0/Dataset
  • Language: c#

Original Open Source Application

ASP.Net Classifieds Starter Kit  ASP.Net Classifieds Starter Kit  ASP.Net Classifieds Starter Kit  ASP.Net Classifieds Starter Kit 

The Classifieds Starter Kit provides a complete, ready to run, fully customizable, Web site for listing and managing classified advertisements.

Easily create ad listings

  • Creating an ad is as simple as selecting the category, entering the ad details, and uploading images

Built-in search and categories simplifies finding ads

  • Built-in search enables visitors to easily find what they want
  • Customizable categories make it easy for administrators to tailor the site as needed

Built-In Site Administration

  • Advertisements and Locations
  • Users
  • Site Settings

Technologies and Design Approaches Demonstrated:

  • Three-tier architecture
  • User controls
  • Theming and Master pages

1ManDay.com App: Classifieds Starter Kit

This App contains the all portions of the ASP.Net Classifieds Starter Kit related source code, including data access layer (DAL), business logic layer (BLL) and user interface.

Setup and Running

Database Setup - Easy Way (for local installaion of SQL Express)
  1. Skip this step if using Windows Authentication and the server instance is localhost\SQLExpress. Open and edit \App_Data\Setup.bat to give the correct value for variable DBUser, DBPwd and DBServer.
  2. Double click \App_Data\Setup.bat to execute the batch command scipt file to create database and tables.
Database Setup - Custom Way
  1. Run \App_Data\CreateDatabase.sql in Microsoft SQL Server Management Studio to create database "[Your App Name]_1ManDay_CFv1".
  2. Run \App_Data\CreateTables.sql in Microsoft SQL Server Management Studio to create databaes tables on database "[Your App Name]_1ManDay_CFv1".
  3. Run aspnet_regsql.exe against the new database "[Your App Name]_1ManDay_CFv1".
Insert Sample Data (optional) - Easy Way
  1. Skip this step if using Windows Authentication and the server instance is localhost\SQLExpress. Open and edit \App_Data\InsertSampleData.bat to give the correct value for variable DBUser, DBPwd and DBServer.
  2. Double click \App_Data\InsertSampleData.bat to execute the batch command scipt file to insert sample data.
Insert Sample Data (optional) - Custom Way
  1. Run \App_Data\InsertSampleData.sql in Microsoft SQL Server Management Studio to insert sample categories data into database "[Your App Name]_1ManDay_CFv1".
Source Code Setup
  1. Open App folder in Visual Studio as a Web Site.
  2. Open \web.config. Modify the database connection string in <connectionStrings> if your SQL Server instance is not ".\SQLExpress" or not using Windows Authentication.
  3. Open \web.config. Modify the email server settings in <smtp>.
  4. Build and run the web site.
Running this App
  1. Click "Create an Account" link in User Login page.
  2. The default role of newly created users is Guests. You can add users to role Administrators by clicking ASP.NET Configuration in Website menu of Visual Studio.
  3. If "Insert Sample Data" steps were not executed, you must add categories for your objects before you can starting creating a record of your object; otherwise, an SQL exception will be raised by the application.

Things to Note

  1. If your App contains more than 1 object, you have to
    1. Modify web.sitemap file to manage the menu items in top menu;
    2. Modify MasterPage.master to remove unnecessary Browse [XXXX] Categories links;
    3. Modify MasterPage.master to remove unnecessary [XXXX] Search buttons;
    4. Modify MasterPage.master to remove unnecessary What's New button;
    5. Modify MasterPage.master to remove unnecessary shortcut links on the left;
    6. Modify MasterPage.master to remove unnecessary Categories links;

Frequently Asked Questions

  1. Q: Exception raised when creating a new record "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_[XXXX]s_[XXXX]Categories". The conflict occurred in database "[XXXX]_1ManDay_CFv1", table "dbo.XXXXCategories", column 'Id'. The statement has been terminated.
    A: You must create a category using an administrator account before you can add objects.

Customize this open source App now!