/// <summary> /// Procedure to update the expiry date of a product /// </summary> /// <param name="reference">the product's reference</param> /// <param name="expiryData">the expiry date</param> public void UpdateExipryDate(string reference, DateTime expiryData) { SqlCeConnection conn = null; try { string sqlconnection = ("Data Source =" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\InventoryDB.sdf;")); using (conn = new SqlCeConnection(sqlconnection)) { conn.Open(); SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from Products where Reference ='" + reference + "'"; SqlCeResultSet rs = cmd.ExecuteResultSet(ResultSetOptions.Updatable | ResultSetOptions.Scrollable); SqlCeUpdatableRecord rec = rs.CreateRecord(); if (true == rs.ReadAbsolute(0)) { rs.SetDateTime(3, expiryData); rs.Update(); } } } finally { conn.Close(); } }