Tags → Sql Stored Procedure

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

ADO.NET Express

ADO.NET Express is an add-in for Visual Studio 2003 that generates class methods for calling stored procedures and executing common types of SQL statements. It supports C#/VB and SQL Server/Oracle. ADO.NET Express looks similar to Server Explore...

• Categories
  • ASP.NET →
  • Software
• 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

SQLView (DotNetNuke Module)

Features include: - specify sql query as a select from a table, view or stored procedure - sorting ascending/descending on each column - customizable formatting for the grid, header row, even row and odd row - display an additional header ...

• Categories
  • ASP.NET →
  • Software
• Platforms
  • Windows
• Licenses
  • Freeware

JSP Hit Counter

This counter uses MS SQL Server to store hits. I have used a custom stored procedure to add and display hit. This is a very good example using stored procedures with JSP.

• Categories
  • Java →
  • JSP and Servlets →
  • Counters →
  • Text Based
• Platforms
  • Linux
• Licenses
  • Freeware

iNextLib

iNextLib makes easy to get data for your ASP.NET web solutions. Without SQL knowledge you can: select, insert, update, delete, count, call stored procedure and much more. 9 public methods to perform basic and professional SQL database queries.

• Categories
  • ASP.NET →
  • Scripts and Controls →
  • Database Tools
• Platforms
  • Linux
• 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

Page:

• 1
• 2
• Next