public List <MedicineStruct> GetAllMedicineNameIntoStorage() { string query = "SELECT distinct Gyogyszerek.Nev from Gyogyszerek, Raktaron where Raktaron.GyogyszerID = Gyogyszerek.GyogyszerID and Mennyiseg <> '0'", error = string.Empty; SqlDataReader rdr = myExecuteReader(query, ref error); List <MedicineStruct> gyogyszerList = new List <MedicineStruct>(); if (error == "OK") { while (rdr.Read()) { MedicineStruct item = new MedicineStruct(); item.gyogyszerName = rdr[0].ToString(); gyogyszerList.Add(item); } } CloseConnection(); return(gyogyszerList); }
public List <MedicineStruct> GetAllMedicineName() { string query = "SELECT distinct Gyogyszerek.Nev from Gyogyszerek order by Gyogyszerek.Nev", error = string.Empty; SqlDataReader rdr = myExecuteReader(query, ref error); List <MedicineStruct> gyogyszerList = new List <MedicineStruct>(); if (error == "OK") { while (rdr.Read()) { MedicineStruct item = new MedicineStruct(); item.gyogyszerName = rdr[0].ToString(); gyogyszerList.Add(item); } } CloseConnection(); return(gyogyszerList); }