Tags → Sql Code Sample

IP2Location DB11

This is ASP script to enable lookup of country, region, city, latitude, longitude,zip code and Timezone from IP address by using IP2Location database. Free sample database available at http://www.ip2location.co m. The script supports several d...

• Categories
  • ASP →
  • Scripts and Components →
  • Database Tools
• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Mac OSX,
  • Sun Solaris
• Licenses
  • Free Trial

How to use SCOPE_IDENTITY() in ASP.NET

In this code sample we will take a look at how to use SCOPE_IDENTITY() in ASP.NET. We use this function to get new ID of inserted record from SQL database. .

• Categories
  • ASP.NET →
  • Tips and Tutorials
• Platforms
  • Windows
• Licenses
  • Freeware

SweetSuite.NET Exception Component (ssException)

Royalty-free implementation, unlimited projects. This component will help you track issues in your projects with the information you need to troubleshoot. It contains many details about the exception. Information such as when the exception occurred; ...

• Categories
  • ASP.NET →
  • Scripts and Controls →
  • Error Handling
• Platforms
  • Windows
• Licenses
  • Commercial License

SweetSuite.NET Data Component (ssData)

ssData has useful methods that allow you to clean data before inserting; converting a .NET DateTime object to a SQL Server universal date time format; Boolean to SQL Server Bit conversion; dealing with DataSets, SqlDataReader; and others that will he...

• Categories
  • ASP.NET →
  • Scripts and Controls →
  • Database Tools
• Platforms
  • Windows
• Licenses
  • Commercial License

Custom Paging in ASP

This source code displays results dividing to pages. Code provides Next Previous page links with numeric page numbers. You may modify source code to use with MS SQL or MS Access database. For this example, we have used MS SQL Server using sample data...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

Display an Excel DB

The author writes &"For small data bits on a server where the chance for significant simultaneous traffic is not likely excel can perform many of the basic tasks that can be accomplished in Access or SQL Server, but on a much smaller scale.&...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Excel and ASP
• Platforms
  • Linux
• Licenses
  • Freeware

PHP and MySQL Web Development

PHP and MySQL Web Development teaches the reader to develop dynamic, secure e-commerce Web sites and Web applications. The book shows how to integrate and implement these technologies by following real-world examples and working sample projects. It a...

• Categories
  • PHP →
  • Books
• Platforms
  • Linux
• Licenses
  • Freeware

Integrating User Search with ASP and SQL Server Full-Text Search

This article provides sample source code for a user query parser which allows users to submit full-text search queries from ASP to SQL Server 2000. Full source code available for download.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

Presentation Of Hierarchical Data

Multiple level select boxes tackled with hierarchical data! This sample illustrates the concept using a hierarchy consisting of geographical region, country, and state data. The code expects a system DSN by name &"Hierarchy&" and ac...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

Core PHP Programming

Core PHP Programming is the first complete, practical guide to PHP 3.x for experienced Web developers. Discover how PHP borrows the best ideas from Java, Perl, and C to create a remarkably productive scripting environment. Then, with the guidance of ...

• Categories
  • PHP →
  • Books
• Platforms
  • Linux
• Licenses
  • Freeware