select COUNT function

Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'COUNT'.

Source Error:


Line 71: Dim co As String = "SELECT COUNT [f0011AccNumber] FROM [t0011Journal]"
Line 72: sqlCom1 = New SqlCommand(co, sqlConn)
Line 73: Dim sqlReader2 As SqlDataReader = sqlCom1.ExecuteReader()
Line 74: bil = sqlReader2.Read()
Line 75: bil = bil + 1


can sombody make correct this code.\ bcoz i got error : invalid column name COUNT.

COUNT is not a table but function to calculate number of record..

Code:

---

Dim co As String = "SELECT COUNT (f0011AccNumber) FROM t0011Journal"

---

COUNT is a function and its parameter list must be enclosed parentheses:

Code:

---

SELECT COUNT([f0011AccNumber]) FROM [t0011Journal]

---

Also, there's no point specifying a column to COUNT as the number of records is the regardless:

Code:

---

SELECT COUNT(*) FROM [t0011Journal]

---