|
15 Seconds : Selecting Records Using ASP - Many end users request some reporting functionality in their desired Web solution. The ability to list records in a table and view them in detail is easily accomplished through the use of HTML and ASP. A common requirement is to build an interface that allows the end user to select a specific category of records “on –the fly” by using a drop-down box or selected category. Another request is to build a “query interface” that permits a user to construct queries without the use of SQL. This article demonstrates one method of using ASP and form posting to build a user interface for selective filtering of records. While the solution presented in this article is rather simple, additional functionality and complexity can be added to any page using the same techniques. URL: http://www.15seconds.com/Issue/990812.htm
|
|
A Nifty Way to Create Connection Strings - If you have ADO installed on your machine all you need to do is the following: Right click on the desktop and choose New; Select the Microsoft Data Link option... URL: http://www.4guysfromrolla.com/webtech/070699-1.shtml
|
|
ActionJackson.com Web Developer Central - ADO & SQL - Comprehensive resource of news, articles, books and links for ASP, ADO/SQL, ADSI/WSH, DHTML, IIS and VID including Discussion Forums, Components, Consultants, ISP's and much more. URL: http://www.actionjackson.com/ado/
|
|
ADO Disconnected Recordsets - The recordset object has to be instructed to use a client-side cursor. This is done by setting the CursorLocation property to adUseClient, which brings the selected data within the recordset down to the client. If the CursorLocation were set to the default adUseServer, all the data within the recordset would reside on the server and be brought to the client as needed. This would necessitate an open connection to the database. URL: http://www.ASPToday.com/default.asp?art=19990701.htm
|
|
ASP 101 - A Database Interfacing Primer - This article describes and illustrates how to use ASP to interact with a MS Access database with user information. An example is used to show how to add, edit and delete records from the database. URL: http://www.vallin.com/pub/1/asp1.asp
|
|
ASP 101 - Database Articles - ASP related Database Articles. URL: http://www.asp101.com/resources/dbarticles.asp
|
|
ASP 101 - Dependent Lists - While developing a Classified Ads application I ran into an interesting issue while building the Submit New Ad form. I wanted to assign a category and a subcategory to the ad (Click here for an Example). I was doing this by using two dropdown lists. The problem arises after you select your choice in the first list. Say you chose Automobiles. In the second list you have subcategories that contain everything but the kitchen sink. Really, you only want the Automobile related subcategories to show up in the list. URL: http://www.asp101.com/resources/DependentLists.asp
|
|
ASP 101 - Recordset Paging with ADO 2.0 - Recordset paging is the process of breaking up a recordset into multiple "pages" of information for display. You've probably noticed that most well designed sites implement this feature, allowing you to navigate through a recordset to view a certain number of records at a time. Breaking the recordset data into pages allows for easy browsing by the user of the application and it also adds a professional touch. When I first started encountering this feature on the web a few years back, I immediately began working on how to implement it for myself. The leisure of being able to casually browse and navigate through the results of a query was wonderfull and a heck of a lot better than having a few hundred records dumped on my browser all at once. ADO 2.0 makes this a very easy feature to implement. URL: http://www.asp101.com/articles/recordsetpaging/index.asp
|
|
ASP/Access Fundamentals - Querying Access using SQL - Active Server Pages allow us an easy means of querying and updating a database from a webpage. This article describes the basics of using this technique in a nutshell. The examples given here utilize a Microsoft Access database, but the principles elucidated apply equally well to ASP integration with other databaes. (Access has been selected because it is widely familiar, easy to use, and adequate for many small to medium-sized projects.) URL: http://www.kamath.com/tutorials/tut001_access.asp
|
Aspin.com - Database  - Comprehensive index of ASP components, applications, scripts, tutorials, and references. Arranged by Reviews, Ratings, price, version, hits and more. URL: http://www.aspin.com/home/tutorial/database?sort=hits&order=desc
|
|
Connecting to a Database - The power of Active Server Pages comes through when we tie databases to our web sites. ASP uses an object library called ActiveX Data Objects, or ADO. ADO can be used to connect to any ODBC-compliant database. ODBC-compliant databases include MS-SQL Server, MS Access, Informix, Oracle,FoxPro, Excel, etc. Chances are, if you are using a modern database, it is ODBC-compliant. URL: http://4guysfromrolla.com/webtech/042599-1.shtml
|
|
Count Records by Juan Llibre, Charles Carroll - This script counts the records in a database. Many people who attempt to use the .recordcount property have the value -1 returned to them. In a nutshell, -1 means "I don't know how many records this query/table contains". It happens since the default cursor type is AdOpenforwardonly (see below for explanation of all cursor types). Here is the script that counts the query results and WILL NOT return -1: URL: http://www.learnasp.com/learn/dbcount.asp
|
|
GetRows or GetString... Don't retrieve data any other way! - If there are 700 records and 3 columsn for example, we have 2,100 database read requests over the wire. Lots of round-trips. URL: http://www.learnasp.com/advice/whygetrows.asp
|
|
How not to count records returned in a Recordset Object - Thou shalt use neither a "counting" loop nor .MoveLast to count the number of records in an ADO recordset. (either set the .CursorType correctly or use a Count() in SQL)
In this article, Phil explains why that commandment is so, and the disadvantages present to using .MoveLast or a counting variable. URL: http://www.4guysfromrolla.com/webtech/120898-1.shtml
|
|
INF: How to Access SQL Server Within Active Server Pages - This article describes how to establish connections to SQL Server within an ASP script using ActiveX Data Objects (ADO), while taking advantage of the connection pooling feature of ODBC 3.0. URL: http://support.microsoft.com/support/kb/articles/Q169/3/77.asp
|
|
Microsoft - ASP FAQ - ActiveX Data Objects (ADO) General Questions - Active Server Pages Frequently Asked Questions
ActiveX Data Objects (ADO) General Questions. URL: http://support.microsoft.com/Support/ActiveServer/faq/data/adofaq.asp
|
|
MIND: Top Ten Tips - Accessing SQL Through ADO and ASP - Microsoft INteractive Developer - Using SQL and ADO to provide data for your Web application can seem daunting, but these ten tips can noticeably improve your results. URL: http://www.microsoft.com/mind/1198/ado/ado.htm
|
|
OLEDB For Me - There are a number of ways to connect to a database. You can use a System DSN, a DSN-less connection, or the native OLEDB provider. Now, many of you may be scratching your heads right now. OLEDB? What in tarnation is that? Well, to answer that we need to look at some database history. URL: http://www.4guysfromrolla.com/webtech/063099-1.shtml
|
|
Paging through Records using a Stored Procedure - Working with my database administrator, I developed a stored procedure for use with SQL Server that puts the burden on the SQL Server to only return the required number of records to the web server instead of the entire database table. This GREATLY reduces the load factor on the web server when making database requests. URL: http://www.4guysfromrolla.com/webtech/062899-1.shtml
|
|
Using ADO+ and C# in the .NET Framework - Part 1 - Through the examples that follow in this article, you’ll have an opportunity to see a few of the many benefits ADO+ will bring to your web application development projects in the near future. These examples will show you how to use ADO+ along with Microsoft’s new C# programming language. URL: http://www.asptoday.com/articles/20000925.htm
|
|
Using ADO+ and C# in the .NET Framework - Part 2 - We left off in Part 1 showing how you can use the Command object in a similar manner in ADO+ as you used to in ADO. We used the two managed providers available with ADO+ to retrieve data from a store, using the DataReader. Now that we’ve covered executing a stored procedure, what if we need to get an output value from a stored procedure? This can easily be accomplished by changing the parameter direction to ParameterDirection.Output as shown below. URL: http://www.asptoday.com/articles/20000926.htm
|
|
Using ASP to Create, Edit, or Delete information in a database. - Using ASP to create, edit, or delete information in a database. These examples demonstrate exactly how to use ASP with a database. Many people have no idea how to do this and that is why this new section is here.
I think these SIMPLE examples would have helped me out a lot when I started out. URL: http://www.powerasp.com/content/database/default.asp
|
|
Using Parameterized Queries in ASP - Using stored procedures will not only make your code more maintainable (through yet another layer of abstraction between your data model and code), but will also increase performance, since SQL caches your stored procedure's execution plans when they are executed for the first time. This article discusses how to use parameterized stored procedures using Acive Server Pages. URL: http://www.4guysfromrolla.com/webtech/111798-1.shtml
|
|
What's in a name? Part I: Naming variables in ASP - In this series I will talk about using some conventions in naming variables, constants and methods. Using a convention is upto your convenience. It only helps you to understand your own code at a later date. Also, using a convention to name objects in the code helps others to understand your code easily and also to debug if necessary. There are hundreds of conventions programmers use and you can probably find these at the beginning of almost any book. URL: http://www.kamath.com/columns/squareone/so001_whatname1.asp
|
Web Developer References