yield_usage

public IEnumerable<OdbcDataReader> ReadFile(string strExcelPath, string strWorkSheetName)
{
	OdbcConnection connODBC = new OdbcConnection("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" + strExcelPath + ";DefaultDir=c:\\;");
	OdbcDataReader readerODBC = null;
	connODBC.Open();
	OdbcCommand commandODBC = new OdbcCommand("select * from [" + strWorkSheetName + "$]", connODBC);
	readerODBC = commandODBC.ExecuteReader();

	while (readerODBC.Read())
	{
		yield return readerODBC;
	}

	if (readerODBC != null)
	{
		readerODBC.Close();
		readerODBC.Dispose();
	}

	connODBC.Close();
	connODBC.Dispose();
}