Makeyour own banner managementsystem with ASP (continued)
Saving the banners
Thenext step involves the useof SQL Server 2000 Enterprisemanager to create our tables,and an ASP script to addour banner to the database.Start off by firing up EnterpriseManager (Start -> Programs-> Microsoft SQL Server-> Enterprise Manager).This is the program thatlets us create our databaseand tables.
We want to create a newdatabase. Call the new databasemyAdStuff. Once you've createdthe database, we'll needto create just one simpletable named banners. Thefields for this table areshown below (note that thebannerId field is an autoincrementing identity field,so make sure you set itsidentity property to "yes"and make it a primary key.
Now that we've created ourdatabase and our bannerstable, we can close SQLServer Enterprise managerand start on the ASP codeto add a banner to our database.
Top quality daily ASP, PHPand .NET articles, tutorials,news, reviews, interviewsAND FREE EBOOKS! devArticlesis the ultimate online resourcefor the serious web developer.Visit
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
More Web Development Articles
More By Developer Shed