Форум программистов [Powered by Invision Power Board]

Код


public void AsyncQuery(string select)
        {
            cmd = new SqlCommand(select, conn);
            conn.Open();
            AsyncCallback callback = new AsyncCallback(DataReaderIsReady);
            IAsyncResult AsyncResult = cmd.BeginExecuteReader(callback, cmd);
        }

private void DataReaderIsReady(IAsyncResult result)
        {
            try
            {
                //Event fire
                OnStatusChenged(this, new EventArgs());
               
                cmd = (SqlCommand)result.AsyncState;
                SqlDr = cmd.EndExecuteReader(result);

                foreach (DbDataRecord rec in SqlDr)
                {
                    DataList.Add(rec);
                }                
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString());
            }
            finally
            {
                Dispose();
            }
        }