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..