|
|
|
|
|
Total Hits: 6175 | 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: 2677 | 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: 5701 | Today: 0 |
|
Rating:
|
|
|
Explains everything in detail you''ll ever need to konw about creating Stored Procedures in Access Database and then calling from within ASP. Select, Update, Insert and Delete Stored Procedures are described. Sample code and database available for download....
|
|
|
|
Total Hits: 1075 | Today: 0 |
|
Rating:
|
|
|
Performance tuning and optimization techniques for Microsoft SQL Server, including SQL/ASP performance tips....
|
|
|
|
Total Hits: 199 | 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: 2200 | 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: 696 | Today: 0 |
Author: OpenX
|
Rating:
|
|
|
This sample shows how to retrieve TEXT/IMAGE fields from the database using OpenX v2.0 for MS SQL Server....
|
|
|
|
Total Hits: 450 | Today: 0 |
Author: ASPalliance
|
Rating:
|
|
|
This code provide you a Quick and easy way to view your database table and data....
|
|
|
|
Total Hits: 430 | 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: 524 | Today: 0 |
Author: rogrammersresource.com
|
Rating:
|
|
|
This creates a new table named tblCustomer with the fields FirstName and LastName as text, and the field Age as number....
|
|
|
|
Total Hits: 990 | 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: 364 | Today: 0 |
Author: Philip Quinn
|
Rating:
|
|
|
If your web server is part of a server-farm or you want additional security/control, then you can use web.config and SQL Server to store user session information in SQL Server....
|
|
|
|
Total Hits: 1616 | 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: 1563 | Today: 0 |
|
Rating:
|
|
|
If you are working with the Enterprise Edition of Microsoft Visual Studio®, Visual InterDev includes an SQL debugger that you can use to debug SQL Server stored procedures and triggers in much the same way that you debug other kinds of scripts or programs. However, there are some differences in how you set up SQL debugging and how the debugger runs....
|
|
|
|
Total Hits: 2068 | Today: 0 |
|
Rating:
|
|
|
Full text indexing is a great feature that solves a long running database problem, the searching of textual data columns for specific words and phrases in SQL Server databases. However, as the full-text search engine is a separate component of SQL Server (it uses the Microsoft Search Service) this can be a potential performance problem due to the way full-text search interacts with SQL Server. Full-text search works really well when you are searching...
|
|
|
|
Total Hits: 6321 | Today: 0 |
|
Rating:
|
|
|
ASP tips using Microsoft Access and IIS Server extensions...
|
|
|
|
Total Hits: 2217 | Today: 0 |
|
Rating:
|
|
|
Once you go beyond the basics in ASP—scripting some fancy output—the next thing you usually want to do is access a database and display data from it.
...
|
|
|
|
Total Hits: 607 | Today: 0 |
|
Rating:
|
|
|
This article describes how to embed the Microsoft Data Analyzer ActiveX Control in Web pages hosted by Microsoft FrontPage, a Web site based on SharePoint Team Services by Microsoft, a SQL Server Digital Dashboard 3.0 dashboard, or Microsoft SharePoint Portal Server....
|
|
|
|
Total Hits: 874 | Today: 0 |
|
Rating:
|
|
|
In certain cases, you may want to determine if a Primary Key is defined on an underlying database table and if so, what columns are used in that Primary Key. You can obtain this information by using Microsoft ActiveX Data Objects Extensions for Data Definition Language and Security (ADOX), which is an extension to ActiveX Data Objects (ADO) that allows the manipulation of the database schema....
|
|
|
|
Total Hits: 1219 | Today: 0 |
|
Rating:
|
|
|
Here's how you can build a simple but powerful Web search tool for your data warehouse or database. For this project, you use basic HTML input objects to collect the search criteria. After your Web server receives the parameters, they are included in an EXEC statement that calls a stored procedure. After executing, this stored procedure returns a recordset, which the server formats into HTML.....
|
|
|
|
|
|
|
