title: Connection.Open() necessary when calling stored procedure?
body: <p>Normaly I would use either "Using" or just connection.open() and connection.close(). But when I'm calling stored procedure, this is not needed. How come? (Yes the codesnippit below works without using or open).        </p>
  
  <pre><code>try {
      SqlCommand cmd = new SqlCommand("***", connectionSiteDb);
      DataTable dt = new DataTable();
      cmd.CommandType = CommandType.StoredProcedure;
      cmd.Parameters.Add(new SqlParameter("@ProcessSegmentID", ProcessSSegmentID));
      cmd.Parameters.Add(new SqlParameter("@PO_RecipeID", PO_RecipeID));
      cmd.Parameters.Add(new SqlParameter("@ProductSegmentVersion", ProductSegmentVersion));
  
  
      SqlDataAdapter da = new SqlDataAdapter();
      da.SelectCommand = cmd;
      da.Fill(dt);
      return dt;
  }
  catch (Exception e) {
       Console.WriteLine(e);
       return null;
  }
  </code></pre>