C#

SELECT COUNT survey FROM ResultsTbl WHERE survey = @surveyNum

sqlTotal= "SELECT COUNT(survey@SrNo) FROM ResultsTbl "+<br />
"WHERE survey@SrNo<>0";<br />
cmdTotal.Parameters.Add("0", survey@SrNo);

public void CalcResults(int SrNo, out int total, out int Ans1, out int Ans2, out int Ans3)
		{
			string sqlTotal;
			string sqlAns1;
			string sqlAns2;
			string sqlAns3;
			
			//SQL statements
			if (SrNo>=1 & SrNo<=3) 
			{
				sqlTotal= string.Format("SELECT COUNT(survey2) FROM ResultsTbl WHERE survey{0}<>0",SrNo);
				sqlAns1= string.Format("SELECT COUNT(survey2) FROM ResultsTbl WHERE survey{0}=1",SrNo);
                sqlAns2= string.Format("SELECT COUNT(survey2) FROM ResultsTbl WHERE survey{0}=2",SrNo);
				sqlAns3= string.Format("SELECT COUNT(survey2) FROM ResultsTbl WHERE survey{0}=3",SrNo);
			}
			
			else
				sqlAns1=sqlAns2=sqlAns3=sqlTotal="No answer was chosen"; 
		
			//Command objects
			OleDbCommand cmdTotal = new OleDbCommand(sqlAns1, cnSurvey);
			OleDbCommand cmdAns1=new OleDbCommand();
			OleDbCommand cmdAns2=new OleDbCommand();
			OleDbCommand cmdAns3=new OleDbCommand();



			cmdTotal.Connection = cnSurvey;
			cmdTotal.CommandType = CommandType.Text;
			cmdTotal.CommandText = sqlTotal;

			cmdAns1.Connection = cnSurvey;
			cmdAns1.CommandType = CommandType.Text;
			cmdAns1.CommandText = sqlAns1;

			cmdAns2.Connection = cnSurvey;
			cmdAns2.CommandType = CommandType.Text;
			cmdAns2.CommandText = sqlAns2;

			cmdAns3.Connection = cnSurvey;
			cmdAns3.CommandType = CommandType.Text;
			cmdAns3.CommandText = sqlAns3;

			//Connect
			cnSurvey.Open();

			//Execute command
			total = int.Parse(cmdTotal.ExecuteScalar().ToString());
			Ans1 = int.Parse(cmdAns1.ExecuteScalar().ToString());
			Ans2 = int.Parse(cmdAns2.ExecuteScalar().ToString());
			Ans3 = int.Parse(cmdAns3.ExecuteScalar().ToString());
				
			//Disconnect
			cnSurvey.Close();
		}

static extern bool Beep(uint dwFreq, uint dwDuration);