How to count the data in sql server using data adapter?

Question

hi everyone,

How to count the inside the sql server using dataadapter...for ex...i hava a many  blackdiamond name in my database....how to count how many blackdiamond inside my table....