How to wait for a completed query

  • Thread starter Thread starter Andrew Mueller
  • Start date Start date
A

Andrew Mueller

Hello,

I have the following code:


DataSet myDataSet = new DataSet();

OleDbDataAdapter adapter = new OleDbDataAdapter(sb.ToString(),myConn);

adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

int count = adapter.Fill(myDataSet,"ihrawdata");

foreach (DataTable table in myDataSet.Tables)
{
foreach (DataRow row in table.Rows)
{
return Convert.ToString(row[0]);
}
}
return "NONE";
}


How do I wait for the query to have completed before attempting to fill the
dataset object? I think I am running into a timing issue of trying to fill
to fast because I am making many successive queries and I would like to test
my theory.

Thanks!

PS - Thread.Sleep does not work because it stops everything apparently. I
do not want to stop the query process, just wait for the completed data from
my table, ihrawdata.

Andrew Mueller
 
Andrew, due to the way that the OLEDataAdapter.Fill() works you don't need
to worry that you are accessing the data too quickly. Once Fill returns all
of the data is available. What exactly are you seeing that leads you to
your conclusion?
 
Hello,

I have the following code:


DataSet myDataSet = new DataSet();

OleDbDataAdapter adapter = new
OleDbDataAdapter(sb.ToString(),myConn);

adapter.MissingSchemaAction =
MissingSchemaAction.AddWithKey;

int count = adapter.Fill(myDataSet,"ihrawdata");

foreach (DataTable table in myDataSet.Tables)
{
foreach (DataRow row in table.Rows)
{
return Convert.ToString(row[0]);
}
}
return "NONE";
}
Click to expand...

Andrew,

I don't mean to be insulting, but that's some odd code. Why are you
"return"ing from w/i the foreach loop? Is the OleDbConnection
"myconn" not being closed properly because of the return statement?


Chris.
 
No insult taken... I know I don't have to go through the foreach statements
like I did, but this is all testing code and I have not made it 'look
pretty' yet. I can certainly move the return statement out of the foreach if
that helps..

I was told that the adapter will open and close the connection for me in
another posting, so I took that out. It had no effect on the situation at
all.

Thanks,

Andrew Mueller


Chris R. Timmons said:
Hello,

I have the following code:


DataSet myDataSet = new DataSet();

OleDbDataAdapter adapter = new
OleDbDataAdapter(sb.ToString(),myConn);

adapter.MissingSchemaAction =
MissingSchemaAction.AddWithKey;

int count = adapter.Fill(myDataSet,"ihrawdata");

foreach (DataTable table in myDataSet.Tables)
{
foreach (DataRow row in table.Rows)
{
return Convert.ToString(row[0]);
}
}
return "NONE";
}
Click to expand...

Andrew,

I don't mean to be insulting, but that's some odd code. Why are you
"return"ing from w/i the foreach loop? Is the OleDbConnection
"myconn" not being closed properly because of the return statement?


Chris.
Click to expand...
 
Back
Top