public int CompareTo(Object obj) { if (obj == null) { return(1); } VendorsTable other = obj as VendorsTable; return(this.vendor.CompareTo(other.vendor)); }
public List <VendorsTable> GetVendors(bool unique = true) { connection.Open(); var command = new OleDbCommand(); command.Connection = connection; command.CommandText = "select * from Vendors"; var reader = command.ExecuteReader(); List <string> str = new List <string>(); try { while (reader.Read()) { var v = reader.GetString(1); if (unique) { if (!str.Contains(v)) { str.Add(v); } } else { str.Add(v); } } } catch (Exception e) { } finally { str.Sort(); reader.Close(); connection.Close(); } List <VendorsTable> vendors = new List <VendorsTable>(); foreach (string s in str) { VendorsTable vendor = new VendorsTable(); vendor.vendor = s; vendors.Add(vendor); } return(vendors); }