Dim db As New TestDataContext Dim tcs = (From p In db.tblTests _where p.site="dotnetspider" _ Select p ).count() response.write(tcs)