Learn how to add records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
Similar scripts
A real easy way to add tables: ADOX
(Popularity: ) : After going through this online article, the webmasters can add tables to their database without any loss of data in an easy way by using ADOX. The author demonstrates how to insert the particular information into an ASP and can ... How To Retrieve XML Data in ASP with the XML OLE-DB Simple Provider
(Popularity: ) : The author explains about generating an ASP client which shows the OLEDB Simple Provider for XML to access XML data. The author describes about the task carried out by OLEDB Simple provider. With the help of standard methods of the ... EZ update
(Popularity: ) : This is an useful tutorial in content management system where the author focusses mainly on webpage content authorizing. You can learn to make use of VBscript in editing and updating webpage contents from a text file. The author has explained ... Add a new record to a database
(Popularity: ) : This is an useful tutorial for all the users who need to add the values to the database table. This tutorial shows you how to create the database connection as well as the recordset object and how to add the ... Access Databases(DSN vs DSN-LESS)
(Popularity: ) : Now the developers could come to a decision about accessing databases with or without DSN. The main usage of a DSN LESS connection is to increase the performance and speed. The example provided by the author helps the webmasters to ... Use ASP to create an HTML table that supporting paging and sorting
(Popularity: ) : The author tells the simple procedures to be followed to generate an HTML table which would be ready for paging and sorting. The values from one column could be linked with another page is the main advantage. The entire sample ... Connections and Server Database
(Popularity: ) : This tutorial guides the users in a friendly way making connections with database server and also it helps them to make permissions to access database using System DSN's. This article gives briefly definitions for each topic like how permissions are ... Connections And Server Database Permissions
(Popularity: ) : The author of this article describes about the SYSTEM DSN and DSN LESS Connections. The author also suggests that, the process can be implemented only with Access database. In the final part the author describes about how the permissions are ... Using GetDate Function in an SQL Statement
(Popularity: ) : This article is helpful for the database administrators which gives them solution for accessing the date and time of SQL server using GetDate function in an SQL statement. Syntax for this function has been given to test on their web ... Basic Database Publishing
(Popularity: ) : This is an online database tutorial from which the developers can refer detailed instructions which briefly explains about database interaction with ASP pages usig DSN or DSN-Less connection and also gives several tips to access, view and wrap up data ...
User reviews
Similar Software
SQL Help Builder
(Popularity: ) : Document all objects within a SQL Server Database schema plus add your own help topics. Now with SQL Help Builder you can personalize your database documentation by including your own topics and text, images, bullet points, tables, external HTML links ... SQL Script Builder
(Popularity: ) : SQL Script Builder is software that create a database sql script (or dump file) from any ODBC data source. The script produced will migrate the database (multiple tables selection) or create only one table and the records. Scripts are available ... MS SQL Recovery
(Popularity: ) : MS SQL recovery software recovers data from corrupt, damaged .mdf database files. It supports data recovery from SQL server version 2000 and 2005. SQL repair software recovers tables, views, triggers, stored procedures, damaged unique keys, primary keys and foreign keys. ... Godsw SQL Compare
(Popularity: ) : What is Godsw SQL Compare? Godsw SQL Compare is the powerful database schema/data comparison and synchronization tool for SQL Server database development projects. Godsw SQL Compare integrates with SQL Server, providing an effective and effortless database schema comparison for individuals ... CBL C# ASP.NetWeb Application Builder
(Popularity: ) : Instantly Generate C# ASP.Net Ajax Web Database Relational Applications that are N-Tier, Feature-Packed, User-Friendly and Efficient - without programming!
Creates readable C# code, Visual Web Developer / Visual Studio project, and efficient Stored Procedures, giving programmers the freedom to further ... SQL.CLR
(Popularity: ) : SQL.CLR generates CLR stored procedures and user defined functions from existing procedures and functions in SQL Server. The stored procedure or user defined function code can be generated in C# or VB.net, compiled into an assembly and even create a ... MCBase
(Popularity: ) : MCBase V3.6: the Music Collection dataBase system. A flexible, yet easy to use tool for managing your (multi media) music collection. MCBase stores your memos in Rich Text format and stores graphics, sound and video clips in any format required ... PictureBook
(Popularity: ) : PictureBook V1.7: Your Personal Graphics database. A flexible, easy to use tool for managing all your graphics, photos and other images. PictureBook can store additional descriptions in its memofields (RTF supported), can handle common image file formats and has search/filtering ... OmniAudit
(Popularity: ) : OmniAudit automatically and transparently tracks changes to data in any column of any table in your Microsoft SQL Server 7.0 or 2000 databases. Simply select the tables and columns you want to audit, and OmniAudit does everything for you. OmniAudit ... MSISQL (ISQL for Microsoft SQL)
(Popularity: ) : MSISQL (Interactive SQL for MSSQL) is a database administration solution for managing Microsoft SQL databases. It allows to build SQL queries using SQL Editor with SQL syntax highlighting and SQL Query History features; build SQL queries using Visual QueryBuilder; automate ...
Script Library
) : After going through this online article, the webmasters can add tables to their database without any loss of data in an easy way by using ADOX. The author demonstrates how to insert the particular information into an ASP and can ...