command.CommandText = "SELECT * FROM CAR";
//Create new SqlDataReader object and read data from the command.
using (OdbcDataReader reader = command.ExecuteReader())
* Get and cast the ID
int counter = 0;
while (reader.Read() && counter < numberOfOrders)
SalesOrder s = new SalesOrder();
s.abNR = reader["Auftrags Nr."].ToString();
s.artNr = reader["Artikel nr."].ToString();
s.quantity = reader["Menge"].ToString();
s.city_country_Coustomer = reader["Stadt"].ToString();
}