Tags → With Sql Statement

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
• Tags
  • if sql,
  • querystring,
  • select query,
  • sql if,
  • sql includes,
  • sql query string,
  • sql querystring,
  • sql update,
  • sql update statement
• Platforms
  • Windows
• Licenses
  • Freeware

Counting Records In A Database Table

We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be first value of resultset.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Tags
  • count sql statement,
  • database sql,
  • in sql,
  • in sql statement,
  • sql count,
  • sql count statement,
  • sql database,
  • sql table,
  • with sql
• Platforms
  • Linux
• Licenses
  • Freeware

Counting Records In ASP.NET

The following source code displays count of all records in a database. We will use a data command to execute an SQL statement that will return with count of records. Source code written in Visual Basic.NET can easily modify to work in an application.

• Categories
  • ASP.NET →
  • Tips and Tutorials
• Tags
  • in sql,
  • in sql statement,
  • sql code,
  • sql command,
  • sql command execute,
  • sql count,
  • sql count statement,
  • sql return code,
  • with sql
• Platforms
  • Linux
• Licenses
  • Freeware

Edit records with sql statements

Learn how to edit records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Tags
  • learn sql,
  • sql example,
  • sql examples,
  • sql include,
  • sql learn,
  • sql query,
  • sql query examples,
  • sql query string,
  • sql string
• Platforms
  • Linux
• Licenses
  • Freeware

Add records with sql statments

Learn how to add records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Tags
  • learn sql,
  • sql example,
  • sql examples,
  • sql include,
  • sql learn,
  • sql query,
  • sql query examples,
  • sql query string,
  • sql string
• Platforms
  • Linux
• Licenses
  • Freeware

QuickMySQL

QuickMySQL is a powerful little MySQL utility program designed for novices and professionals. Create, drop, view and update tables columns and whole databases in seconds. Features: Connect to and access any localhost database on the same server or an...

• Categories
  • CGI and Perl →
  • Scripts and Programs →
  • Database Tools
• Tags
  • access to mysql,
  • click and drop,
  • connect to remote mysql,
  • count click,
  • mysql count,
  • mysql database,
  • print mysql table,
  • sql count,
  • sql update,
  • sql update statement
• Platforms
  • Linux
• Licenses
  • Freeware

IntrSQL

The Compsys IntrSQL product is a component that allows SQL Statements to be run against almost any database over the Internet. The SQL Statement (along with DSN, Username and Password) are entered via any standard HTML (or ASP) page and the results a...

• Categories
  • ASP →
  • Scripts and Components →
  • Database Tools
• Tags
  • html require,
  • html table to database,
  • in sql statement,
  • oracle sql,
  • sql addition,
  • sql standard,
  • sql statements,
  • sql table,
  • statements
• 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
• Tags
  • asp access,
  • asp access database,
  • asp and sql server,
  • asp performance,
  • asp sql,
  • asp tutorial,
  • sql statement using,
  • sql using,
  • what is sql
• Platforms
  • Linux
• Licenses
  • Freeware

ASP Express

ASP Express allows you the extreme flexibility of an HTML text editor, while giving you the automation of a great ASP and ASP.Net text editor. Key features include: Open your files directly from your web site with built in FTP services, Treeview of A...

• Categories
  • ASP →
  • Software
• Tags
  • asp form,
  • asp text,
  • asp treeview,
  • ftp site,
  • html menus,
  • html treeview,
  • treeview,
  • treeview html,
  • vbscript,
  • web menus
• Platforms
  • Linux
• Licenses
  • Commercial License

SqlFun

SqlFun is a Java program/applet that allows you to experiment with SQL statements (hopefully) without having to install a SQL server or database program. All you need is Java and Windows ODBC (or any other database server that supports JDBC). Startin...

• Categories
  • Java →
  • Applets →
  • Database Tools
• Tags
  • install java,
  • java and sql server,
  • java database,
  • java install,
  • java server,
  • java syntax,
  • sql server from java,
  • sqlfun,
  • statements
• Platforms
  • Linux
• Licenses
  • Freeware

Page:

• 1
• 2
• Next