Hi AnkitPal,
You can do it like below.
DECLARE @TableName AS TABLE(SN INT IDENTITY,Name VARCHAR(10) NULL,Status VARCHAR(10) NULL)
INSERT INTO @TableName VALUES('Test','Hold')
INSERT INTO @TableName VALUES('Test',NULL)
INSERT INTO @TableName VALUES('Test2',0)
INSERT INTO @TableName VALUES('Test1',1)
INSERT INTO @TableName VALUES('Test',NULL)
Select COUNT(*) SN from @TableName where Name='Test' and Status IS NULL
C#
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString);
SqlCommand UCEcmd = new SqlCommand("Select COUNT(*) SN from TableName where Name='" + lbl_OrgName.Text + "' and Status IS Null", cnn);
cnn.Open();
lblCount.Text = UCEcmd.ExecuteScalar().ToString();
cnn.Close();
