Databases are the best way of dealing with content on your website. Learn SQL and how to add edit update and delete records in your database. ADO and paging recordsets using either a dsn or dsn-less connection. Either using SQL Server or MS Access, a data driven site is by far easier to maintain than static web pages.
So you need a DSN-Less connection but your not quite sure what to do. Well we can do this for you. A quick and easy way to make a connection without a DSN. This will work for your MS Access database only.
You fill in the blanks, and you are given the source code for the form, and a page to display the information in the database. Also the database is ready to download with all fields in your form
Adding a record from a database table is a simple task. Fill out the form below and click submit. The sql statement will be generated for you. It's just that easy.
Insert a table into a database dynamically. You don't even have to open MS Access. One simple asp does the trick! Using ADOX you can add and manipulate tables easily once you know how
Deleting a record from a database table is a simple task. Answer the four questions below and click submit. The sql statement will be generated for you. It's just that easy
I have seen many requests in forums and messageboards for counting records and displaying the total. Well, this little wizard will help you accomplish this task. Fill in the form below and it will crank out the code for you.
Many times people will make the mistake of naming a database field with an SQL Reserved word. This is an easy mistake to make. It's hard to remember EVERY single one. Here's a concise listing of SQL Reserved words to help you along.
In this tutorial I will guide through the creation of a simple Microsoft Access database to incorporating it in to your ASP web pages. Creating and making use of a database on the web is so very much easy that it will be only after reading this article you will realize the same and will then hopefully start creating databases according to your own needs and then playing with them from the web pages.
Windows DNA provides a means to provide your user interface, business logic and data sources as separate services working together in harmony over a distributed environment
In this example we will add a url to our sample database . Note there is no validation yet in this example (future version) but this shows how easy it is to add to a database , you could use this as part of a primitive link page system
