Tags → In Procedure Sql Stored

Using Stored Procedures with MSSQL and ASP.NET 2.0

If you haven''t used MSSQL stored procedures before with SQL Server and in your ASP.NET 2.0 pages then you need to read this article. In this article I will list down basic questions like the following :what is a stored procedure? How can I crea...

• Categories
  • ASP.NET →
  • Tips and Tutorials
• Platforms
  • Windows
• Licenses
  • Other Free / Open Source License

Embedded Sql

This bit allows you to add .sql files to a ASP.Net website or Visual studio project and use a generated class to execute the procedure. The .sql file can be edited in any SQL editor, the generated class has strong type properties to set the paramet...

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

Create a dynamic PDF report with ASP/SQL SERVER

This is the first article of a series that explains how to create a stored procedure and to call it from ASP or directly from SQL Server. The stored procedure will in turn create a simple column based report in PDF without using any external tools or...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Miscellaneous
• Platforms
  • Windows
• Licenses
  • Freeware

EMS SQL Manager 2005 for InterBase/Firebird

EMS SQL Manager for InterBase/Firebird is a powerful tool for InterBase and Firebird administration and development. SQL Manager 2005 is compatible with any Firebird version up to 2.0 and InterBase version up to 7.5 and supports all of the latest fea...

• Categories
  • Tools and Utilities →
  • Database Tools
• Platforms
  • Windows
• Licenses
  • Free Trial

XmlSerializer to Serialize .NET Class to Xml

Learn how to serialize .NET classes to Xml at runtime using System.Xml.Serialization.XmlSerializer. Then, use SQL Server''s OPENXML functionality to bulk load hundreds of records across multiple tables in a single stored procedure call.

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

ASP Data Driven Report

ASP Data Driven Report is an ASP appliation that provides an infrastructure to create and manage various SQL Server stored procedure based reports into HTML output. You can add reports, categorize them in a treeview, edit, delete and manage the repor...

• Categories
  • ASP →
  • Scripts and Components →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware

Fun With Stored Procedures...

This is a brief and very useful tutorial on creating and using stored procedures with your asp applications. A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as oth...

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