SqlCommand cmd = new SqlCommand();
            cmd.Connection =  conn;//数据库连接
            cmd.CommandText = "exec a";
             CommandType.StoredProcedure
            cmd.CommandType =// type;
            SqlDataAdapter da = new SqlDataAdapter(cmd);
              da.Fill("table1");

------解决方案--------------------

 SqlCommand cmd = new SqlCommand();
  cmd.Connection =  conn;
cmd.CommandType=CommandType.StoreProcedure
  cmd.CommandText =存储过程名
cmd.execureScalar();

------解决方案--------------------
探讨

C# code


            SqlCommand cmd = new SqlCommand();
            cmd.Connection =  conn;//数据库连接
            cmd.CommandText = "exec a";
             CommandType.StoredProcedure
            ……