public Furniture_type UpItem(int Furniture_ID) { string q = "Select * from Furniture_Type Where Furniture_ID =" + Furniture_ID; SqlCommand sc = new SqlCommand(q, Connection.get()); SqlDataReader sdr = sc.ExecuteReader(); Furniture_type u = new Furniture_type(); while (sdr.Read()) { u.Furniture_ID = (int)sdr["Furniture_ID"]; u.Furniture_Type = (string)sdr["Furniture_Type"]; } sdr.Close(); return(u); }
public void dropdown1() { ab.Clear(); SqlCommand a = new SqlCommand("select * from Furniture_Type", Connection.get()); SqlDataReader aa = a.ExecuteReader(); while (aa.Read()) { Furniture_type ao = new Furniture_type() { Furniture_ID = (int)aa[0], Furniture_Type = (string)aa[1] }; ab.Add(ao); } aa.Close(); }
public List <Furniture_type> ShowAll() { string q = "Select * from Furniture_Type"; SqlCommand sc = new SqlCommand(q, Connection.get()); SqlDataReader sdr = sc.ExecuteReader(); List <Furniture_type> lst = new List <Furniture_type>(); while (sdr.Read()) { Furniture_type u = new Furniture_type(); u.Furniture_ID = (int)sdr["Furniture_ID"]; u.Furniture_Type = (string)sdr["Furniture_Type"]; lst.Add(u); } sdr.Close(); return(lst); }