title: Is this way sufficient to execute DataSet?
body: <p>I query one of my table using Stored Procedure</p>
  
  <p>Here is an example of method I have. I would like to make sure it's the most sufficient way and in case of 10000 of requests it will not cause overheat and close connection properly.</p>
  
  <pre><code>public DataSet GetDetailsByUserId(int userid)
  {
      var arParms = new SqlParameter[1];
      arParms[0] = new SqlParameter("@UserID", SqlDbType.Int) { Value = userid };
      var dt = SqlHelper.ExecuteDataset(ConfigurationManager.AppSettings["ConnectionString"], CommandType.StoredProcedure, "StoredProcedureName", arParms);
                  return dt.Tables.Count == 0 ? null : dt;
  
  }
  </code></pre>