//Hakee IDn perusteella datan public Vaneri SelectId(int id) { sql = "Select * from mydb.Vaneri Where VaneriId='" + id + "';"; command = new SqlCommand(sql, cnn); dataReader = command.ExecuteReader(); dataReader.Read(); int.TryParse(dataReader.GetValue(0).ToString(), out id); koko = dataReader.GetValue(1).ToString(); float.TryParse(dataReader.GetValue(2).ToString(), out hinta); int.TryParse(dataReader.GetValue(3).ToString(), out maara); yksikko = dataReader.GetValue(4).ToString(); int.TryParse(dataReader.GetValue(5).ToString(), out sijainti); kauppa = dataReader.GetValue(6).ToString(); lisatiedot = dataReader.GetValue(7).ToString(); dataReader.Close(); Vaneri v = Vaneri.Create(id, koko, hinta, maara, yksikko, sijainti, kauppa, lisatiedot); return(v); }
//Lukee kaiken datan taulusta public List <Vaneri> SelectAll(List <Vaneri> vanerit) { sql = "Select * from mydb.Vaneri;"; command = new SqlCommand(sql, cnn); dataReader = command.ExecuteReader(); while (dataReader.Read()) { int.TryParse(dataReader.GetValue(0).ToString(), out id); koko = dataReader.GetValue(1).ToString(); float.TryParse(dataReader.GetValue(2).ToString(), out hinta); int.TryParse(dataReader.GetValue(3).ToString(), out maara); yksikko = dataReader.GetValue(4).ToString(); int.TryParse(dataReader.GetValue(5).ToString(), out sijainti); kauppa = dataReader.GetValue(6).ToString(); lisatiedot = dataReader.GetValue(7).ToString(); Vaneri v = Vaneri.Create(id, koko, hinta, maara, yksikko, sijainti, kauppa, lisatiedot); vanerit.Add(v); } dataReader.Close(); return(vanerit); }