SQL produces different results, on a re-start
Posted on 2006-03-23
I have an SQL query which works fine when I start my program, and my close scrutiny tells me it's okay. But when the program's allowed to run, it misses new orders, but on a subsequent restart, my program finds them. Could I be doing something wrong with the connection?
if ( sqlDataAdapter == null || dataSet == null )
pulseOrderHistory = new PulseOrderHistory( Handles, connectString );
sqlDataAdapter = new SqlDataAdapter( sql, connectString );
dataSet = new DataSet();
sqlDataAdapter.Fill( dataSet, "Orders" );