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);
}
