|
|
|
|
|
Total Hits: 53 | Today: 0 |
Author: classicasp.aspfaq.com
|
Rating:
|
|
|
I created a simple table, with an Autonumber column and a text(50) column. I created a macro that would insert rows with random characters into the text columns. I set the repeat on the macro to 30,000 and ran it. While I was waiting for Access to struggle through the task and release my CPU so I could do other things on the box, I went and brushed my teeth. When I came back, it wasn't finished yet. So I read Tolkien's trilogy. When it finally completed the task, I observed the size of the MDB f...
|
|
|
|
Total Hits: 311 | Today: 0 |
Author: David Catherman
|
Rating:
|
|
|
Part of the business logic encapsulated in the Typed DataSet is the ability to add specialized queries to the table adapters to retrieve the data with different filters. By manipulating the XML schema that defines the dataset and adding the correct XML metadata, Visual Studio will generate the added queries for us. In this article, filtering queries will be automatically added to each table adapter for each field that is indexed on the table in the database....
|
|
|
|
Total Hits: 243 | Today: 0 |
Author: Melchior
|
Rating:
|
|
|
The SQL query execution is based on two factors. They are
1) Formation of Execution plan and
2) Execution of query based on that execution plan
So the query execution time is based on the above two factors. The query execution time is calculated by summation of time taken to form execution plan and time taken to execute the SQL query based on that execution plan....
|
|
|
|
Total Hits: 297 | Today: 0 |
Author: Todorov
|
Rating:
|
|
|
RecordSet.GetRows method, the best way to retrieve data with ADO! GetRows, does this sound familiar? If not, then it’s time to learn how to retrieve/manipulate your data more efficiently with ADO.The ultimate goal of the software development is to produce efficient, easy to maintain and highly scalable applications. An application can be called scalable if it has the ability to serve a large number of concurrent users without incurring a performance penalty.One of the most common tasks in progra...
|
|
|
|
Total Hits: 246 | Today: 0 |
Author: Faisal Khan
|
Rating:
|
|
|
In this article we will learn on how to use database transactions in ASP. This will allow us to execute all database queries or none at all. How many times have you wanted to insert, update a lot of records collectively wanting that either all of them get executed or if there is an error then none is executed at all ? Well, if you haven't this need yet, you will have it in near future....
|
|
|
|
Total Hits: 312 | Today: 0 |
Author: Adrian Bacaianu
|
Rating:
|
|
|
Some time ago, I was put in a very new and strange situation. My company built a new financial site based on an old skeleton site. It was necessary to transfer a lot of data from the old database (Access 97) to the new one (Microsoft SQL 7).Which was the problem? - all the data from the old DB was written in Greek code page and the new DB was to be written in Unicode. Another request from the customer was to have online data in both sites. That means that when someone introduces code page data i...
|
|
|
|
Total Hits: 202 | Today: 0 |
Author: Dinesh Asanka
|
Rating:
|
|
|
Backing up and restoring SQL Server database backups is an important day-to-day operation that all DBAs and database developers perform. Most of us are using SQL Server’s native backup capability to perform this task. Of course, why would we spend additional money on a third-party tool if we can get backup and restore capability at no extra cost? There are a couple of strong reasons for purchasing a third-party backup tool for your organization. Some of which include...
|
|
|
|
Total Hits: 286 | Today: 0 |
Author: Tom Wellige
|
Rating:
|
|
|
Universal Table Editor is an ASP application to view and edit data in any database you can reach via ADO from your IIS. Compatible databases are e.g. MS Access™, MS SQL Server™ or Oracle™. UTE is also able to export the data of a table into comma delimited text files (.CSV) which are readable e.g. by MS Excel™....
|
|
|
|
Total Hits: 206 | Today: 0 |
Author: Mr.Spock
|
Rating:
|
|
|
Cannot update. Database or object is read-only. Operation must use an updateable query. General error Unable to open registry key. Could not find file. Could not use '(unknown)'; file already in use. Table 'tblTable' is exclusively locked by user 'Admin' on machine 'MyMachine'. Too few parameters. Expected. Either BOF or EOF is True, or the current record has been deleted. Item cannot be found in the collection corresponding to the requested name or ordinal. The search key was not found in any r...
|
|
|
|
Total Hits: 200 | Today: 0 |
Author: Johnny Papa
|
Rating:
|
|
|
Much of the success of the ADO Recordset can be attributed to its lightweight structure and easy-to-use interface. Now with the introduction of the ADO.NET DataSet, you can represent more than one data structure, making the ADO Recordset even more flexible....
|
|
|
|
Total Hits: 161 | Today: 0 |
Author: Rama Ramachandran
|
Rating:
|
|
|
ASP programmers frequently develop Web apps that rely on displaying data within forms linked to a back-end database. To do this, you either create forms displaying data contained within a database, or display a form whose data you plan to place within a database when the form is submitted. In this column I'll share some useful form-building routines that will take some of the grunt work out of developing and maintaining those HTML forms....
|
121 WAM!  |
Version: 1.0
|
Price: $99.00 / Free Trial
|
|
|
Total Hits: 460 | Today: 0 |
Author: 121 Software
|
Rating:
|
|
|
The first FTP client that can transfer databases. With 121 WAM! you can drag and drop database tables from one Microsoft Access, SQL Server, MySQL or ODBC database into another over the Internet. Additional features include advanced file and data synchronization options, FTP support, and more, making 121 WAM! the ideal choice for maintaining database-driven web sites....
|
|
|
|
Total Hits: 808 | Today: 0 |
Author: ASPFree
|
Rating:
|
|
|
This is good example for you if you want to populate a dropdown box from a database table to an ASP page. You can also download demo code.
...
|
|
|
|
Total Hits: 1304 | Today: 0 |
|
Rating:
|
|
|
This script is for creating SQL Server Databases online and remotely through a web browser. A unique User Login is created together with the new database and added to that database's login on SQL Server. A feature that should always be used to tighten security as most as possible on SQL Server....
|
|
|
|
Total Hits: 2098 | Today: 0 |
|
Rating:
|
|
|
Anytime you have a user login application on the web, you need to be able to give the user the ability to update their profile. One way to do this is with a form that populates itself with the users information which is stored in a database....
|
|
|
|
Total Hits: 781 | Today: 0 |
|
Rating:
|
|
|
This script converts a complete Access database to a SQL Server database or reverse. Options are provided for converting the struture only, or structure and values....
|
|
|
|
Total Hits: 705 | Today: 0 |
Author: Annette Tennison
|
Rating:
|
|
|
In part one of this two-part article Annette, show us how to create an ASP class that allows us to work with our databases through a web browser. It will allow us to update and delete records dynamically using JavaScript and XMLHTTP, without ever having to refresh the page....
|
|
|
|
Total Hits: 1075 | Today: 0 |
Author: Glenn Barres
|
Rating:
|
|
|
The basis and structure of this code can also be used for many things. The main object we will be working with is a collection object...
|
|
|
|
Total Hits: 2880 | Today: 0 |
|
Rating:
|
|
|
Multiple Recordsets - the ability to stuff multiple SQL query results into one Recordset - is an ADO feature that's few developers are aware of. In this article, we are going to take a look on what a Mutliple Recordset is, exactly, and how it can make your development life easier (and your code more efficient). But before we start examining Multiple Recordsets, let's look at a common task in ASP and how it is handled without using Multiple Recordsets....
|
|
|
|
Total Hits: 3320 | Today: 0 |
|
Rating:
|
|
|
A grid control for ASP written in JavaScript to display recordsets. A grid control for editing databases on the web. It is written for ASP with JavaScript, but should be fully usable from VBScript as well. With just a few lines of code, you will, with this control, be able to edit your data....
|
|
|
|
|
|
|
