title: Fill Dataset Async
body: <p>Below method is getting used to fill Dataset.</p>
  
  <p>if we are calling this method in synchronous way it is working fine.</p>
  
  <p>But now we need to call this method in Asynchronous way.so what changes i need to do so that below method should work properly without any issue.</p>
  
  <pre><code>public DataSet Filldata(string ProcName, string TableName)
  {
      DataSet ds = new DataSet();
      try
      {
          da = new SqlDataAdapter(ProcName, con);
          if (con.State != ConnectionState.Open)
          {
              con.Open();
          }
          da.SelectCommand.CommandTimeout = 15000;
          da.Fill(ds, TableName);
      }
      catch (Exception ex)
      {
          ErrorMsg = ex.Message.ToString();
          HMISLogger.logger.Error(ex.Message.ToString() + " " + ProcName, ex);
      }
      finally
      {
          con.Close();
          da.Dispose();
      }
      return ds;
  }
  </code></pre>