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