Shared Tutorials
Tutorials Shared by the Internet Community
Advertisements
| Top Tutorials | New Tutorials | Submit | Login | Register |
Tutorial Basic Detail
Counting Records In A Database
We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine.http://www.dotnetindex.com/articles/51_Counting_Records_In_A_Database_Table.asp
Total Hits: 2907
Total Votes: 42 votes
Average Rating: 2.74 out of 5
Category: ASP/Database Concepts
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;"
Rating Detail
| Stars | Percentage | Total Vote |
|---|---|---|
![]() |
![]() ![]() 14.29% |
6 |
![]() ![]() |
![]() ![]() 14.29% |
6 |
![]() ![]() ![]() |
![]() ![]() 14.29% |
6 |
![]() ![]() ![]() ![]() |
![]() ![]() 14.29% |
6 |
![]() ![]() ![]() ![]() ![]() |
![]() ![]() 26.19% |
11 |




14.29%

14.29%

14.29%

14.29%

26.19%