public ArrayList select(String sql) { con = connect("COOK_BOOK"); this.sql = sql; SqlCommand com = new SqlCommand(sql, con); SqlDataReader reader = com.ExecuteReader(); ArrayList ingNames = new ArrayList(); Ingredients c = null; while (reader.Read()) { c = new Ingredients(); reader.Read(); c.IngredientID = Convert.ToInt32(reader["ingid"]); c.Name = Convert.ToString(reader["name"]); c.Quanity = Convert.ToInt32(reader["quanity"]); c.Unit = Convert.ToString(reader["unit"]); ingNames.Add(c); } return(ingNames); }
public int update(Ingredients i) { SqlParameter idParam = new SqlParameter("@ingid", SqlDbType.BigInt, 10); SqlParameter nameParam = new SqlParameter("@name", SqlDbType.Text, 50); SqlParameter quanParam = new SqlParameter("@quanity", SqlDbType.Text, 100); SqlParameter unitParam = new SqlParameter("@unit", SqlDbType.Text, 1000); idParam.Value = i.IngredientID; nameParam.Value = i.Name; quanParam.Value = i.Quanity; unitParam.Value = i.Unit; con = connect("COOK_BOOK"); sql = "update into Ingredients set name = @name, quanity = @quanity, unit = @unit where ingredientid = @ingid"; SqlCommand com = new SqlCommand(null, con); com.CommandText = sql; com.Parameters.Add(nameParam); com.Parameters.Add(quanParam); com.Parameters.Add(unitParam); com.Prepare(); int res = com.ExecuteNonQuery(); return(res); }
internal static void Add(Ingredients value) { throw new NotImplementedException(); }