Devart Forums

Code: Select all

void doFetch()
{
	MySqlConnection dbConn; // make the connection via direct mode.
	MySqlCommand dbCmd = new MySqlCommand("select * from my_tbl", dbConn);
	
	MySqlDataReader dbReader = dbCmd.ExecuteReader();
	
	try {
		int limit = 10;
		while(dbReader.Read()) { // If the dbReader has 10000 records.
			// do something...
			if (limit++ > 1000) // break here!
				break;
		}	
	} finally {
		if (dbReader != null)
			dbReader.Close(); // VERY SLOW!!!!
	}
}