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

Hi,

Iam Prabhu, not Abhishek .its ok.

Sql Server doesn't allow double quotes to define String.
use Single quotes to represent String.

Try following,

//import .Net Package to your Class

using System.Data;
using System.Linq;
using System.Data.SqlClient;


String ConnectionString = "Provide your Database Connection String Here"; // must provide connection string in double quotes
SqlConnection loadCon = new SqlConnection(ConnectionString);
String selQuery = "Select count(name) from tablename where tablename.name = 'blackdiamond'"; //change the query as you like
SqlCommand loadCom = new SqlCommand(selQuery);
int count=0;
 
try
{
  loadCon.Open();
  loadCom.Connection = loadCon;
  SqlDataReader reader = loadCom.ExecuteReader();
  if (reader.HasRows)
  {
  while (reader.Read())
  {
 ++count;
  }
  }
 }
 catch (Exception e)
 {
  MessageBox.Show(e.Message);
 }
 finally
 {
  loadCom.Parameters.Clear();
  loadCom.Dispose();
  loadCom = null;
    loadCon.Close();
 }