public string Next() { string str; if (this.int_0 != this.ilist_0.Count) { EnumBSTRClass int0 = this; int0.int_0 = int0.int_0 + 1; str = this.ilist_0[this.int_0 - 1].ToString(); } else { str = null; } return(str); }
public IEnumBSTR Categories(string string_1) { IEnumBSTR enumBSTR; IEnumBSTR enumBSTRClass = new EnumBSTRClass(); if (this.iarray_0.Count != 0) { try { for (int i = 0; i < this.iarray_0.Count; i++) { string str = this.iarray_0.Element[i].ToString(); OleDbConnection oleDbConnection = new OleDbConnection(string.Concat("Provider=Microsoft.Jet.OLEDB.4.0;Data source= ", str)); oleDbConnection.Open(); string str1 = string.Concat("SELECT DISTINCT(Category) FROM [", string_1, "]"); IDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter(str1, oleDbConnection); DataSet dataSet = new DataSet(); oleDbDataAdapter.Fill(dataSet); oleDbConnection.Close(); for (int j = 0; j < dataSet.Tables[0].Rows.Count; j++) { try { (enumBSTRClass as IBStringArray).AddString(dataSet.Tables[0].Rows[j][0].ToString()); } catch { } } } } catch { } enumBSTR = enumBSTRClass; } else { enumBSTR = enumBSTRClass; } return(enumBSTR); }