No Output From The Stored Procedure In The Dataset

Hi
I have this code snippet

[CODE] 
  string connstring = "server=(local);uid=xxx;pwd=xxx;database=test;";
            SqlConnection connection = new SqlConnection(connstring);
            //SqlCommand cmd = new SqlCommand("getInfo", connection);
            SqlDataAdapter a = new SqlDataAdapter("getInfo", connection);
            a.SelectCommand.CommandType = CommandType.StoredProcedure;
            a.SelectCommand.Parameters.Add("@Count", SqlDbType.Int).Value = id_param;
            DataSet s = new DataSet();
            
            a.Fill(s);
            foreach (DataRow dr in s.Tables[0].Rows)
            {
                Console.WriteLine(dr[0].ToString());
            }


[/CODE] 
When I seperately run the  stored procedure getInfo with 2 as parameter, I get the output
But when I run thsi program, it runs successfully but gives no output 
Can someone please help me?