private static DataSet RunThread2(string ConnectionString, string CommandText, CommandType commType, SqlParameterCollection Parameters) { // Create the delegate. AsynchDataSet caller = new AsynchDataSet(GetDataSet); // Initiate the asychronous call. IAsyncResult result = caller.BeginInvoke(ConnectionString, CommandText, commType, Parameters, GetGlobalInputs(), null, null); // Wait for the WaitHandle to become signaled. result.AsyncWaitHandle.WaitOne(); // Call EndInvoke to retrieve the results. DataSet dResult = caller.EndInvoke(result); // Close the wait handle. result.AsyncWaitHandle.Close(); caller = null; result = null; return(dResult); }
private static DataSet RunThread2(string ConnectionString, string CommandText, CommandType commType, SqlParameterCollection Parameters) { // Create the delegate. AsynchDataSet caller = new AsynchDataSet(GetDataSet); // Initiate the asychronous call. IAsyncResult result = caller.BeginInvoke(ConnectionString, CommandText, commType, Parameters, GetGlobalInputs(), null, null); // Wait for the WaitHandle to become signaled. result.AsyncWaitHandle.WaitOne(); // Call EndInvoke to retrieve the results. DataSet dResult = caller.EndInvoke(result); // Close the wait handle. result.AsyncWaitHandle.Close(); caller = null; result = null; return dResult; }