internal static int udpdateowlingStyle(clsBowlingStyle BowlingStyle) { int result = 0; SqlCeCommand com = new SqlCeCommand("UPDATE tblBowlingStyle set styleName=@p2 WHERE styleId=@p1", connection.CON); com.Parameters.AddWithValue("@p1", BowlingStyle.styleCode); com.Parameters.AddWithValue("@p2", BowlingStyle.styleName); result = com.ExecuteNonQuery(); return(result); }
internal static int addBowlingStyle(clsBowlingStyle BowlingStyle) { SqlCeCommand com = new SqlCeCommand("INSERT INTO tblBowlingStyle VALUES(@p1,@p2)", connection.CON); com.Parameters.AddWithValue("@p1", BowlingStyle.styleCode); com.Parameters.AddWithValue("@p2", BowlingStyle.styleName); try { return(com.ExecuteNonQuery()); } catch (Exception e) { clsMessages.showMessage(clsMessages.msgType.error, e.Message); } return(0); }