|
|
|
|
|
Total Hits: 80 | Today: 0 |
Author: classicasp.aspfaq.com
|
Rating:
|
|
|
Now, if you have user-defined objects that you'd like automatically created every time you create a new database, put them in the model database. This database is used as a template for new databases....
|
|
|
|
Total Hits: 165 | Today: 0 |
Author: Brett Burridge
|
Rating:
|
|
|
The Transact SQL Coalesce function is an extremely useful piece of syntax to know as it can be used in place of other longer SQL Server syntax.
Given a number of arguments, the Coalesce function will return the first argument that does not have a value of null. Note that if all of the arguments are null, Coalesce itself will return null!
Incidentally, the case function can often be used instead of coalesce - see the article "How to use the SQL Case function"....
|
|
|
|
Total Hits: 64 | Today: 0 |
Author: Ehsanul Haque
|
Rating:
|
|
|
Nowadays, SQL injection is a big threat for websites. It is a technique by which hackers can execute dangerous SQL commands by taking advantage of un-sanitized input opportunities in web application. While there is a good amount of best practices to prevent SQL injection in ASP.NET, ASP has very little information. In this article, Ehsanul examines a quicker and easier way to sanitize input parameters as well as the design plan for a new website to protect from SQL Injection. After a brief intro...
|
|
|
|
Total Hits: 559 | Today: 0 |
Author: ASPalliance
|
Rating:
|
|
|
This code provide you a Quick and easy way to view your database table and data....
|
|
|
|
Total Hits: 344 | Today: 0 |
Author: Sam Moses
|
Rating:
|
|
|
if you are working with large applications where you do a lot of updating. So why not create a dynamic update statement that saves time, and effort, and only needs to be written once.It can be used for any table in any access database.
...
|
|
|
|
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: 186 | Today: 0 |
Author: Faisal Khan
|
Rating:
|
|
|
In this step by step tutorial I will guide you to build the fastest method to display records from the database using plain ASP. The technique we are going to use is based on a simple fact that you don't have to hit database every time you want to display records. Take for example a list box which displays names of countries from the database. How many times you are going to change the countries in the database? I bet not often. So if you have to show those countries from the database then it wi...
|
|
|
|
Total Hits: 509 | Today: 0 |
Author: Abdul (Rajib) Bahar
|
Rating:
|
|
|
Try and Catch is very popular among the developer community writing code in C#, C++, or other high level languages. The conventional term referring to Try-Catch blocks is Exception Handling. Exception Handling is simply a breach of an application's predefined assumptions. It enables us to provide a reliable data/process validation mechanism in our applications. SQL Server did not have any close counterpart for it until now. Prior to SQL Server 2005, many of us relied on the variable @@ERROR. If ...
|
|
|
|
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: 161 | Today: 0 |
Author: Maurice Calvert
|
Rating:
|
|
|
Just solved this problem last night and thought I'd share it with you. I't happened to me several times, so maybe someone out there has had a similar experience.You've just imported a stack of tables from another system (mainframe, DB4, whatever) into MSAccess. The data SHOULD be relationally coherent, but when you start setting up the relationships with Access, they all fail because there are references in foreign tables to primary keys that don't exist. For example, there are orders for custom...
|
|
|
|
Total Hits: 224 | Today: 0 |
Author: Microsoft
|
Rating:
|
|
|
Using SQL and ADO to provide data for your Web application can seem daunting, but these ten tips can noticeably improve your results.
Retrieving data from a SQL Server™ database using ActiveX® Data Objects (ADO) and Active Server Pages (ASP) challenges many Web developers. It can be hard to maximize performance, scalability, and robustness in a specific installation. This article offers specific recommendations to help improve your data access. While much of this information can apply to ot...
|
|
|
|
Total Hits: 2357 | Today: 0 |
|
Rating:
|
|
|
This article describes practical methods of optimizing the performance of ASP pages which retrieve and display tabular data from a database. Test results of each coding technique show the potential for dramatic speedups of dynamic web pages....
|
|
|
|
Total Hits: 493 | Today: 0 |
|
Rating:
|
|
|
By checking for both Beginning Of File (BOF) and End Of File (EOF) then you can be certain that there are no records....
|
|
|
|
Total Hits: 554 | Today: 0 |
Author: CodeAve
|
Rating:
|
|
|
Allowing multiple choices of data observations enables people to customize views of your data and adds value to your applications. Utilizing the where in statement in our sql the comma delimited selections are appended to our sql statement to display only those objects selected....
|
|
|
|
Total Hits: 1105 | Today: 0 |
|
Rating:
|
|
|
One of the hardest things I couldn't figure out when I first started was after the record is created and you wanted a check box to display again as a check box. How to take the value from the database and have the checkbox or radio button be selected...
|
|
|
|
Total Hits: 468 | Today: 0 |
Author: Danny Lesandrini
|
Rating:
|
|
|
Have you ever deleted an Access table ... and then suddenly felt that pain in the pit of your stomach? Well, be of good cheer because all may not be lost. There are at least 2 ways to retrieve your deleted table....
|
|
|
|
Total Hits: 6454 | Today: 0 |
|
Rating:
|
|
|
A data access page is an HTML page that has an Office Web Component embedded into it. The Office Web Component stores connection information about a data source. This article describes how to use data access pages to connect an HTML page to tables in a database.
...
|
|
|
|
Total Hits: 1742 | Today: 0 |
|
Rating:
|
|
|
If there is a column in your Excel spreadsheet that contains both text and numbers, the ISAM will not be able to correctly interpret which datatype it should be. Make sure that all the cells in a column are formatted to be the same datatype. For example, you might have following data in four columns in an Excel sheet...
|
|
|
|
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: 1195 | Today: 0 |
|
Rating:
|
|
|
This article helps you build an Active Server Pages (ASP) page, which you can use anytime, anywhere to get the latest schema in today''s most accepted file format: HTML. So, whenever a development team member changes any part of the schema, the page will reflect the changes at the next access, even if the time gap between the change and the access is as short as a second. Because this page becomes a part of your Web-based database project and thus is available on your development Web server.....
|
|
|
|
|
|
|
