I had to come up with a method that retrieved the subdomain from the current web request on an ASP.NET website.
How to Use SQLXML to Retrieve Data From SQL Server Database?
Using SQL Server 2000 and above versions you can retrieve data from SQL Server in XML format directly from the database.
Retrieve the Autonumber Value in Access using C#
This sample deals with the retrieval of the value of the Autonumber field for a data row inserted in MS Access 2000. SQL Server provides access to new Identity values through SCOPE_IDENTITY, IDENT_CURRENT and @@IDENTITY based on the scope and session boundaries. In Jet 4, Microsoft added support for ANSI-92 SQL syntax, including support for @@IDENTITY. This feature can be very useful in the Internet mode. Typically, you will be able to identify and access rows inserted from Web pages and manipulate the newly added rows.
Retrieve quick results with ASP/XML and XSL
Recently I was working on a new Project about ASP along with XML/XSL. I recognized that ASP with XML is a very powerful tool and that was the main reason I wrote this article.