Counting Records In A Database

Top Tutorials

New Tutorials

Submit

Login

Register

Tutorial Detail

• Total Hits: 2939

• Average Rating :
  

•  

• Total Votes: 42 votes

• Category: ASP/Database Concepts

• Submitted on: 2008-03-06 09:17:00

• Submitted By: Devesh Khanna

• Set as Favorite

Description:

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.

Database connection strings :
dim strConnection
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db/our_db.mdb")
'strConnection = "Provider=SQLOLEDB;Server=ASP;User ID=sa;Password=;Database=MY_DB;"    More detail...

Rating Detail

Stars	Percentage	Total Vote
	14.29%	6
	14.29%	6
	14.29%	6
	14.29%	6
	26.19%	11

Caste Your Vote

Rating	Selection	Guidelines
Poor:		Very disappointing, useless.
Fair:		Below average, disappointing but not useless.
Good:		About average in its class.
Very Good:		Above average for its category.
Excellent:		One of the best Tutorials in its category.

---