dhivya pm

dhivya pm

  • NA
  • 10
  • 18.7k

How To get this Count Query in C#.net .

Apr 4 2013 2:16 AM
the below coding getting execute but the value was not printing in screen

 protected void Button1_Click(object sender, EventArgs e)
    {
        if (CheckBox1.Checked)
        {
           
            string OIMSquery = "SELECT COUNT(name) AS PolicySold FROM TestDate WHERE name='divi'";
            SqlCommand OIMScmd = new SqlCommand(OIMSquery, OIMS_01);
            OIMS_01.Open();
            OIMScmd.ExecuteNonQuery();
            OIMS_01.Close();
         
            
        }
       
    }

Answers (3)